question about filter with a value not in the liste

Hello,
 
Thank you for reaching out to us.
 
We want to confirm that Flexmonster will remove filters with non-existent members. It is a limitation of the internal architecture.
Still, there is a workaround we recommend for this case. Instead of filtering by members, try filtering using a query. Please see the documentation dedicated to Filter Object for detailed information. In your case, the String Query Object with "equal" or "contain" condition. In this case, an empty table will be displayed in case none of the members equals or contains the specified string.
 
Our team hopes it works for you.
Feel free to reach out in case further questions arise.
 
Regards,
Illia

Hello,
 
Thank you for your feedback.
 
We want to explain that the current implementation would not allow member filtering by absent members. This feature is unlikely to be added in the nearest future because it leads to major internal conflicts.
 
We suggest checking out another workaround. It implies validating filters before applying them to the report.
The idea lies in the following:
It is possible to get the list of all members in a hierarchy with the getMembers() API call.
With this in mind, it is possible to check if at least one of the passed values exists in the searched field. If at least one value exists, proceed with a members filter. In case no values are found in the members' list, proceed with an "equal" query filter and pass any value from the search query to it (for example, the first value).
We have prepared a simple JSFiddle example demonstrating the described approach: https://jsfiddle.net/flexmonster/oakp6hvs/.
 
In your case, the scenario would look similar to the following:

1. Get the desired report as a JSON object.
2. Retrieve filtering by members and save it for later use.
3. Apply report to the component.
4. Check the saved filters by members as shown in the JSFiddle.
5. Apply filtering using the setFilter API call.

 
We hope it helps.
Please contact us if other questions arise.
 
Kind regards,
Illia

Hello!

Hope this letter finds you well.

The Flexmonster team is happy to let you know that we’ve recently added a new functionality to our pivot grid, which we believe you might find valuable.

For the JSON and CSV data sources, we have added a new filter.allowEmptyMembersFilter option starting from the 2.9.86 version of Flexmonster. This property allows to show an empty table when the selection filter includes only members that do not exist in the dataset instead of removing the invalid filter.
So, if this approach matches your data source type(JSON or CSV), you are welcome to use it instead of the workaround we provided earlier. For other data source types, we recommend sticking to the approach of combining member and query filters.

Here is the JSFiddle to illustrate the idea: https://jsfiddle.net/flexmonster/vkthmug4/.
You can find more details about the new filtering functionality in our docs: https://www.flexmonster.com/doc/advanced-tips-filtering/#show-empty-grid-when-filtering-by-non-existent-members.

Feel free to explore the new property, and if you have any questions or feedback, we’d be happy to assist.

Kind regards,
Solomiia