locked
in operator in fetch xml RRS feed

  • Question

  • Dear ALL;

    i have an array of guid id of contact how can i pass the guids in the fetch xml using in operator please help

    Tuesday, November 6, 2012 12:57 PM

Answers

All replies

    • Marked as answer by anwar_addi Tuesday, November 6, 2012 1:41 PM
    Tuesday, November 6, 2012 1:02 PM
  • Hi anwar,

    <filter type="and">
              <condition attribute="contactid" operator="in"  value="{8A6057EB-3525-4A61-9148-020BDEEBD653}" />
            </filter>

    if contactid is not worked ,, you can use contactidValue , you please check what value would come by simply drag contactid and contactidValue into textbox on report.

    (Mark  as Answer and vote as helpful)

    Thanks,

    SASANK K 

    Tuesday, November 6, 2012 1:05 PM
  • Hi,

    you could try something like this (haven't tested it though):

    <fetch mapping='logical'>
        <entity name='serviceappointment'>
            <all-attributes />
            <filter type='and'>
                <condition attribute='regardingobjectid' operator='in'>
                    <value>7579A28E-FC3A-DB11-B7BC-00142209B048</value>
                    <value>A0A9A7DA-F23A-DB11-B7BC-00142209B048</value>
                </condition>
            </filter>
        </entity>
    </fetch>

    Greetings,

    Pavlos


    Please mark this reply as an answer and vote it as helpful if it helps you find a resolution to your problem.
    View my latest gallery contribution here.
    Visit my blog here.

    Tuesday, November 6, 2012 1:06 PM