How do I add a Time Zone Reference to a Catalog Item?

bostonsnow
Kilo Guru

Hello,

Could somebody tell me how to I can reference the time_zone field on sys_user from a Catalog Item? time_zone is not showing up as an available Reference selection.

Thanks!

MIke

1 ACCEPTED SOLUTION

Troya1
Mega Guru

I used a Lookup Selectbox.  Referenced user table

find_real_file.png

View solution in original post

6 REPLIES 6

sachin_namjoshi
Kilo Patron
Kilo Patron

Hi,



You can use advanced reference qualifier in your catalog item variable.


Create script include which returns time_zone and refer this script include in advanced qualifier.



find_real_file.png



Regards,


Sachin


bostonsnow
Kilo Guru

Hello Sachin,



Thank you for this. Could you possibly help with the script that goes into the Reference qualifier?



Thanks!



Mike


Troya1
Mega Guru

I used a Lookup Selectbox.  Referenced user table

find_real_file.png

It should work, i tried the same configuration on my instance. Check the time zone values for users once.find_real_file.png