Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer Service forum / couldn’t find a ‘like’...
Customer Service forum

couldn’t find a ‘like’ operator for multi-select parameter dynamics 365

(0) ShareShare
ReportReport
Posted on by elmaslouhi1 185

Hi guys, I’m building a report using SSRS with fetchxml query and i’m facing a problem since yesterday.

I couldn’t found a ‘like’ operator for multi-select parameter

Here is my need:

I have a multi-select parameter called @Process_Stage

temp1.PNG

that I pass to my fetch raquest

<link-entity name="saft_ceopportunitypresalesprocess" from="bpf_opportunityid" to="opportunityid" alias="process" >
      <attribute name="activestageid" />
      <filter type="and">
        <condition attribute="activestageidname" operator="contain-values" value="@Process_Stage"/>
      </filter>
</link-entity>

For example, I need to get a result wether the process stage is equals to ‘4. Offer’ or ‘4. Offer (fast track)’ and so on

Hope I was clear enough

Thank you guys in advance ;)

Categories:
Other
  • LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: couldn’t find a ‘like’ operator for multi-select parameter dynamics 365

    Hi partner,

    I am very glad to hear that your issue has been successfully resolved and thanks for your sharing.

    This will help more people with similar problems get solutions.

    Best Regards

    Leo

  • Verified answer
    elmaslouhi1 Profile Picture
    elmaslouhi1 185 on at
    RE: couldn’t found a ‘like’ operator for multi-select parameter dynamics 365

    Thank you Leo for your answer, but 'like' only works when we're comparing with one value and it's not our purpose here.

    Anyway I reached that by changing in the fetch request

    <link-entity name="saft_ceopportunitypresalesprocess" from="bpf_opportunityid" to="opportunityid" alias="process" >

     <attribute name="activestageid" />

     <link-entity name="processstage" from="processstageid" to="activestageid" link-type="inner" alias="aa" >

       <filter type="and" >

         <condition attribute="stagecategory" operator="in" value="@Process_Stage" />

       </filter>

     </link-entity>

</link-entity>

    and it works for both cases ‘4. Offer’ and‘4. Offer (fast track)’

  • Suggested answer
    LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: couldn’t found a ‘like’ operator for multi-select parameter dynamics 365

    Hi partner,

    You could use operator="like" value="%Value%".

    I have tried in my environment and it worked well.

    WeChat-Screenshot_5F00_20181207113057.png

    WeChat-Screenshot_5F00_20181207113057.png

    The usage rule of the percent sign is the same in Sql statement.

    Hope it helps.

    Best Regards

    Leo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans