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
Juan RomeroJuan Romero 

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.

DevAngelDevAngel

Hi Juan,

At first glance, it looks ok.  Are you getting a fault response or just no hits?

 

Juan RomeroJuan Romero

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!

DevAngelDevAngel

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.

Juan RomeroJuan Romero

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