- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2025 08:25 AM - edited 10-10-2025 08:46 AM
I have a (IMO) fairly simple If action comparison that doesn't seem to be working. It is basically checking to see if a catalog variable is not empty, and if it is unequal to another catalog variable. The catalog variables are both reference fields to sys_user table.
The logic is essentially checking to see if the person that submitted a request is the budget manager of their department. If the submitter is not the budget manager, then it branches one way, where the approval step is assigned to the budget manager, however if the submitter is the budget manager it branches another way to a central payroll team for review/approval. Below is the If action condition set..
But it does not seem to work. Below is a screenshot of a submission from a budget manager that somehow evaluated to true.
Hard to see but if you expand you can see the compared values (text copied to below):
fbf429473b5a6e1027bff2c964e45ae4ISNOTEMPTY^fbf429473b5a6e1027bff2c964e45ae4!=fbf429473b5a6e1027bff2c964e45ae4
So I guess my question is, can one not compare 2 reference fields of the same table in an If action, or is this a bug?
Edit: Forgot to mention, we are on Yokohama. This has occurred in our prod instance (Patch4b) and non-prod (patch7 hotfix2)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2025 10:35 AM
Thanks to everyone that replied. I adjusted the flow to dot-walk to the sys_id of user record in sys_user instead of comparing the reference field itself and it works as expected this way.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2025 10:35 AM
Thanks to everyone that replied. I adjusted the flow to dot-walk to the sys_id of user record in sys_user instead of comparing the reference field itself and it works as expected this way.
