You need to sign in to do that
Don't have an account?
Query error
Hey guys,
I'm having a hard time combining filters. I am trying to figure out what's wrong with this query:
<?xml version="1.0"?>
<methodCall>
<methodName>sfdc.query</methodName>
<params>
<param>
<value>
<struct>
<member>
<name>select</name>
<value>
<array>
<data>
<value>
<string>company</string>
</value>
</data>
</array>
</value>
</member>
<member>
<name>filter</name>
<value>
<array>
<data>
<value>
<struct>
<member>
<name>operator</name>
<value>
<string>OR</string>
</value>
</member>
<member>
<name>value</name>
<value>
<array>
<data>
<value>
<struct>
<member>
<name>operator</name>
<value>
<string>contains</string>
</value>
</member>
<member>
<name>field</name>
<value>
<string>company</string>
</value>
</member>
<member>
<name>value</name>
<value>
<string>Achievers</string>
</value>
</member>
</struct>
</value>
<value>
<struct>
<member>
<name>operator</name>
<value>
<string>contains</string>
</value>
</member>
<member>
<name>field</name>
<value>
<string>company</string>
</value>
</member>
<member>
<name>value</name>
<value>
<string>ACN</string>
</value>
</member>
</struct>
</value>
</data>
</array>
</value>
</member>
</struct>
</value>
</data>
</array>
</value>
</member>
<member>
<name>version</name>
<value>
<string>2.0</string>
</value>
</member>
<member>
<name>type</name>
<value>
<string>lead</string>
</value>
</member>
<member>
<name>scope</name>
<value>
<string>filter</string>
</value>
</member>
<member>
<name>useCaseSafeIDs</name>
<value>
<boolean>1</boolean>
</value>
</member>
</struct>
</value>
</param>
</params>
</methodCall>
Any idea of what's wrong with it? Please help
Thank you in advance.
Hi Juan,
At first glance, it looks ok. Are you getting a fault response or just no hits?
Hey DevAngel,
Thanks for your reponse.
This is the error I get (forgot to mention before):
"field not specified in filter criterion in query call"
FaultCode 1100
Thanks!
Hi Juan,
The only thing that looks like like it ought to be changed, is the OR should be or. I don't think that will solve your error, but it's worth a try. I am assuming you have visibility to the company field in the lead entity for the user you are logging in as.
DevAngel,
You are good..... >: )
Thanks!, it was the the letters case that caused the error. I replaced "OR" by "or" and it worked!
I appreciate your help
Regards,
Juan Romero
Webmaster