Can we make fixed query reversible for user that means it will only used for starting point but users can go back as well.

Prabhat4
Tera Contributor

The client want to keep the Fixed query written in argument field of module but on the other side they want it editable that is they can click on "ALL" whenever they want to look into record which are closed as well,

Please review the code in Argument field: "&sysparm_fixed_query=active=true^u_hyperion_codeINjavascript:new IMACUtils().userHyperion()^u_order_guideISNOTEMPTY"

but this entire filter appears in Black that is non-clickable or editable on order guide part appears as blue.

comm.PNG

Please review the image, the underlined part is required to be blue so that user can come back to "All" whenever they want to.

This filter is available to role specific user's which is defined in module.

User is saying that this feature was working before but recently they are facing this issue.

We are working on Geneva, UI16 .

Please help..

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

If you use sysparm_fixed_query, the query shows up in black and is not editable by the user. That's why it is called "fixed". They can add on more filters if they like and always come back to the original by clicking the first > sign after the fixed query, but never show all records from that list as long as the fixed query is in place.



When ever someone did this to me, I would just go to the navigation menu filter and type the table_name.list to get all the records (eg sc_request.list).



If you want the current fixed query editable, simply use sysparm_query in the URL or the condition builder in the module definition (easier to build/maintain.)



There's no method to make "All" blue, then the middle part black, then allow blue after that. That defeats the part about having fixed queries. It never worked that way as long as I have been using the product (since 2008).


View solution in original post

8 REPLIES 8

Wayne Richmond
Tera Guru

Hi Prabhat. Apologies if I'm not understanding the requirements fully but you should just need to remove &sysparm_fixed_query=active=true from the Arguments to stop that happening.



http://wiki.servicenow.com/index.php?title=Restricting_Filters_and_Breadcrumbs#gsc.tab=0


Hi Wayne,



My requirement is that i want to keep the fixed query but not like this, in figure i have underlined the part of query which is not clickable and is in black color.


the blue one can be canceled so what we want is whenever this page loads we should be able to go back to "ALL"   view that is all the tickets should be visible
whether Active= true or false



hope this is clear now.



Regards



Prabhat


So you want users to be able to select All but not Active=true or Hyperion Code in () ?


Chuck Tomasi
Tera Patron

If you use sysparm_fixed_query, the query shows up in black and is not editable by the user. That's why it is called "fixed". They can add on more filters if they like and always come back to the original by clicking the first > sign after the fixed query, but never show all records from that list as long as the fixed query is in place.



When ever someone did this to me, I would just go to the navigation menu filter and type the table_name.list to get all the records (eg sc_request.list).



If you want the current fixed query editable, simply use sysparm_query in the URL or the condition builder in the module definition (easier to build/maintain.)



There's no method to make "All" blue, then the middle part black, then allow blue after that. That defeats the part about having fixed queries. It never worked that way as long as I have been using the product (since 2008).