Wednesday 18 April 2012

option set filter in dynamic crm 2011.

 this  is for filter the two optional sets:

ex : new_country attribute have the 4 values : like India, USA, Japan, China
 if you select India, the new_states filed need to show the states belongs to india.

for this we can use this javascript:
place this java script function in Form Properities :
Onchange event of new_country attribute.
 





http://www.magnetism.co.nz/blog/zhenyu/12-01-18/Filter_Option_sets_by_another_field_in_Dynamic_CRM_2011.aspx

http://msdn.microsoft.com/en-us/library/gg334409.aspx

http://msdn.microsoft.com/en-us/library/gg328130.aspx
http://crmbusiness.wordpress.com/2011/02/17/crm-2011-javascript-xrm-page-basics/


refer above link for details:

function PicklistOneOnchange()
{

var optionsetControl = Xrm.Page.ui.controls.get("new_states");
var options = optionsetControl.getAttribute().getOptions();
var type = Xrm.Page.getAttribute("new_country").getValue();
if (type == 852700000)
{
optionsetControl.clearOptions();
for (var i = 0; i <options.length - 1; i++)
{
if (i == 1 || i == 2 || i == 3 || i == 4 || i == 5 || i == 6)
{
optionsetControl.addOption(options[i]);
}
}

}

if (type == 852700001)
{
optionsetControl.clearOptions();
for (var i = 0; i < options.length - 1; i++)
{
if (i == 7 || i == 8 || i == 9)
{

optionsetControl.addOption(options[i]);
}

}


}
if (type == 852700002)
{
optionsetControl.clearOptions();
for (var i = 0; i < options.length - 1; i++)
{
if (i == 10 || i == 11 || i == 12 || i == 13 || i == 14 || i == 15)
{

optionsetControl.addOption(options[i]);
}

}


}

if (type == 852700003)
{
optionsetControl.clearOptions();
for (var i = 0; i < options.length; i++)
{
if (i == 16 || i == 17 || i == 18)
{

optionsetControl.addOption(options[i]);
}

}



}
if (type == null )
{

optionsetControl.clearOptions();

for (var i = 1; i < options.length; i++)
{


optionsetControl.addOption(options[i]);


}

}
}


No comments:

Post a Comment