Need to display country in a reference variable in service catalog portal view

[Ajai S Nair]

Hi All,

Need help regarding service portal.

I want to show 4 values from a table in a reference field (Hr contacts from Hr contact table) in portal view of service catalog. In IT view , when you click the reference icon a window will appear which will display fields in different columns. It is working fine here also but in portal view its showing only 3 fields from that. Country is not visible. I have given attributes to display all the 4 fields but dot operation is not working here . so country value is not populating

Currently instance is in Helsinki.

Any help is appreciated.

Regards.

Ajai

[User166992]

Hello Ajai,

You can use variable attribute to list more columns. Please refer below example-

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name;email;phone,ref_ac_columns_search=true

Let me know if you any questions.

Best Regards,

Jaikumar

[Ajai S Nair]

Hi Jaikumar,

I am using the same only but my issue is that i need to display the users country.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_additional_comments;u_location;u_location.country;

any help appreciated.

[greg_mcgough]

Hi Ajai,

I have found the directive that handles this is hard-coded, and dot-walking attributes is not supported in Service Portal right now. You may want to consider writing a script that will populate the OOB field 'country' on the 'sys_user' table with the value found from < user >.location.country. Then you can add the attribute "country" to the variable in question.

Please hit Like, Helpful, Endorse and/or Correct to help the community.

Best,

-Greg

[Ajai S Nair]

HI Greg,

So you mean, I need to create a new field and populate country in it from user table and then add in attribute? can we add a variable directly in the attribute like variables.variablename?