- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2022 09:39 AM
We have two reference variables and two variables are referring to different tables which has relation between those tables. for the second variable defined condition in advance reference qualifier to depend on first variable. And now our requirement is to add some more filters to this existing condition in reference qualifier to avoid showing retired records from the second variable.
this is the existing Advance reference qualifier which makes based one selecting first variable- javascript:'variable1='+current.variables.variable1;
have to merge this state!=retired^statusNOT INobsolete,retired
This is the query copied from list view for reference:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2022 03:03 AM
Hi
Try this in advanced reference qualifier.
javascript:"variable1="+current.variables.variable1+"^state!=retired^statusNOT INobsolete,retired";
Thanks,
Sagar Pagar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2022 09:50 AM
hello ,
can you try this
javascript:state!=retired^statusNOT INobsolete,retired
please mark this helpful if this solves the issue
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2022 09:54 AM
Hello Mohith,
thanks for response. we have to merge both as one to make work
javascript:'variable1='+current.variables.variable1; (Existing condition)
state!=retired^statusNOT INobsolete,retired (have to merge)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2022 09:57 AM
yeah so for this
javascript:'variable1='+current.variables.variable1^state!=retired^statusNOT INobsolete,retired
you can write like this in AND fashion
if it is OR fashion you can write like below code
javascript:'variable1='+current.variables.variable1^ORstate!=retired^statusNOT INobsolete,retired
Please accept the solution if it solves the issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-05-2022 03:24 AM
i tried to update the same in advance reference qualifier but not working, still the reference variable showing the retired records in it