Bug report: Error occurred when trying to filter the paid invoices with date

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)

emoji
Parents Reply Children
No Data