Populate User ID in List Collector Field

[Piyush27]

Hi,

I am trying to see users when entering the user id in a list collector variable.

The list collector variable is pointing to the sys_user table. Below is the screenshot of the variable.

----------------------------------------------------------------

-------------------------------------------------------------------------

-----------------------------------------------------------------------------

This is how the catalog item looks on the portal

------------------------------------------------------------------------------

What I want here is - When I enter the USER ID in the field it should show only the USER IDs.

But in my case, I have to type the complete name.

Is there any way I can achieve this?

Regards,

Piyush

[Ankur Bawiskar]

@Piyush27 

I believe your original question and the answer marked as correct are different.

You wanted to see User ID when you type the information and also when the value is set in variable.

For that did you check my above response?

[Ankur Bawiskar]

@Piyush27 

Try to add the variable attribute which Sushant has shared.

[Brian Lancaster]

You can try modifying the dictionary on the sys_user table in the following way.

1. Go to the users table

2. right lick and choose 

3. Soft by Column name. The first one should have a blank column name. open this record

4. Update the reference auto completer columns to include user_name. It should look something like this.

This should allow you to search based on user id but it will still display full name. Unless you change the display value with a dictionary override name is the default display value. Changing this would not be recommended as it would change it in the entire system anywhere you reference the sys_user table.

[Sandeep Rajput · Accepted solution]

@Piyush27 I am assuming you would like to have the search performed on the user_name field like the following.

Here when I am typing admin, it has suggested me the user with user_name admin.

In order to achieve this you need to paste the following string inside your Variable attributes of your user list collector variable.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name,ref_ac_order_by=user_name,ref_ac_columns_search=true,ref_ac_display_value=false

Hope this helps.