Search on sfgrid with more than 6 numerics cause 0 results

[A]

Hello, 

I have a search bar on my SFGrid the problem is when i type some characters in, it result 0 results when i have more than 6 numerics example :

i have an Odata error : 

  Parameter value '2524000.0000' is out of range.

Im filtering on some columns

    <GridSearchSettings Fields="@(new string[] { nameof(PackagingNoTrf.IdConditionnement), nameof(PackagingNoTrf.DtDebut),

                        nameof(PackagingNoTrf.DtFin), nameof(PackagingNoTrf.IdLotDest),

                        nameof(PackagingNoTrf.CodeMinos), nameof(PackagingNoTrf.Formule), nameof(PackagingNoTrf.Destination),

                        nameof(PackagingNoTrf.IdEtat), nameof(PackagingNoTrf.IdNitrogen),

                        nameof(PackagingNoTrf.IdConveyor) })" Operator=Syncfusion.Blazor.Operator.Contains IgnoreCase="true" />

to correct this error , i should create new column in my VUE to add IDConditionnement Column with string datatype and Same for IDEtat look like  the request odata do a like "%MYSEARCH%" on the long type properties 

Is this a Syncfusion error? Do you have any ideas on how to fix this problem?

[Sanjay Kumar Suresh]

Hi A,

We have made a sample as per your requirement and checked the mentioned scenario from our end, however we could not able to replicate the mentioned issue from our end. We have attached the concern sample in the attachment please check.

Before proceeding with the reported requirement, we require some additional clarification from your end. Please share the below details to proceed further at our end.

1. Please provide a simple issue replicating sample or try to modify the above-mentioned sample.
2. Share us the video demonstration of the reported issue.
3. Please provide the NuGet version in which the issue is getting reproduced from your end.
    

The above requested detail will be very helpful for us to validate the reported issue at our end.

Regards,

Sanjay Kumar Suresh

Attachment: DemoFail_PH_804468fd.zip

[A]

The filter and the searchBar doesnt work when you mix decimal with string and int type and write more than one char

Attachment: DemoFail_PH_804468fd_10dc1028.zip

[Sanjay Kumar Suresh]

Hi A,

Query: Contains operator not working while searching non string values in the DataGrid on Odatav4Adaptor.

Please find the following limitations applied for implementing the searching feature in your application. (ie. ODataV4Adaptor)

1. The contains operator will be applied only for string typed column
2. The equal operator will only be applied for all other data types.

Query: Regarding the Filtering is not working.

We have applied the concerned value and performed filtering as per your scenario. From our end, the behavior works as expected, as demonstrated in the screenshot below.

To assist you more effectively, we kindly request you to provide additional details about the issue you're encountering. A step-by-step replication procedure would be especially helpful in identifying any discrepancies and ensuring a targeted resolution.

Looking forward to your response.

Snip:

Regards,

Sanjay Kumar Suresh