asked on August 18, 2022
Case:
I want to show blank data if the option is not available in the report filter so I need to check if the option is available or not in the report filter.
eg:
Assume if the report having options as optionA, optionB, optionC.
I need to get blank data if I pass filter member as optionD. Right now it's showing all the data if we pass a option which is not available in the report filter
⋅ August 19, 2022
Hello,
Thank you for reaching out to us.
Our team is currently working on your question. We will get back to you soon.
Kind regards,
Nadia
⋅ August 22, 2022
Hello,
Thank you for giving us some time.
Kindly note that this is the expected behavior of filtering. When any of the members specified in the filter does not exist, the filter is considered invalid. In such a case, Flexmonster does not apply it and shows the whole dataset.
Please check the following workaround, how you can achieve the desired behavior when none of the filter items exists: https://jsfiddle.net/flexmonster/pjvubqg7/
The query property covers the case when none of the included members exist, or the members’ list is empty.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
