Service Portal - Getting list of records based on a variable on catalog item

[Harry Campbell2]

Hello All,

I need a bit of help with our 'User Leaving' item. I have asked this previously but I now require a more Service Portal friendly solution. The solution we had when using CMS wasn't great - and wont work at all in the Service Portal, so I'm on the hunt for ideas.

We have a User Leaving item with an 'impacted_user' reference variable. This references the sys_user table.

When a user is entered into this field, I need to display a list of configuration items that the user owns on the catalog item. Could anyone share any ideas on how this could be achieved?

Many Thanks

Harry

[Brad Tilton]

Can you do a glideajax call to a script include that returns the list of CIs back and put them in a field message?

[Harry Campbell2]

Hi Brad,

I could be wrong but I didn't think we could use glideajax on the Service Portal.

If it is possible then I wouldn't know how to do so.

Thanks

Harry

[Brad Tilton]

Yes you can use it.

documentation/client_scripting.md at master · service-portal/documentation · GitHub

GlideAjax - ServiceNow Wiki

[Goran WitchDoc]

Depending on how   you want to display it. You could make a widget that gets the fields value, go back to server and get the CIs and then displays them.
This widget you can put as a variable. To do this you create a Macro Variable(strange I know) but on one of the sections there, you got a widget field where you can point on your newly created widget..

Do you need more than this to get going? I can help you a bit more, but that would sadly be in a day or two.

//Göran