DSXchange

Posted: **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.

Posted: **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

DSXchange

SOQL max function not working for Salesforce stage

SOQL max function not working for Salesforce stage