function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
orzikorzik 

SForce Connector SOQL includes statement

I have hard time using the following statement in SForce Connector.
-includes
-logical operators: and, or, not

Sample:
Table--------SOQL
Account------Field1---includes---value1 OR value2

OR with a comma:
Account------Field1---includes---value1, value2

It returns an error... any ideas?
Thanks,

gregory
ScotScot

Gregory,

These are not currently supported by the connector. I believe that Ron is planning to add the comma delimited version.

Scot

orzikorzik
thanks,
gregory
Ron HessRon Hess

here it is

http://forums.sforce.com/sforce/board/message?board.id=VB_development&message.id=439

have fun, it supports comma sep lists in the value field of the query cell so you can have

pick | includes | this,that

and it will expand to SOQL "where (pick includes this) or (pick includes that)"

this is posted on the board and not on sourceforge yet to get some more testing time on the new features.

Message Edited by Ron Hess on 12-19-2004 09:15 PM

orzikorzik
Thanks, I will start testing it right away. Should there be some issues I will report them back to you.
--
gregory