Customer Service forum

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

(0) Share

Report

Posted on by elmaslouhi1

187

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

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

All responses (3)

Answers (1)

Sort by

Suggested answer

LeoAlt 16,341 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi partner,

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

I have tried in my environment and it worked well.

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

Hope it helps.

Best Regards

Leo
Verified answer

elmaslouhi1 187 on at

Like (0)

Report
Copy link

Link copied!
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)’
LeoAlt 16,341 Moderator on at

Like (1)

Report
Copy link

Link copied!

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