09-25-2019 11:25 PM
I would like to check when Contacts doesn't have a Picture .
I make a Lookup in the Contact Table using the following c# code and get a null reference in getting the CriteriaColumn:
ContactFieldDescriptor ImageField = MyFunctionToGetTheDescriptor("Picture");
CriteriaColumn cc = _ActFwk.Lookups.GetCriteriaColumn(ImageField );
Criteria c = new Criteria(LogicalOperator.And, 0, 0, cc, OperatorEnum.ContainsData, ValueEnum.Nothing);
c.Validate(); Fail with a Column NULL.
ImageField is a valid ContactFieldDescriptor as show the following VS Spy...
Any Idea ?
Thanks in Advance
10-05-2019 02:06 PM - edited 10-05-2019 02:06 PM
Your field is stored in a spill-over table (CUST_ContactsTableau1_120215) and not in the main TBL_CONTACT table.
CriteriaColumn doesn't work with spill-over tables. Long-time known bug.