You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL Where in clause with CustomFields

Received Response
3
Views
6
Comments
edited Nov 8, 2016 4:10AM in Integrations and APIs 6 comments

Content

We have tested every known way to use the QueryObject.Query() method to "SELECT Contact FROM Contact WHERE c$guid IN 'SomeGuidNumber', 'SomeOtherGuid';" however, this query fails. The failure ends like something like 'IN-Based sub-queries are not permitted". If we use "SELECT Contact FROM Contact WHERE c$guid IN ('SomeGuidNumber', 'SomeOtherGuid');" We get "Error in the query object".  The "IN" clause does work with named columns like "Select Contact from Contact where Contact.Name.First IN ('BRAD','MARY') LIMIT 10;  Returns maybe 10 objects. Why can we do this with named objects but not with CustomFields ? And our <CustomField name="c$guid" > really.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!