What version of Origam are you using… I’m on 2025.10.3.4153
I was trying to sort column in grid view - column is lookup field with multiple fields in ValueDisplayMember (mixed string and integer values)
I was expecting screen will be sorted according to selected column
Instead I’ve got error Argument data type int is invalid for argument 2 of Trim function.
Details in the log are:
2026-03-02 09:19:27,342 [77] ERROR Origam.Server.Controller.AbstractController - Argument data type int is invalid for argument 2 of Trim function.
System.Data.SqlClient.SqlException (0x80131904): Argument data type int is invalid for argument 2 of Trim function.
at System.Data.SqlClient.SqlConnection.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.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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\Users\jindr\Repos\mini-profiler\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 206
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReader(DataStructureQuery query, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1848
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReaderInternal(DataStructureQuery query)+MoveNext()
at System.Linq.Enumerable.SelectEnumerableIterator`2.ToList()
at Origam.Server.Controller.AbstractController.ExecuteDataReader(DataStructureQuery dataStructureQuery, Guid methodId) in D:\a\1\s\backend\Origam.Server\Controller\AbstractController.cs:line 536
at Origam.Server.Controller.UIServiceController.<>c__DisplayClass36_0.<GetRows>b__3(DataStructureQuery dataStructureQuery) in D:\a\1\s\backend\Origam.Server\Controller\UIServiceController.cs:line 403
at CSharpFunctionalExtensions.ResultExtensions.Bind[T,K,E](Result`2 result, Func`2 func)
at Origam.Server.Controller.UIServiceController.<>c__DisplayClass36_0.<GetRows>b__0() in D:\a\1\s\backend\Origam.Server\Controller\UIServiceController.cs:line 400
at Origam.Server.Controller.AbstractController.RunWithErrorHandlerAsync(Func`1 func) in D:\a\1\s\backend\Origam.Server\Controller\AbstractController.cs:line 117
ClientConnectionId:f53ab953-a5f1-46ea-b85a-bd6ea0b1ce48
Error Number:8116,State:1,Class:16