Blazor server side filtering error: 'Object must implement IConvertible'

[Thomas Vasilakis]

Hi,

I recently updated Blazor to 18.1.0.59 and I'm using the following datagrid to filter records on the server:

On the server I have the following, which returns an error while attemping to filter rows:

Please note that request.Where[0].Operator is always null. Is that normal?

Here's the stack trace if it helps:

   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at Syncfusion.Blazor.Data.QueryableOperation.PredicateBuilder[T](IQueryable`1 dataSource, List`1 whereFilter, String condition, ParameterExpression paramExpression, Type type)
   at Syncfusion.Blazor.Data.QueryableOperation.PredicateBuilder[T](IQueryable`1 dataSource, List`1 whereFilter, String condition, ParameterExpression paramExpression, Type type)
   at Syncfusion.Blazor.Data.QueryableOperation.PerformFiltering[T](IQueryable`1 dataSource, List`1 whereFilter, String condition)
   at Syncfusion.Blazor.DataOperations.PerformFiltering[T](IEnumerable`1 dataSource, List`1 whereFilter, String condition)
   at AssetManager.Blazor.Server.Controllers.AssetsController.GetDmAssets(DataManagerRequest request) in C:\Users\sydne\source\repos\AssetManager.Blazor\AssetManager.Blazor\Server\Controllers\AssetsController.cs:line 50

Please help :)

[Vignesh Natarajan]

Hi Thomas,  

 

Greetings from Syncfusion support.  

 

Query: “On the server I have the following, which returns an error while attemping to filter rows:” 

 

From your query we understand that you are facing issue while applying filtering to Grid column with UrlAdaptor. We have prepared a sample using your code example and 18.1.0.59 version. We are not able to reproduce the reported issue at our end. Kindly download the sample from below 

 

Sample: https://www.syncfusion.com/downloads/support/forum/155609/ze/URL1435811566  

 

Note: dm.Where[0].Opewrator can be null, reported issue is not related to it. 

 

After referring the sample if you are still facing issue, kindly get back to us with following details.  

 

1. Share the details about your DataSource along with its type (List / IEnumerbale/IQueryable)? (type of results variable)
2. Are you facing this issue only after upgrading to our latest version 18.1.0.59?
3. You have normal column and a complex column.Are you facing issue while filtering both the columns or any one column alone.
4. Share the replication procedure of issue along with video demonstration.   
5. If possible try to reproduce the reported issue in provided sample.

 

Above requested details will be helpful for us to validate the reported issue at our end and provide solution as soon as possible.   

 

Regards, 

Vignesh Natarajan