asked on May 21, 2019
We have a problem on filtering a json report. There are rows containing the column of a supplier. i filter on that supplier and it works. if i filter on another one it ignores the filter and it shows all suppliers.
it doesn't matter where the filter is placed in the grid.
⋅ May 21, 2019
working on 2.7.6
⋅ May 21, 2019
Hello, Ingo Kunzi,
Thank you for writing to us.
We are glad to hear that everything works.
Feel free to contact us in case of any questions.
Best Regards,
Vera
⋅ May 22, 2019
sadly it is not working, sorry for confusion 🙁
⋅ May 22, 2019
Hello, Ingo Kunzi,
Thank you for your reply.
We would like to point out that Flexmonster has the following filtering options for JSON, CSV datatypes :
1) Filter by labels
2) Filter by values
3) Filter by simply selecting or deselecting fields (standard filter)
Please note that only one type can be applied at the same time to a specific field.
We have not managed to reproduce the issue you describe.
Could you please modify this JSFiddle so the issue is reproducible, or provide steps on how to reproduce the problem?
Another option is to provide us with a sample report or a code sample where the issue is shown, so we may help you solve this problem.
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ June 17, 2019
i could send you a little screen video per mail that shows the problem, if that could help.
⋅ June 18, 2019
Hello, Ingo Kunzi,
Thank you for getting back to us.
Yes, a screen recording will help our team understand the situation better.
We are looking forward to the email.
Best Regards,
Vera
⋅ August 9, 2019
Vera,
I have the same problem. I've modified your JSFiddle to reproduce the problem. To reproduce, create a simple filter:
{
"uniqueName": "Pmt Type",
"filter": {
"members": [
"pmt type.[payment reversal]"
]
}
}
If the CSV data does not include any rows with a "pmt type" of "payment reversal", the grid will display all with any "pmt type". I believe it should not display any rows, as none of the "pmt type" values match the filter.
⋅ August 12, 2019
Hello, John,
Thank you for writing to us.
The members property of the filter object lists the hierarchy’s members to be reflected/shown.
The members list should not be empty for such a filter to be applied.
If the members specified in members do not exist in the specified hierarchy, the filter will not be applied.
This is the way filtering by members works in Flexmonster at the moment.
We kindly advise using the equal query for such cases, for example:
{
"uniqueName": "Pmt Type",
"filter": {
"query": {
"equal": "payment reversal"
}
}
}
Please let us know if this works fine for you.
Best Regards,
Vera