Question Re: Apply Filter on JSON Model in Technology Q&A

Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 19:11:38 GMT

Hi,

I got a JSON model as follows

{

"items": [

{

"name": "Test1,

"description": "Description1"

{

"name": "Test2",

"description": "Description2"

}

]

}

Binding:

var oModel = new sap.ui.model.json.JSONModel();

oModel.loadData("./json/items.json",null,false);

Is there any way I can filter at this spot by name name=Test1

The reason is that I have form layout in which I want to only show this filtered value

Re: Apply Filter on JSON Model

former_member182372 — Mon, 16 Nov 2015 19:23:57 GMT

filter is a binding thing, not model. you can do grep once data is loaded

Re: Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 19:27:00 GMT

Do you have example for such as I have a FormLayout where I am attaching this JSON Model

oFormLayout.setModel(oModel);

and here I want to put my filter so that Form Element should display only the filtered values from the JSON.

Re: Apply Filter on JSON Model

former_member182372 — Mon, 16 Nov 2015 19:27:46 GMT

what aggregation do you bind it to?

Re: Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 19:30:48 GMT

this is complete code listing:

	var oModelPrDetails = new sap.ui.model.json.JSONModel();
	oModelPrDetails.loadData("./json/PR_Workitems.json",null,false);


	var oGridLayout = new sap.ui.layout.form.ResponsiveGridLayout("PRIGridLayout");
	var oFormLayout = new sap.ui.layout.form.Form("PRIFormLayout", {
		layout: oGridLayout
	})

	var oFContainer = new sap.ui.layout.form.FormContainer("TaskData",{
		title: new sap.ui.core.Title({
	text: "Task Information",
	tooltip: "Task Info"
		})
	});

	var oFETask = new sap.ui.layout.form.FormElement("Tasks", {
		label: "Task Information",
		fields: new sap.m.Input({
			type: sap.m.InputType.Text,
value: "{name}",
		})
	});



	oFormLayout.setModel(oModelPrDetails);

	oFContainer.addFormElement(oFETask);
	oFormLayout.addFormContainer(oFContainer);

Re: Apply Filter on JSON Model

former_member182372 — Mon, 16 Nov 2015 19:37:24 GMT

oModel.attachEvent("requestCompleted", function() {

var data = oModel.getData();

data = $.grep(data.items, function(elementOfArray, indexInArra){ return elementOfArray.name === 'Test1' });

oModel.setData(data);

}, this);

Re: Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 22:11:03 GMT

Hi Usman

you can test this

JS Bin - Collaborative JavaScript Debugging

Thanks

-D

Re: Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 22:34:45 GMT

another example that you can do binding on the fly

JS Bin - Collaborative JavaScript Debugging

Re: Apply Filter on JSON Model

former_member182372 — Mon, 16 Nov 2015 23:01:14 GMT

there is a side effect of this approach, when you have to reaplly a filter, you would need to clean application filters

var binding = oList.getBinding("items");

binding.aApplicationFilters = [];

binding.filter(...);

Re: Apply Filter on JSON Model

Former Member — Mon, 16 Nov 2015 23:13:10 GMT

yes. good catch

corrected the jsbin

JS Bin - Collaborative JavaScript Debugging

Thanks

-D

Re: Apply Filter on JSON Model

Former Member — Wed, 18 Nov 2015 17:22:13 GMT

Hi,

Actually I had to loop accross to get the items and that worked with a charm. $grp was not working so i decided to loop it

Re: Apply Filter on JSON Model

former_member182372 — Wed, 18 Nov 2015 22:24:08 GMT

sorry, grep code has a problem, should be

oModel.attachEvent("requestCompleted", function() {

var data = oModel.getData();

data = $.grep(data.items, function(elementOfArray, indexInArra){ return elementOfArray.name === 'Test1' });

oModel.setData( {items : data });

}, this);

Re: Apply Filter on JSON Model

venkatachala_ck — Thu, 19 Nov 2015 04:01:23 GMT

Hi,

checkout this link