i have to filter my data , i use report.since ,but i find that:when the data dont include members,the filter dont work.what can i do
Hello!
Thank you for your question.
We want to explain that this is the expected behavior of filtering by members. 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.
There is a simple workaround, how you can achieve the desired behavior when none of the filter items exists: https://jsfiddle.net/flexmonster/nq34h0pm/
In this example, we apply the filter using include property instead of members. The query property covers the case when none of the included members exist or the members' list is empty.
Please let us know if this way works for you.
Regards,
Solomiia
Hello!
We are wondering if you had some time to try the suggested filtering approach. Was it helpful for solving the case?
Looking forward to hearing your feedback.
Regards,
Solomiia
I was so sorry to reply you so late.that don't work.I don't know if it's because of the Chinese
Hello again!
Thank you for your response.
Our team would like to inform you that the problem is unlikely caused by an encoding mismatch in Chinese characters. The provided screenshots show that everything is displayed correctly.
Thus, could you please provide us with the data sample where the issue is reproducible? This would help us to find a suitable solution for the case.
Looking forward to your response.
Regards,
Solomiia.
i am sorry, the data are form our database,i cant give concrete data.there some screenshot about data ,you can refer to.
Hello!
Thank you for the screenshots, they helped us to investigate the case.
Also, our team is wondering if we understand the attachments correctly and you are using our Flexmonster Data Server.
It seems like the previous workaround wouldn't work for your case, so we want to suggest you a new approach using our API calls.
The idea lies in the following:
It is possible to get the list of all existing members with the getMembers() API call.
With this in mind, you could check if at least one member exists.
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 non-existent value from the search query to it (for example, the first value). That query will return an empty grid.
Here is a simple JSFiddle example demonstrating this approach: https://jsfiddle.net/flexmonster/f128jw6L/
Please let us know if it works for you.
Regards,
Solomiia.
I am so sorry to reply you so late.That`s work.
i think it`s so Tedious. i suggest that we should support to filter with members
Hello!
We are happy that our approach works for you.
Thank you for your suggestion on changing the filter's behavior. Our team will keep this in mind when implementing filtering improvements.
Please, feel free to contact us if any further questions arise.
Regards,
Solomiia.