Filter Records in a Reference field based on another Reference Field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2023 04:52 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2023 06:56 PM
Hi you can refer the below example
Harish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2024 05:33 AM
404 error for link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2024 05:32 AM
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?