Are there any filter limitations on what column type could/couldn’t be filtered ? Actually I am facing the following issue :
2022-01-28 10:12:07,523 [4] ERROR Origam.ServerCore.Controller.AbstractController - Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
System.Data.SqlClient.SqlException (0x80131904): Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReader(DataStructureQuery query, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1617
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReaderInternal(DataStructureQuery query)+MoveNext() in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1698
at System.Linq.Enumerable.SelectEnumerableIterator`2.MoveNext()
at Origam.ServerCore.Controller.UIServiceController.StreamlineFilterListValues(IEnumerable`1 fullReaderResult) in D:\a\1\s\backend\Origam.ServerCore\Controller\UIServiceController.cs:line 680
at Origam.ServerCore.Controller.UIServiceController.<>c__DisplayClass60_0.<GetFilterListValues>b__0() in D:\a\1\s\backend\Origam.ServerCore\Controller\UIServiceController.cs:line 642
at Origam.ServerCore.Controller.AbstractController.RunWithErrorHandler(Func`1 func) in D:\a\1\s\backend\Origam.ServerCore\Controller\AbstractController.cs:line 117
ClientConnectionId:3e7c2ca6-1b83-4b8b-957a-629b4aa0de1c
Error Number:144,State:1,Class:15