question Re: Show Display Values from reference field in Glide Record query in Developer forum

Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 14:37:56 GMT

Hi all,

I am trying to run a query on the Agent Client Collectors table and then get the display value of the location field. I have tried with the below script however the result is blank:

var svs = new GlideRecord("sn_agent_cmdb_ci_agent"); svs.addQuery('agent_extended_info.cmdb_ci.sys_class_name', 'cmdb_ci_computer') svs.query(); while (svs.next()) { var loc = svs.getDisplayValue("location"); gs.print(loc); }

If I change the loc variable to show the sys id it prints it perfectly:

var loc = svs.getDisplayValue("sys_id");

From what I can see the issue is because the location field is a referenced field as other reference fields also do the same thing.

One solution I thought of is getting the sys_id and then querying the cmn_location table using that sys_id but this seems inefficient.

Please could someone with a little more scripting knowledge than myself explain why this is happening and if their is a simpler solution than my one proposed above?

Many thanks

Rich

Re: Show Display Values from reference field in Glide Record query

Sai Shravan — Fri, 10 Mar 2023 14:44:21 GMT

Hi @Ryax1 ,

The issue is happening because the "location" field on the "sn_agent_cmdb_ci_agent" table is a reference field.

var svs = new GlideRecord("sn_agent_cmdb_ci_agent"); svs.addQuery('agent_extended_info.cmdb_ci.sys_class_name', 'cmdb_ci_computer'); svs.query(); while (svs.next()) { var loc = new GlideRecord('cmn_location'); loc.get(svs.location.sys_id); gs.print(loc.getDisplayValue()); }

Regards,
Shravan
If my answer solved your issue, please mark my answer as Correct & Helpful

Re: Show Display Values from reference field in Glide Record query

Sai Shravan — Fri, 10 Mar 2023 14:53:22 GMT

Hi @Ryax1 ,

If I've helped guide you correctly in this thread, please also consider marking it as "Accept Solution".

Thanks and take care!

Re: Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 14:56:05 GMT

Hi @Sai Shravan ,

Thanks for the suggestion, this was my thought too but I wasn't sure if there was a more efficient way to do it.

Unfortunately I've just tried the code you suggested and still doesn't return the display value of the location, does this work for you?

Thanks

Rich

Re: Show Display Values from reference field in Glide Record query

Sai Shravan — Fri, 10 Mar 2023 15:04:06 GMT

HI @Ryax1 ,

I have tried on cmdb_ci table, below snippet is for the reference.

Re: Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 15:09:07 GMT

That's strange, I have tried what I believe to be exactly the same code but on the sn_agent_cmdb_ci_agent ttable and get a blank result:

Rich

Re: Show Display Values from reference field in Glide Record query

Sai Shravan — Fri, 10 Mar 2023 15:16:06 GMT

Hi @Ryax1 ,

Please check the actual table name of the location table being referenced in the location field on the sn_agent_cmdb_ci_agent table.

Re: Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 15:26:02 GMT

Yes I've just double checked and confirm it is definitely the cmn_location table being referenced.

Re: Show Display Values from reference field in Glide Record query

Ankur Bawiskar — Fri, 10 Mar 2023 15:28:15 GMT

@Ryax1

can you try this?

var svs = new GlideRecord("sn_agent_cmdb_ci_agent");
svs.addQuery('agent_extended_info.cmdb_ci.sys_class_name', 'cmdb_ci_computer');
svs.query();
while (svs.next()) {

var loc = svs.location.getDisplayValue();
gs.print(loc);
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 15:30:51 GMT

Hey @Ankur Bawiskar ,

No luck with that code either I'm afraid, still returns blank like before 😞

Richard

Re: Show Display Values from reference field in Glide Record query

Ryax1 — Fri, 10 Mar 2023 15:38:58 GMT

Hi @Ankur Bawiskar and @Sai Shravan ,

Thanks for both of your help, I have found the cause of this issue which was the Location field I was referencing, it needed to be "agent_extended_info.cmdb_ci.location" instead of just 'location'.

Here is the working script:

Rich