Filtering by TagInput column: Sequence contains no matching element

2021.1.0.2225

When I’m filtering root grid of lazily loaded screen, if there is already filter by lookup column and I try to add filter by tag input column, I get following error when typing in the filter value:

{
   "ClassName":"System.InvalidOperationException",
   "Message":"Sequence contains no matching element",
   "Data":null,
   "InnerException":null,
   "HelpURL":null,
   "StackTraceString":"   at System.Linq.ThrowHelper.ThrowNoMatchException()\n   at Origam.DA.Service.AbstractSqlCommandGenerator.SetColumnExpressions(ICustomCommandParser commandParser, Dictionary`2 lookUps, Boolean isInRecursion, DataStructureEntity entity, DataStructure ds, Hashtable replaceParameterTexts, Hashtable selectParameterReferences, Hashtable dynamicParameters, IEnumerable`1 dataStructureColumns, ColumnsInfo columnsInfo) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\Generators\\AbstractSqlCommandGenerator.cs:line 2004\n   at Origam.DA.Service.AbstractSqlCommandGenerator.RenderSelectColumns(SelectParameters selectParameters, StringBuilder sqlExpression, StringBuilder orderByBuilder, StringBuilder groupByBuilder, Hashtable replaceParameterTexts, Hashtable selectParameterReferences, Boolean isInRecursion, Boolean concatScalarColumns, Boolean forceDatabaseCalculation, FilterCommandParser filterCommandParser, OrderByCommandParser orderByCommandParser) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\Generators\\AbstractSqlCommandGenerator.cs:line 1878\n   at Origam.DA.Service.AbstractSqlCommandGenerator.SelectSql(SelectParameters selectParameters, Hashtable replaceParameterTexts, Hashtable selectParameterReferences, Boolean restrictScalarToTop1, Boolean isInRecursion, Boolean forceDatabaseCalculation, FilterCommandParser filterCommandParser, OrderByCommandParser orderByCommandParser) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\Generators\\AbstractSqlCommandGenerator.cs:line 1042\n   at Origam.DA.Service.AbstractSqlCommandGenerator.BuildCommands(IDbDataAdapter adapter, SelectParameters selectParameters, Boolean forceDatabaseCalculation) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\Generators\\AbstractSqlCommandGenerator.cs:line 361\n   at Origam.DA.Service.AbstractSqlCommandGenerator.CreateDataAdapter(SelectParameters adParameters, Boolean forceDatabaseCalculation) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\Generators\\AbstractSqlCommandGenerator.cs:line 160\n   at Origam.DA.Service.AbstractDataService.GetAdapter(SelectParameters selectParameters, UserProfile userProfile) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\AbstractDataService.cs:line 157\n   at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReader(DataStructureQuery query, IPrincipal principal, String transactionId) in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\AbstractSqlDataService.cs:line 1562\n   at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReaderInternal(DataStructureQuery query)+MoveNext() in D:\\a\\1\\s\\origam-source\\Origam.DA.Service\\AbstractSqlDataService.cs:line 1698\n   at System.Linq.Enumerable.SelectEnumerableIterator`2.MoveNext()\n   at Origam.ServerCore.Controller.UIServiceController.StreamlineFilterListValues(IEnumerable`1 fullReaderResult) in D:\\a\\1\\s\\origam-source\\Origam.ServerCore\\Controller\\UIServiceController.cs:line 629\n   at CSharpFunctionalExtensions.ResultExtensions.Bind[T,K,E](Result`2 result, Func`2 func)\n   at Origam.ServerCore.Controller.UIServiceController.<>c__DisplayClass58_0.<GetFilterListValues>b__0() in D:\\a\\1\\s\\origam-source\\Origam.ServerCore\\Controller\\UIServiceController.cs:line 591\n   at Origam.ServerCore.Controller.AbstractController.RunWithErrorHandler(Func`1 func) in D:\\a\\1\\s\\origam-source\\Origam.ServerCore\\Controller\\AbstractController.cs:line 120",
   "RemoteStackTraceString":null,
   "RemoteStackIndex":0,
   "ExceptionMethod":null,
   "HResult":-2146233079,
   "Source":"System.Linq",
   "WatsonBuckets":null
}
1 Like

Please provide more info about the solution as it has an influence on the functionality.

Contents of the Taginput filter dropdown will not respect existing filters. It will contain all options from all rows even those currently hidden by the active filters.

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.