Setting Display Value from within advanced reference qualifier

[Staxed]

Is it possible to set the display value from within an advanced reference qualifier for a reference field on a catalog item variable?

I am using a reference field variable to lookup two groups using sys_user_grmember, the issue is there is no display value set on this table OOB so it's returning the created date instead of the user.  I'd rather set a display value locally to this variable via the reference qualifier vs setting a display value for the table (not sure if that'll mess anything else up). 

So, if it's possible, how would I go about setting the display value to the user field of the sys_user_grmember table.  Current qualifier is just filtering on the two groups:

group=338171bfdb64238017c63ede7c961985^ORgroup=b31e7034db19ec10bae1f1651d96192e^EQ

[Manmohan K]

Hi @Staxed 

No, its not possible to set the display value from within an advanced reference qualifier for a reference field

The only way is by setting one of the columns as display true for the table.

Please note it will change the display on entire platform for that table's reference field

[Staxed]

Do you know if there is a way to change it via a catalog client script or something similar?

[Manmohan K]

@Staxed 

No, that's not possible via any script

An alternative approach would be to change your variable type to Look Up select Box and then you can set the column you desire to view on the variable like below

In the below example - Email would be showed in the field selection instead of display value of sys_user table

[Staxed]

Sadly Lookup Select Box won't work as it doesn't pass the variable as a reference to flow designer.  I have to use the selection from this field as the approver in a flow, so it must be a reference variable.

I think I'm going to just try to reference the sys_user table and see if I can modify this: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0831564 to pull from two groups instead of 1.