Filter Records in a Reference field based on another Reference Field

Xion
Tera Expert

Hi,

we have two fields on Incident form:

u_data : It is a reference field to the data table(client_data).

u_accName : It refers to sys_accounts table

 

And sys_accounts table also a field ('u_name') which refers to (client_data) table.

 

Now on incident table when a user enters any data in u_data field, I want to capture the sys_id and based on that sys_id, We want to filter data in "u_accName" Field. So all the values matching with sys_id of "u_data" field should be shown in "u_accName" field.

 

It would be better to get the Script Include with reference qualifier for this.

 

 

XION

3 REPLIES 3

Harish KM
Kilo Patron
Kilo Patron

Disny
Giga Contributor

404 error for link

Bart Gilbert
Tera Contributor

Having a similar issue.   I am building a Service Catalog item and I am using a reference field of Service (cmdb_ci_service) as one of my field choices and the next reference field is Service Offering.   Service is  parent of Service Offering and I want the dropdown to be a filtered list of offering based on the preceding Service selected.  Can anyone assist with this?