Okay, I've been racking my brain on this issue for days, and I know it probably has a super-simple solution; I just can not find it. Perhaps someone here could help?
On the Change table (extended from Task) I have created a watch list field called "Reviewer(s)" with the Reference set to the User table. I also have another field, the standard Requested By which is a Reference itself to the User table.
What I am trying to do is use a Reference Qualifier Condition on the Reviewer(s) field that is logically says "the 'Reviewer' user is not allowed to be the 'Requested By' user". The Reference Qualifier Condition would effectively allow the watch list lookup search for everyone except the person in the Requested By field.
I have tried the following without positive result:
1) Reference qual condition
Sys ID is not javascript:current.requested_by.sys_id
2) Reference qual condition
Name is not javascript:current.requested_by.name
3) Reference qual condition
Sys ID is not javascript:current.getValue('requested_by')
3) Created a Script Include which returns current.getValue('requested_by') and used it in a Reference qual condition
Sys ID is not javascript:u_allButRequester()
I'm stumped; what am I missing here? Thank you kindly in advance for any help provided!
