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
scoopscoop 

Unable to filter on ownerID

Hello,

I'm trying to do a query and filter on the ownerID.  I grab the ownerID from the login response and send it in the query below.  Instead of getting only the recordds for the owner I get all of the records.

<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <SOAP-ENV:Header>
  <tns:headerStruct id="id1">
   <session_id xsi:type="xsd:string">Y2yEm260JcBXwX.6IxHVST03gigYRpU2jpM7zsrJOEV4dh2tbEampE.tzWjidzk0qxfkZmVvHYFWA2ID7R7JFPbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2.0</version>
  </tns:headerStruct>
 </SOAP-ENV:Header>
 <SOAP-ENV:Body SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <q1:query xmlns:q1="sfconnector:SalesforceConnector">
   <scope xsi:type="xsd:string">filter</scope>
   <type xsi:type="xsd:string">account</type>
   <maxRows xsi:type="xsd:int">100</maxRows>
   <select href="#id1"/>
  </q1:query>
  <SOAP-ENC:Array id="id1" SOAP-ENC:arrayType="xsd:string[6]">
   <Item>name</Item>
   <Item>billingCity</Item>
   <Item>accountPhone</Item>
   <Item>ticker</Item>
   <Item>id</Item>
   <Item>ownerID</Item>
  </SOAP-ENC:Array>
  <SOAP-ENC:Array id="id2" SOAP-ENC:arrayType="xsd:anyType[1]">
   <Item href="#id3"/>
  </SOAP-ENC:Array>
  <SOAP-ENC:Array id="id3" SOAP-ENC:arrayType="tns:mapEntry[3]">
   <Item href="#id4"/>
   <Item href="#id5"/>
   <Item href="#id6"/>
  </SOAP-ENC:Array>
  <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">field</key>
   <value xsi:type="xsd:string">ownerID</value>
  </tns:mapEntry>
  <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">value</key>
   <value xsi:type="xsd:string">00530000000bzOA</value>
  </tns:mapEntry>
  <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">operator</key>
   <value xsi:type="xsd:string">equals</value>
  </tns:mapEntry>
  <useCaseSafeIDs xsi:type="xsd:boolean">1</useCaseSafeIDs>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Thanks,

Greg 

DevAngelDevAngel

Hi scoop,

Did this get resolved?  If not can you send me the username you use to login so I can do some research?  Thanks

scoopscoop

Dave,

I still have not got this to work.  The username of the account I'm logging into is greg@insidescoop.com, it is a developer version.  It seems that no matter what ownerid I put in I get all of the accounts back.  The other username I tried is cbadger@insidescoop.com.

Thanks.