Hi, I have a dashboard with an input element which is a multi-select with a populating search which gets values for the token. The value prefix is
and value suffix is
I also have a default value of * (with label as All)
So when the user selects All, the token value becomes
That's a problem. What I really want to mean by All is, get all records with or without "fieldname". The above value filters out the records in which fieldname is null and I don't want that.
How can I tweak this so that:
1. When user chooses All, the token gets empty string as a value (how is it possible since I have a prefix and suffix)
2. OR, when user chooses All, the token gets value as fieldname="*" OR fieldname="" . That will take care of both null and not null situations.