Return
-
Title
Web error when filtering on foreign key columns -
Description
On the front-end will be displayed error "Object reference not set to an instance of an object"
This error is captured in the web log:
System.NullReferenceException: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at QBM.CompositionApi.FilterStrategy.SearchFilterStrategyBuilder.<TryGetAllIndexedColumnsForWhereClause>b__31_2(IMetaColumn x) at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at QBM.CompositionApi.FilterStrategy.SearchFilterStrategyBuilder.TryGetAllIndexedColumnsForWhereClause(IEnumerable`1& columns) at QBM.CompositionApi.FilterStrategy.SearchFilterStrategyBuilder.<GetInternalAsync>d__27.MoveNext()
-
Cause
The issue occurs when there is an out-of-the-box database table using a custom foreign key.
Example:
On a standard table with standard foreign key : filter works as expected.
On a custom table with a custom foreign key: filter works as expected
On a standard table with a custom foreign key: Error is thrown. -
Resolution
This is a product defect. Please contact support and request hotfix #465162.