Hi Team,
We are facing a typical issue that the filters used on the "Changes apply to" in one environment is working (in UAT) and the same configuration is not working in Prod. ie.., Requestor whose ISADMIN is Y can see all users in his department when accessed the form in UAT, however, the same user when logged into Prod can only see himself.
(
users."Is Terminated" = '0'
and
((users.Department = case when '${avform.requestor.ISADMIN}' LIKE 'Y%' then '${avform.requestor.Department}' else null end)
OR
users."User Id" = '${avform.requestor.User_Id}')
)
Have checked multiple times there is no difference in the configuration of the form. However, not sure if this matters UAT has local test authentication and Prod is by SSO authentication.
Forms are of type global in both the environments.
What could be the reason for this issue?
If the configuration is identical, then I would look into the other parameters which might be different: