Filter lookup based on the optionset selected

(0) Share

Report

Posted on by CRM Beginner

795

Hi All,

My requiremene is i have an optionset and a lookup in header in Case.I want to filter the lookup on the basis of optionset selected.

Thanks for any help!

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (2)

Sort by

Suggested answer

Iswarya 1,347 on at

Like (0)

Report
Copy link

Link copied!

Hi,

see this

www.aayushsingh.in/.../how-to-add-custom-filter-lookup-field.html

Was this reply helpful? Yes No
Suggested answer

ARIFNIIT 1,391 on at

Like (1)

Report
Copy link

Link copied!

Write JavaScript on Change event of optionset and apply fetchxml filters for lookup,

Was this reply helpful? Yes No
CRM Beginner 795 on at

Like (0)

Report
Copy link

Link copied!

Hi Arif,

I am getting this error : "An exception System.FormatException was thrown while trying to convert input value 'Package' to attribute 'new_twg_defectcategory.new_twg_problemcategory'. Expected type of attribute value: System.Int32. Exception raised: Input string was not in a correct format." Can you tell me why its coming ?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi CRM Beginner,

Post your whole code, if possible so that we are able to find what is wrong?

Thanks

Regards,

AW

Was this reply helpful? Yes No
Verified answer

CRM Beginner 795 on at

Like (0)

Report
Copy link

Link copied!

Thanks All for replies...I resolved it..

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you please share your the resolution here so that it can help others?

Was this reply helpful? Yes No
ARIFNIIT 1,391 on at

Like (0)

Report
Copy link

Link copied!

did you solve your error? if not please share your code and tell me complete requirement.

Was this reply helpful? Yes No
Verified answer

CRM Beginner 795 on at

Like (0)

Report
Copy link

Link copied!

Yes Arif , thanks for replying..I solved it. Here is my complete code -:

function filter_Lookup_Fields()

{

if (Xrm.Page.getControl('header_process_new_problemcategory') != null)

{

Xrm.Page.getControl('header_process_new_defectcategory').addPreSearch(addFilter);

}

}

function addFilter() {

var problemcategoryoptionset ;

var fetchQuery;

try {

problemcategoryoptionset = Xrm.Page.getControl('header_process_new_problemcategory').getAttribute().getValue();

if (Xrm.Page.getControl('header_process_new_problemcategory') != null && Xrm.Page.getControl('header_process_new_problemcategory').getAttribute().getValue() != null) {

fetchQuery = "<filter type='and'>" +

"<condition attribute='statecode' operator='eq' value='0' />" +

"<condition attribute='new_problemcategory' operator='eq' value='" + problemcategoryoptionset + "' />" +

"</filter>";

//add custom filter

Xrm.Page.getControl('header_process_new_defectcategory').addCustomFilter(fetchQuery);

}

}

catch (e) {

Xrm.Utility.alertDialog('addFilter Error: ' + (e.description || e.message));

}

}

Was this reply helpful? Yes No
ARIFNIIT 1,391 on at

Like (0)

Report
Copy link

Link copied!

header_process_new_problemcategory is lookup? what is the type of field new_problemcategory?

Was this reply helpful? Yes No
CRM Beginner 795 on at

Like (0)

Report
Copy link

Link copied!

Both are optionset

Was this reply helpful? Yes No