Answered

Apply dynamic filter to subgrid in model-driven app using Javascript

(0) Share

Report

Posted on by Rydman

Hi,

I have a form for the table Project on which I have a subgrid for the table Objective (through one of its views). Objective has a lookup field for Phase. I want to apply a FetchXml query to the subgrid to filter on a specific Phase. I am able to find both the lookup string (eg. "Exploration") and the GUID stored in the Phase column of Objective referring to the lookup string. Right now I'm just trying to hard code the FetchXml string to filter the subgrid. This is what I've got:

SubGridFilterExecution = function (executionContext) {
	var formContext = executionContext.getFormContext();
	var gridContext = formContext.getControl("Subgrid_objectives");

			var FetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" +
			"<entity name='cr047_objective'>" +
			"<attribute name='cr047_Name' />" +
			"<attribute name='cr047_Description' />" +
			"<attribute name='cr047_Objectivemet' />" +
			"<attribute name='cr047_Mandatory' />" +
			"<filter type='and'>" +
			"<condition attribute='cr047_phase' operator='eq' value='{1c73-35c2-ec11-983f-6045bd948406}' />" +
			"</filter>" +
			"</entity>" +
			"</fetch>";

	gridContext.setFilterXml(FetchXml);
	formContext.getControl("Subgrid_objectives").refresh();
}

This renders zero rows in the subgrid. Removing the <filter> part of the string returns all rows, so the overall mechanics of the script seems to be OK.

Any help greatly appreciated!

Categories:

Power Apps component framework

All responses (4)

Answers (1)

NPrice99 1,292 on at

Like (0)

Report

Re: Apply dynamic filter to subgrid in model-driven app using Javascript

Hi
How do I Wire this into my Grid ?

Thanks

Nigel
rameshmukka 1,089 on at

Like (0)

Report

Re: Apply dynamic filter to subgrid in model-driven app using Javascript

@Rydman Do you know in similar context, how to get Main Grid context using Javascript. Your example is demonstrating about subgrid. I am struggling to get the main grid context and get FecthXML from main grid context. Let me know please.

Thanks
Ramesh Mukka
AnandM 41 on at

Like (0)

Report

Re: Apply dynamic filter to subgrid in model-driven app using Javascript

Hi @Rydman ,
Can we use this undocumented method in our implementations?
Verified answer

Rydman 96 on at

Like (0)

Report
Re: Apply dynamic filter to subgrid in model-driven app using Javascript

Hi,

My code is OK except for one small detail. My now working code looks like below. The only difference is that the curly brackets from the GUID are gone. Next step is to retrieve the GUIDs dynamically, but I'll google that before turning to the community 🙂

SubGridFilterExecution = function (executionContext) { var formContext = executionContext.getFormContext(); var gridContext = formContext.getControl("Subgrid_objectives"); var FetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" + "<entity name='cr047_objective'>" + "<attribute name='cr047_Name' />" + "<attribute name='cr047_Description' />" + "<attribute name='cr047_Objectivemet' />" + "<attribute name='cr047_Mandatory' />" + "<filter type='and'>" + "<condition attribute='cr047_phase' operator='eq' value='82ed1c73-35c2-ec11-983f-6045bd948406' />" + "</filter>" + "</entity>" + "</fetch>"; gridContext.setFilterXml(FetchXml); formContext.getControl("Subgrid_objectives").refresh(); }