In "Invoice" page, when trying to select "this month" in the header "Date of paid in full", an error occurred in the application and have to reload.
Here's the log:
2022-08-16 18:42:21.5234 ERROR Unhandled exception in circuit 'CDvM87USsBXIaNy5wkuSQLVG1gsBwDYlRzUDDGcD6-k'. System.NotSupportedException: The expression is not supported in the Where clause: obj.DatePaid
at DevExpress.Xpo.Parser.Where(MethodCallExpression call)
at DevExpress.Xpo.Parser.Call(MethodCallExpression call)
at DevExpress.Xpo.Parser.ParseExpression(Expression expression)
at DevExpress.Xpo.Parser.ParseExpression(XPClassInfo classInfo, CustomCriteriaCollection customCriteriaCollection, Expression expression, CriteriaOperator[] maps)
at DevExpress.Xpo.XPQueryBase.Where(MethodCallExpression call)
at DevExpress.Xpo.XPQuery`1.System.Linq.IQueryProvider.CreateQuery[S](Expression expression)
at DevExtreme.AspNet.Data.ExpressionExecutor.BreakQueryableChain()
at DevExtreme.AspNet.Data.DataSourceLoaderImpl`1.ExecTotalCountAsync()
at DevExtreme.AspNet.Data.DataSourceLoaderImpl`1.LoadAsync()
at DevExpress.Blazor.GridDevExtremeDataSource`1.LoadAsync(DataSourceLoadOptionsBase loadOptions, CancellationToken cancellationToken)
at DevExpress.Blazor.GridDevExtremeDataSource`1.GetItemCountAsync(GridCustomDataSourceCountOptions options, CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.Loader.LoadCountAsync(CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.Loader.LoadAsync(Task prevLoadTask, CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.HandleLoadException(Exception exception)
at DevExpress.Blazor.Internal.GridCustomDataProvider.HandleLoadCompletion(Loader newLoader, Boolean completedSynchronously)
at DevExpress.Blazor.Internal.GridCustomDataProvider.EndUpdate()
at DevExpress.Blazor.DxGrid.ApplyParameterChanges()
at DevExpress.Blazor.Internal.ParameterTracker.EndUpdate()
at DevExpress.Blazor.DxGrid.Reload()
at TBM.Components.GridCells.GridCellDateTimeTemplateFilter.colDateFilterChanged(DataDateFilterType val) in C:\builds\759\s\TBM\Components\GridCells\GridCellDateTimeTemplateFilter.razor:line 256
at System.Threading.Tasks.Task.<>c.<ThrowAsync>b__128_0(Object state)
at Microsoft.AspNetCore.Components.Rendering.RendererSynchronizationContext.ExecuteSynchronously(TaskCompletionSource`1 completion, SendOrPostCallback d, Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Components.Rendering.RendererSynchronizationContext.ExecuteBackground(WorkItem item) at DevExpress.Xpo.Parser.Where(MethodCallExpression call)
at DevExpress.Xpo.Parser.Call(MethodCallExpression call)
at DevExpress.Xpo.Parser.ParseExpression(Expression expression)
at DevExpress.Xpo.Parser.ParseExpression(XPClassInfo classInfo, CustomCriteriaCollection customCriteriaCollection, Expression expression, CriteriaOperator[] maps)
at DevExpress.Xpo.XPQueryBase.Where(MethodCallExpression call)
at DevExpress.Xpo.XPQuery`1.System.Linq.IQueryProvider.CreateQuery[S](Expression expression)
at DevExtreme.AspNet.Data.ExpressionExecutor.BreakQueryableChain()
at DevExtreme.AspNet.Data.DataSourceLoaderImpl`1.ExecTotalCountAsync()
at DevExtreme.AspNet.Data.DataSourceLoaderImpl`1.LoadAsync()
at DevExpress.Blazor.GridDevExtremeDataSource`1.LoadAsync(DataSourceLoadOptionsBase loadOptions, CancellationToken cancellationToken)
at DevExpress.Blazor.GridDevExtremeDataSource`1.GetItemCountAsync(GridCustomDataSourceCountOptions options, CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.Loader.LoadCountAsync(CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.Loader.LoadAsync(Task prevLoadTask, CancellationToken cancellationToken)
at DevExpress.Blazor.Internal.GridCustomDataProvider.HandleLoadException(Exception exception)
at DevExpress.Blazor.Internal.GridCustomDataProvider.HandleLoadCompletion(Loader newLoader, Boolean completedSynchronously)
at DevExpress.Blazor.Internal.GridCustomDataProvider.EndUpdate()
at DevExpress.Blazor.DxGrid.ApplyParameterChanges()
at DevExpress.Blazor.Internal.ParameterTracker.EndUpdate()
at DevExpress.Blazor.DxGrid.Reload()
at TBM.Components.GridCells.GridCellDateTimeTemplateFilter.colDateFilterChanged(DataDateFilterType val) in C:\builds\759\s\TBM\Components\GridCells\GridCellDateTimeTemplateFilter.razor:line 256
at System.Threading.Tasks.Task.<>c.<ThrowAsync>b__128_0(Object state)
at Microsoft.AspNetCore.Components.Rendering.RendererSynchronizationContext.ExecuteSynchronously(TaskCompletionSource`1 completion, SendOrPostCallback d, Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Components.Rendering.RendererSynchronizationContext.ExecuteBackground(WorkItem item)
