Optionset Filtering

(0) Share

Report

Posted on by Community Member

i have two option sets , 1. gender->Male,Female 2. category->Mr.,Ms.,Prince,Princess. i want to filter category based on gender option value like ex1: gender : male --> category:Mr.,Prince ex2: gender: Female --> category : Ms.,Princess. After solution was moved to production, we added two more values to category like category:Mr.,Ms.,Prince,Princess,king,Queen so, without touching code how you achieve this..??? Please help me on this???

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (3)

Report
RE: Optionset Filtering

Hi ,

I don't think without code it is possible , you should move your solution or webresource.

There is two way you can do this using Javasscript , here is the sample -

function OptionSetAddRemove() { var optionSet = Xrm.Page.ui.controls.get("new_myoptionset"); var optionSetValues = optionSet.getAttribute().getOptions(); optionSet.clearOptions(); optionSetValues.forEach(function (element) { if (element.value == "831260009") optionSet.addOption(element); if (element.value == "831260008") optionSet.removeOption(element); }); }

In addition you can also do using xml webresource. please refer below.

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2015/developers-guide/gg594433(v=crm.7)

Above both the cases you need to move the web reosurce and in addition you need to move the solution to move the pick list value. So without code changes its not possible.

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (0)

Report

RE: Optionset Filtering

Hi,

You can try this solution and see if that's can help you: crmoptionsets.azurewebsites.net

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Optionset Filtering

But i hear that it is possible with some configurations

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Optionset Filtering

thanks for replay

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Optionset Filtering

No , there is no way to do using configuration only . If you want to do this using configuration then it will better to implement dependent lookup in dynamics CRM.

Please refer below -

www.powerobjects.com/.../how-to-use-dependent-lookups-for-dynamics-crm-201320152016

www.youtube.com/watch

Please dont forget to close this thread .

Was this reply helpful? Yes No
Suggested answer

Ben Thompson 6,350 on at

Like (0)

Report

RE: Optionset Filtering

It's not possible without some custom Javascript code. As Mahender points out however, this is a common requirement and someone has already solved this problem for you and he's provided a link to Guido's go-to solution for this.

Install it and follow the instructions and it just works....

Was this reply helpful? Yes No