PivotGridControl filter breaks when there is an element that contains the string "abs"

[Carlos Fernando Consigli]

I don't know if I'm going insane so please check this bug.

I was working ok with some sets of data and getting random exceptions with very similar sets of data.

I tried to isolate the problem and -I'm almost sure I got something wrong- but apparently filters fail when there is an element labeled "flabs". Unless that's some reserved word in your library, I guess I'm wrong and that's not the pattern that makes it fail but I'm attaching a sample so you can investigate it.

If you initialize the sample data with any of the following arrays of data, it works ok:

string[] countries = new string[] { "Argentina", "China", "Brasil", "Chile", "f-lab" };

string[] countries = new string[] { "Argentina", "China", "Brasil", "Chile", "USA" };

string[] countries = new string[] { "Argentina", "China", "Brasil", "Chile", "flab" };

but if you use some of these:

string[] countries = new string[] { "flab", "flabn", "flabs", "flabt", "fcaphg" };

string[] countries = new string[] { "f-lab", "f-labn", "f-labs", "f-labt", "f-caphg" };

string[] countries = new string[] { "Argentina", "China", "Brasil", "Chile", "flabs" };

when you click the Filter icon on Country and deselect any of the elements, you get multiple error popups.

Oddly enough, if you change ShowGrandTotals="True" to ShowGrandTotals="False", you don't get the error popups, but the grid just goes blank, and after that, if you click "Reset data", there you get an error message similar to the one in this bug: https://www.syncfusion.com/forums/144137/pivotgridcontrol-with-1-pivotrow-1-pivotcolumn-1-pivotcalc-and-0-elements-thows-exception so this one might be related.

I made many tests and couldn't find the pattern behind "flabs", so that's all I got.

Attachment: Example_Error_flabs_a71b61b1.zip

[Carlos Fernando Consigli]

In addition, if you can identify the problem, and it is feasible, I could use a patch (I know it's a lot to ask) because I happen to have lots of "f-labs" in my domain and this is really breaking :/

Thanks a lot in advance

[Carlos Fernando Consigli]

Ok, I could narrow it down and now it makes a little more sense. The problem is when the word contains the string "abs" which I guess is messing somewhere with the Math.Abs function.

[Sabaridass Ramamoorthy]

Hi Carlos, 

Thanks for detailed information. 

We have logged a bug report for this issue “Exception was thrown when filtering the values contains “abs””. Here we have provided private feedback link, we request you to log in to view the link further. 

https://www.syncfusion.com/feedback/6223/pivot-grid-does-not-filter-properly-when-applying-the-filter-values-that-contain-the-word-abs  

  

The fix will be available in our upcoming Volume 2 release which is scheduled to be rolled out at the end of June, 2019. Would waiting for the official release is OK for you? Otherwise, we can provide a patch on May 22 , 2019.    

 

If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal. 

Regards, 

Sabaridass R 

 

[Carlos Fernando Consigli]

Hi Sabaridass, thanks for your answer. I know it's too much to ask, but this time I could use that patch you mention whenever you could make it available. Thanks for your support.

PD: I added a comment and a new attachment in the bug report because there is also a similar problem with the strings "max" and "min". The symptom is not exactly the same as with "abs" so that is why I added that case scenario.

[Sabaridass Ramamoorthy]

Hi Carlos, 

 

Thanks for the update and find our response below. 

 

know it's too much to ask, but this time I could use that patch you mention whenever you could make it available.	As per your request, we will provide the fix for the reported issue on 22nd May, 2019.
PD: I added a comment and a new attachment in the bug report because there is also a similar problem with the strings "max" and "min". The symptom is not exactly the same as with "abs" so that is why I added that case scenario.	Thanks for sharing the cases to be addressed additionally. We will inform our development to consider the added cases as well while working with the reported issue.

 

Regards, 

Sabaridass R 

[Carlos Fernando Consigli]

Thanks a lot, I don't get tired of saying that Syncfusion has the best support I've ever seen.

[Sabaridass Ramamoorthy]

Hi Carlos, 

 

Thanks for the update and we are very happy to hear your feedback. 

 

Regards, 

Sabaridass R 

[Thirupathi Bala Krishnan]

Hi Carlos,

Thanks for your patience.

We have fixed the reported issue – “Pivot grid does not filter properly when applying the filter values that contain the word abs,min,max” in your reported version 17.1.0.38. Please find the patch file from the following location:

V17.1.0.38 

Recommended approach – exe will perform automatic configuration           

Please find the patch setup here:                                 

http://syncfusion.com/Installs/support/patch/17.1.0.38/709190/F144451/SyncfusionPatch_17.1.0.38_709190_5222019095149851_F144451.exe 

        

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                            

Please find the patch assemblies alone from:            

http://syncfusion.com/Installs/support/patch/17.1.0.38/709190/F144451/SyncfusionPatch_17.1.0.38_709190_5222019095149851_F144451.zip 

         

Please find the Nugets from the below location:           

http://syncfusion.com/Installs/support/patch/17.1.0.38/709190/F144451/SyncfusionNuget_17.1.0.38_709190_5222019095149851_F144451.zip 

          

           

NOTE: 
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
https://www.syncfusion.com/support/directtrac/patches        

         

Disclaimer:                          

Please note that we have created this patch for the version 17.1.0.38 specifically to resolve the issues reported in this forum #144451. If you have received other patches for the same version for other products, please apply all patches in the order received. This fix will be included in our main release 2019 Vol2 which will be available in June,2019. 

Regards,
Thirupathi B. 

 

[Carlos Fernando Consigli]

Great, thanks a lot!

[Jagadeesan Pichaimuthu]

Hi Carlos, 

 

Thanks for your update. 

 

We are glad to know that the provided solution worked at your end. Please let us know if you have any further queries on this. We are happy to help you. 

 

Regards, 

Jagadeesan