Javascript for filtering lookup using option set

(0) Share

Report

Posted on by G.Vetere

I have the following code below, unfortunately i can't get it to work.

On my form I have an option set called:

Schema name: CaseTypeCode

Logical name: casetypecode

and

Schema name: xpg_CaseSubtype

Logical name: xpg_casesubtype

xpg_casesubtype is a lookup field and those records have a field called casetypecode as well using the same option set.

I want to filter xpg_casesubtype records by which casetypecode is chosen

I have come up with the following JS, but it doesnt seem to work, theres no error.

function filterLookupByOptionSet(executionContext) {
    var formContext = executionContext.getFormContext();
    var caseTypeCode = formContext.getAttribute("casetypecode").getValue();
	
    if (caseTypeCode != null) {
        var filter = "" "" "";
        formContext.getControl("xpg_casesubtypeid").addCustomFilter(filter);
    }
	else {
		formContext.getAttribute("xpg_casesubtype").setValue(null);
	}
}

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Eiken on at

Like (0)

Report

Hi,

The value obtained by "var caseTypeCode = formContext.getAttribute("casetypecode").getValue();" is an object whose first element is an array containing information about the lookup field.

This array contains the id(current record id), name(current value of lookup field) and entitytype(the logical name of the entity)

So I edit your code.

var filter = "<filter type='and'>"+"<condition attribute='xpg_casetypecode' operator='eq' value='" + caseTypeCode[0].id + "' />"+"</filter>";

or

var filter = "<filter type='and'>"+"<condition attribute='xpg_casetypecode' operator='eq' value='" + caseTypeCode[0].name + "' />"+"</filter>";

Was this reply helpful? Yes No
Suggested answer

XM-22040801-0 11 on at

Like (0)

Report

Hello,

addCustomFilter() must be called in a addPreSearch handler.

If you call addCustomFilter() in an on load event (for example), it won't work.

See learn.microsoft.com/.../addcustomfilter

Was this reply helpful? Yes No
Suggested answer

Eiken on at

Like (0)

Report

Hi,

Did my answer help you ?

If yes, please don't forget to click Yes under "Did this answer your question?" to close this thread.

Was this reply helpful? Yes No