- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 10:34 AM
I've added this reference qual condition to filter out the currently logged on name from the user selection field on a request form, however that doesnt work, any idea?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 10:49 AM
OK, I thought it would work, but after some testing - no such luck. I also tried a dynamic filter. Nothing there because it only does equality (like "Me" is simply gs.getUserID())
So what I came up with was this:
- Simple script include named myRefQual
- function myRefQual() {
return 'roles!=admin^regionISNOTEMPTY^....^sys_id!=' + gs.getUserID();}
- function myRefQual() {
- Change the reference qualifier to advanced and call the script include
- javascript:myRefQual()
If you change your reference qualifier from simple to advanced, it will translate everything you have right now to an encoded query string that you can use in your script include.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 10:40 AM
User ID is a string field. You want to use sys_id to compare against javascript:gs.getUserID();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 10:49 AM
OK, I thought it would work, but after some testing - no such luck. I also tried a dynamic filter. Nothing there because it only does equality (like "Me" is simply gs.getUserID())
So what I came up with was this:
- Simple script include named myRefQual
- function myRefQual() {
return 'roles!=admin^regionISNOTEMPTY^....^sys_id!=' + gs.getUserID();}
- function myRefQual() {
- Change the reference qualifier to advanced and call the script include
- javascript:myRefQual()
If you change your reference qualifier from simple to advanced, it will translate everything you have right now to an encoded query string that you can use in your script include.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 02:09 PM
That worked thank you ! my final script include ended up being
function myRefQual() {
return 'roles!=admin^u_region!=^user_nameNOT LIKEadmin^active=true^sys_id!=' + gs.getUserID();}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 02:26 PM
Perfect. That's what I was aiming for. Couldn't recall all the details. Glad you go ti working.