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?

[danielbartholom]

You sir are simply a wizard.

So am I correct that you only updated the client script to get it working?

function onChange(control, oldValue, newValue, isLoading) {

if (isLoading || newValue == '') {

return;

}

//Type appropriate comment here, and begin script below

var ga = new GlideAjax('getUserEmail') ;

ga.addParam('sysparm_name','getApp');

ga.addParam('sysparm_app',newValue);

ga.getXML(hello);

function hello ()

{

var answer = ga.getAnswer();

//alert(answer);

g_form.setValue('network_path',answer); //network_path is your variable where you want to store path

}

}

Basically adding the text within the ga.getXML bit of the script and then followed by the function hello?

[Ashutosh Munot1]

HI Dan,

Yes and you gave wrong field name in script include i corrected that to.

Please close this thread by marking my answer as correct. It will help.

THank you,
Ashutosh

[danielbartholom]

Thanks Ash,

I really appreciate your time to help me with this. I am currently trying to find the Mark As Correct button but I can't find it I will keep looking

I may be in touch in the new year if you don't mind just to work on the script to do the same thing but on a different table, basically how you link them up etc.

Hope that's ok

Thanks again for all your help

Cheers

Dan

[Ashutosh Munot1]

Sure Dan,

See below to mark it correct:

How To Mark Answers Correct From Community Inbox

[danielbartholom]

Hi there,

You very kindly helped me a little while ago to get a network path field to appear on the Service Portal when a Technical System is selected on a form via the Service Portal.

This is working fantastic however I now have a similar scenario required and I tried to copy the code you sent over to me and manipulate however it is not working and I think I am missing something. 

Are you still available to help me please?

Thanks