Community
Showing results for 
Search instead for 
Do you mean 
Reply

GetCriteriaColumn return null for Picture Field

Highlighted
New Member
Posts: 13
Country: France

GetCriteriaColumn return null for Picture Field

Hi Guys,

 

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

 

imageField.jpg

 

 

Highlighted
Nickel Contributor
Posts: 278
Country: Canada

Re: GetCriteriaColumn return null for Picture Field

[ Edited ]

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.

Gilles Cavin
http://www.exponenciel.com
Make sure you check our free Act! add-ons!
Create Web forms in seconds and import form results directly into Act! with Automatic Web Forms
check our latest add-on: Better Last Activity Date Tracking