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 · ‎12-15-2016

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.

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..

Chuck Tomasi · ‎12-15-2016

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

Chuck Tomasi · ‎12-19-2016

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Thank you

Prabhat4 · ‎01-04-2017

hi Chuck,
Thanks for sharing this link... this is really smart, the way you predicted.
i was wondering that it'll be very silly question to ask how to mark it correct..
well thanks again....Now lot of people can take help from this

Wayne Richmond · ‎12-15-2016

A potential workaround might be create a Form link UI Action that links to All records.

Apoorva2 · ‎04-20-2021

Hi Prabhat, Can you share your knowledge on how you implemented this could help me so much