Reference Qualifier on the same table

[danielbartholom]

Hi I am looking for some help please

I have a Cat Item on the Service Portal that has a lookup select box variable that references the technical system table.

I would like to create a new column on the technical system table called Data Tool Network Path. When I open the form for a selected Technical System

I will then enter the correct path here. There will be different paths for different Technical Systems.

What I am looking for is the correct reference qualifier to present the following on the cat item form

When someone selects a Technical System that has a path applied is there a way I can have this come up a a string field so the requester can see

the path for review on the form?

So on the form, the requester selects a Technical System from the lookup select box

The correct path should then appear in a new variable (string maybe?) below.

To date this has been completed by Catalog UI policies but I am hoping I can streamline this some what.

I hope the above makes sense and any help would be most appreciated. Happy to provide more information if anything is unclear. Even if this does not work on a string variable I am still interested to know how you can run a ref qual on the same table?

[Ashutosh Munot1]

Hey,

Sure, Let me know what it is?

THanks,
Ashutosh

[danielbartholom]

Hi following on from my previous email I have done a mock up in my personal instance. You will see a Javascript error on browser appear when trying the form:

Here is the link to the form:

https://dev32695.service-now.com/sp?id=sc_cat_item&sys_id=bac9bfb20f0303002f55cbdce1050ebd

Here is the link to the console so you review the scripts if required

https://dev32695.service-now.com

Username: ashu

Password: 2)=)T,xQ*Ym~uq//

Let me know if I have made any mistakes?

Thanks

[danielbartholom]

Hi,

I am not able to get on to your dev instance however looking over your previous knowledge shared I have been able to get it working as required.

I do have one additional question though can you enter multiple return fields in one script include against one table? If so what do I need to apply on the catalog UI script to regonise the correct return field to the corresponding variable on the form?

Does that make sense. Up to now I have created individual script includes to return fields from the same table.

Thanks so much for getting back to me