Advance Reference Qualifier to return User ID and Name from User Table

[chatsaurav19]

Hi All,

Can someone please help me write an advance reference qualifier for a 'list collector' field which is referring to user table and it needs to return user ID and Name? Example:::

Regards,

Saurabh

[Shane J]

I don't understand your question.

How are you using a List Collector to try to populate these fields?  Do they all exist on the same Catalog Item?

We need more info before we can provide a solution.

[chatsaurav19]

Hi @Shane ,

I am actually using the list collector to populate a catalog item variable so that the end user can select multiple users at one go. But the challenge is that a user table can have users with same name and the best way to avoid that would be if along with the name, User ID is also gets returned so that the user can select the user which is required.

Regards,

Saurabh

[Shane J · Accepted solution]

I think you can fix your issue by just setting the Variable Attribute on your List Collector to something like this, so that they can see and search by more fields per record:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=title;manager;department,ref_ac_columns_search=true

Change the fields after ref_ac_columns to whatever fields you want on the User table.

[chatsaurav19]

Thank you @Shane J !