How do I display a reference field based on the related list from another reference field

Stacy1 · ‎08-30-2016

I have created a many to many table between locations (cmn_location) and a configuration item we call Branch Office (u_cmdb_ci_branch_office).

Each location can have more than 1 branch associated with it in the related lists.

I have a catalog request where I have the user select the location.

I then want to display only those branches that are in the related list associated to that location.

I have tried 2 dozen different ways very unsuccessfully.

Can someone please tell me exactly what I need to do.

Thank you in advance for your help.

Regards,

Stacy

Abhinay Erra · ‎08-30-2016

I can certainly help you on this. Can you show me a record of (u_cmdb_ci_branch_office table which also includes the related list

Stacy1 · ‎08-30-2016

Hi Abhinay,

I assume you mean you want a picture of the form?

I do not know how to reply on the community, I only have the ability to reply to the original question which is sort of silly.

Here is a screen shot please let me know if I am not giving you what you need.

I just tried to do a reference qualifier to look for a branch that contains the name of my location since my branch names have that info also, we tried 'javascript:'located_atLIKE'+current.variables.located_at;'. But we are still getting the entire list.

So my location variable on my request is called 'located_at'. The branch variable is called 'branch'.

Thanks for your help.

Thank you,

Stacy Menigoz

ServiceNow System Admin II

925.913.1855 Direct | 925.813.5318 Mobile

Robert Half

IT Enterprise Applications

'The secret of change is to focus all of your energy, not on fighting the old but on building the new!'

Abhinay Erra · ‎08-30-2016

What is the field name of location on branch offices table?

Your ref qual on branch variable should be this

javascript: "<field name of location on branch offices table>="+current.variables.located_at;

Stacy1 · ‎08-30-2016

And here is the branch table.