Get Free Trial
Get Free Trial

Problem on Filter

Ingo Kunzi 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.

8 answers

Public
Ingo Kunzi May 21, 2019

working on 2.7.6

Public
Vera Didenko Flexmonster 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

Public
Ingo Kunzi May 22, 2019

sadly it is not working, sorry for confusion 🙁

Public
Vera Didenko Flexmonster 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

Public
Ingo Kunzi June 17, 2019

i could send you a little screen video per mail that shows the problem, if that could help.

Public
Vera Didenko Flexmonster 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

Public
John W 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.
 

Public
Vera Didenko Flexmonster 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

Please login or Register to Submit Answer