Hi Everyone,
So I am looking for a way to conditionally hide a column in the Work order tracking application depending on the default site of the user.
What I have managed to do figure out already is that I can create a Signature option in Application designer for WOTrack, associate it with the column I am trying to hide, and adjust site specific security groups to show / hide that column.
However I am wondering if it is possible to use a Conditional Expression so that I can just adjust the security group given to all users instead of all the sites where I want it to be shown.
I wrote the following expression "exists (select 1 from maxuser where userid = :&USERNAME& and defsite in ('GI', 'COM', 'CAM'))" for the conditional statement and put it in for the EVERYONE security group, but the column would always show up now instead.
Thanks for reading :)
------------------------------
Jonathan Ma
------------------------------
#AssetandFacilitiesManagement#Maximo