SOQL max function not working for Salesforce stage

nandika.kodituwakku · Post by **nandika.kodituwakku** » Tue Sep 13, 2016 5:57 pm

Below SOQL returning null value from Salesforce stage, but if I run the same SOQL in Salesforce Developer console I'm getting the value.

Select max(LastModifiedDate) From POI__c p

Does that DataStage Salesforce stage connector support SOQL like above?

Appreciated your help on this.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2016 5:05 pm

It should do. Assuming that p is an alias for the table name, you may need to qualify the column name with that alias.

Code: Select all

Select max(p.LastModifiedDate) From POI__c p