Displaying a dot walk field on catalog item variable reference field

[jonsr20]

Hey Everyone,

I am trying to directly display a dot walk field in a reference variable on a catalog item. From what I have seen I may need to use an On change client script but am not having much luck. The table I am referencing is pm_project and the field I need to display is pm_project.number. I want to be able to search by the project number and the direct reference will only let me search by name. Can anyone assist me with an on change script that may achieve this goal? I attached a picture of the project reference field where I would like that pm_project.number to appear and a picture of the variable.

Thanks,

Jon 

[Anurag Tripathi · Accepted solution]

Hi,

If i understand it right, you need to be able to search the list by Project name and number both, if that is right then you can add the below attribute to the variable

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=<Column_name1,column_name2,column_name3>,ref_ac_columns_search=true

After that it will show both columns in the search and you can search by any. Like below

[Anurag Tripathi · Accepted solution]

Hi,

If i understand it right, you need to be able to search the list by Project name and number both, if that is right then you can add the below attribute to the variable

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=<Column_name1,column_name2,column_name3>,ref_ac_columns_search=true

After that it will show both columns in the search and you can search by any. Like below

[jonsr20]

That is indeed what I would like to achieve, I input your suggestions but with no results it still displays the same. Pictures attached. Do I need to input the reference fields where you have column_name1,Column_name2? I tried that also with no results.

Thanks