This discussion is archived
0 Replies Latest reply: Nov 6, 2012 5:12 PM by user8742475 RSS

Can you search based on how long Opportunity name is?

user8742475 Newbie
Currently Being Moderated
I want to get all Opportunities where name is longer than 40 characters. Below is my code in soapUI but it does not seem to work. Is this possible?

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:opp="urn:crmondemand/ws/ecbs/opportunity/" xmlns:quer="urn:/crmondemand/xml/Opportunity/Query">
<soapenv:Header/>
<soapenv:Body>
<opp:OpportunityQueryPage_Input>
<quer:ListOfOpportunity>
<quer:Opportunity searchspec="Len(FieldValue([<OpportunityName>]))>40">
               <quer:OpportunityName/>
</quer:Opportunity>
</quer:ListOfOpportunity>
</opp:OpportunityQueryPage_Input>
</soapenv:Body>
</soapenv:Envelope>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points