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

[greg_mcgough]

Hi Ajai,

My suggestion is to leverage the OOB field 'country' that exists on the 'sys_user' table to display the country name. The quickest way to do this would be to write a script that goes to each user record and sets the value of the 'country' field = to that of the 'user.location.country'. Once this is done and the users' 'country' fields are populated, then add 'country' to your list of 'ref_ac_columns' in the attribute field.

I am not sure what you mean by adding a variable directly in the attribute field, can you please elaborate?

Best,

-Greg

[Ajai S Nair]

Hi Greg,

can we add a variable directly in the attribute like variables.variablename?   -- Here I am talking about the normal catalog item variable/

[sathiyavathik]

Do any one have solution for this Issue. Please assist.