Microsoft Dynamics CRM (Archived)

Java Script filter condition in dynamics 365

(0) Share

Report

Posted on by BlackBeard

445

Hello Experts,

i want to add an extra parameter for my filter condition but i dont know how to do it.

At the moment we select all accounts with the businesstypecode "3", but i want to select the codes "4" and "5" as well.

I just need a simple "or" but i work with JScript for the first time ^^

    Filter.filterMaschinenringAccounts = function () {
        var maschinenringFilter = "<filter type='and'><condition attribute='businesstypecode' operator='eq' value='3'/></filter>";
        Xrm.Page.getControl("mrd_lu_zugehoeriger_mr").addCustomFilter(maschinenringFilter, "account");
}

Thank you in advance.

Léon

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

You can change your filter type and add multiple conditions:

var maschinenringFilter = "<filter type='or'>

<condition attribute='businesstypecode' operator='eq' value='3'/>

<condition attribute='businesstypecode' operator='eq' value='4'/>

<condition attribute='businesstypecode' operator='eq' value='5'/>

</filter>";

This is basically the filter part of the fetchXml.

If you need to get the different types of syntax, you can use Advanced Find to build your filter and download the FetchXml. Within the Xml, copy the Filter portion of the Xml to use it in the custom Filter.

Hope this helps.

Was this reply helpful? Yes No
Verified answer

chikhaleankush 547 on at

Like (0)

Report
Please find below the XML you need

<filter type='and'> <filter type="or"> <condition attribute='businesstypecode' operator='eq' value='3'/> <condition attribute='businesstypecode' operator='eq' value='4'/> <condition attribute='businesstypecode' operator='eq' value='5'/> </filter> </filter>

Ps. Mark this as answered if it solves your issue.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Leon,

I agree with Arvin.. Use advanced find and filter the the accounts based on the condition and download the fetch XML. Then cut the filter condition part and add it to the Javascript.

Was this reply helpful? Yes No
BlackBeard 445 on at

Like (0)

Report
Thank you for your help!

var maschinenringFilter = "<filter type='and'> " + " <filter type='or'> " + " <condition attribute='businesstypecode' operator='eq' value='5'/> " + " <condition attribute='businesstypecode' operator='eq' value='4'/> " + " <condition attribute='businesstypecode' operator='eq' value='3'/> " + " </filter> " + "</filter>";

With this code it works fine :)

Regards
Léon

Was this reply helpful? Yes No
ajyendra 1,738 on at

Like (0)

Report

Hi,

What If I have a lookup Field contain both account and Contact Records just like Customer Field in Case Form. I want to Show Records of only account with RelationShip type is Customer . Then What we prefer to filter that lookup field.

Thanks

Ajyendra

Was this reply helpful? Yes No