Question Re: Filtering OData Model data at client side (SAP UI5 program) in Technology Q&A

Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

Re: Filtering OData Model data at client side (SAP UI5 program)

sun197895 — Fri, 09 Jan 2015 19:52:57 GMT

I have got all the data from Gateway Server to my SAPUI5 program. Now, I dont want to show all the data which I got but want to show only one particular line item. I tried putting filter but it is not working.

Can some one please help me how to use filter in OData model. Please note that I am trying to filter at client side and not at server side

SergioG_TX — Fri, 09 Jan 2015 21:30:18 GMT

https://cdchsb401.tyson.com/sap/ui5/1/sdk/#docs/api/symbols/sap.ui.model.odata.ODataModel.html

you may use the OData query syntax:

http://www.odata.org/documentation/odata-version-2-0/uri-conventions/

or you could also use the
oData.read function and passing filters.. look into the sdk and look for the filter object

pinakipatra — Sat, 10 Jan 2015 17:49:44 GMT

Hi ,

For general purpose filtering of odata you can use ?$filter = property eq 'value'

I your case you can use abc.xsodata/TDataSet?$filter = Scid eq 'value'

This should filter your odata values as Scid = value

You can refer :Home | OData - The Protocol for REST APIs

sun197895 — Mon, 12 Jan 2015 05:37:04 GMT

Hi Sergio,

For some reason filter is not working even though the syntax seems to be correct. Do we have to do any configuration at the Gateway server to make the filter work? Please advice. Below is the code which I using to filter.

-----------------

var oTable = new sap.ui.table.Table({width : "100%", visibleRowcount : 5});

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Scid"}), template : new sap.ui.commons.TextView({text : "{Scid}"}), visible : true}));

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Amnt"}), template : new sap.ui.commons.TextView({text : "{Amnt}"}), visible : true}));

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Zdesc"}), template : new sap.ui.commons.TextView({text : "{Zdesc}"}), visible : true}));

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Sctyp"}), template : new sap.ui.commons.TextView({text : "{Sctyp}"}), visible : true}));

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Createdby"}), template : new sap.ui.commons.TextView({text : "{Createdby}"}), visible : true}));

oTable.addColumn(new sap.ui.table.Column({label : new sap.ui.commons.Label({text : "Pdate"}), template : new sap.ui.commons.TextView({text : "{Pdate}"}), visible : true}));

oTable.setModel(oModel);

//oTable.bindRows({path: "/TDataSet"});

oTable.bindRows({path: "/TDataSet?$filter=Scid eq '1000940272'"});

return oTable;

----------------

Former Member — Mon, 12 Jan 2015 05:53:03 GMT

Hi Sun

You should do it this way.

-D

sun197895 — Mon, 12 Jan 2015 06:52:48 GMT

Thanks for your reply Dennis ..

oModel.read("/EntitySet('15')/Items", null,[ "$filter=val eq 'full' and key eq 'one'"]);

Can you please guide me what I should substitute for my scenario...like

In my case :

Entity Set : TDataSet

Property which I want to filter is : Scid

Vaue of the Scid I am looking for is : Scid = '12345'

So now, please tell me how my statement should look like .... should it look like below ?

oModel.read("/TDataSet('12345')/Scid", null,[ "$filter=val eq '12345' and key eq 'Scid'"]);

Former Member — Mon, 12 Jan 2015 07:38:04 GMT

Hi Sun

I believe it should be

oModel.read("/sap/opu/odata/sap/ZSCAPP_SRV/", null,[ "$filter=Scid eq '12345'"]);

-D

Qualiture — Mon, 12 Jan 2015 10:25:53 GMT

If you want to filter an OData model, the filter logic is on the server. Or, as the SAPUI5 docs mention it:


The OData model is a server-side model: the dataset is only available on the server and the client only knows the currently visible rows and fields. Sorting and filtering is done on the server. The client has to send a request to the server to accomplish these tasks.

sun197895 — Mon, 12 Jan 2015 11:05:07 GMT

Thanks for the response Robin. I have this problem going on for many days now and it is 10th day today.

I got your point that we have to do filtering at server side and not at client side. But can you tell how we can do it. I tried multiple ways in my SAP UI5 program but failed in every way. Please see where I need to correct.

Entity Set : TDataSet

Property with which I want to filter : Scid

I am sending request to client in below ways...

1) This gives me all the data as before which makes me believe that filter is not working.

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/",["$filter=val eq '1000940272' and key eq 'Scid'"]);

oTable.setModel(oModel);

oTable.bindRows({path: "/TDataSet"});

2) This also gives me all data as before which makes me think that filter is not working with this approach as well.

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/");

oTable.setModel(oModel);

oTable.bindRows({path: "/TDataSet?$filter=Scid eq '1000940272'"});

With the definition which you pasted in your reply, I guess the second way of filtering is wrong as I am here trying to filter at client and not at server. Having said that, someone on the blog said that the second way of filtering worked for him.

sun197895 — Mon, 12 Jan 2015 11:08:50 GMT

Hi Dennis,

No luck....I am still getting all data . Used below code.

var oModel = new sap.ui.model.odata.ODataModel();

oModel.read("/sap/opu/odata/sap/ZSCAPP_SRV/", null,[ "$filter=val eq '1000940272' and key eq 'Scid'"]);

in the above line when I use 'null' as one of the parameter it throws ''null pointer error". But when I remove the 'null' value then it works but then it gives me whole data which means it is not filtering.

Qualiture — Mon, 12 Jan 2015 11:54:18 GMT

Hi Sun,

I believe the 2nd option should be correct, although I;m not sure if you can directly specify a filter in pthe path when doing bindRows().

Alternatively, you could try the following:

var filter = new sap.ui.model.Filter("Scid", sap.ui.model.FilterOperator.EQ, : "12345");

table.bindRows("/TDataset",null,null,[filter]);

NB: Although you specify the filter in the client, the actual filtering takes place on the server, and it will only return the filtered data

sun197895 — Mon, 12 Jan 2015 12:19:11 GMT

Tried Robin...but still getting all rows

----------------

var filter = new sap.ui.model.Filter("Scid", sap.ui.model.FilterOperator.EQ, "1000940272");

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/");

oModel.read("/TDataSet", null, filter);

oTable.setModel(oModel);

oTable.bindRows({path: "/TDataSet"});

return oTable;

-----------------

Do I need to implement getEntity(Read) method in gateway server ?

jmoors — Mon, 12 Jan 2015 12:28:38 GMT

If you look in the developer tools, on the network tab, do you see the filter parameters as part of the HTTP request?

Also, have you checked that your oData service supports filtering? http://scn.sap.com/docs/DOC-43000

Regards,

Jason

sun197895 — Mon, 12 Jan 2015 12:51:33 GMT

Hi Jason,

I have attached the screenshot which has the trace. From the trace I can see the filter appended to the URL but not doing the job. I am still getting all the items which means filter is not working. Below is the code I have used.

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/");

oTable.setModel(oModel);

oTable.bindRows({path: "/TDataSet?$filter=Scid eq '1000940272'"});

Thanks in advance.

sun197895 — Mon, 12 Jan 2015 13:04:32 GMT

Now if I change the filtering slightly like below then it still load me all the data without filtering. However, in the developer tools I see a message which says that 'I have not implemented 'TDATASET_GET_ENTITY' METHOD. Below is the code which I used and the error message.

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/");

oModel.read("/TDataSet('1000940272')/Scid",[ "$filter=val eq '1000940272' and key eq 'Scid'"]);

--------------------------------------

2015-01-12 18:28:06 The following problem occurred: HTTP request failed500,Internal Server Error,<?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>SY/530</code><message xml:lang="en">Method 'TDATASET_GET_ENTITY' not implemented in data provider class</message><innererror><transactionid>54A97706DD470A12E10000000A298945</transactionid><timestamp>20150112125759.8021610</timestamp><Error_Resolution><SAP_Transaction>Run transaction /IWFND/ERROR_LOG on SAP NW Gateway hub system and search for entries with the timestamp above for more details</SAP_Transaction><SAP_Note>See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)</SAP_Note></Error_Resolution><errordetails><errordetail><code>/IWBEP/CX_MGW_NOT_IMPL_EXC</code><message>Method 'TDATASET_GET_ENTITY' not implemented in data provider class</message><propertyref/><severity>error</severity></errordetail></errordetails></innererror></error> -

------------------------------------------

sun197895 — Mon, 12 Jan 2015 13:24:45 GMT

Jason,

to your second question whether OData service supports filtering...

I have checked in the properties in the gateway project and it has the filter option ticked. When I checked the metadata I do not see the filterable attribute....please check below..the filterable attribute for some other properties is 'false' but for Scid it is not showing up. But when I chekedin the Gateway project the property has the filterable check-box checked.

---------------

-------------

jmoors — Mon, 12 Jan 2015 13:31:19 GMT

It's difficult to comment without what you have implemented the oData service, however it looks like you are trying to retrieve an particular entity, rather than the collection, have you implemented the method TDATASET_GET_ENTITY?

Regards,

Jason

jmoors — Mon, 12 Jan 2015 13:36:00 GMT

Have you changed the filter values, perhaps you need to clear the metadata cache? You could try clearing the cache of the gateway server via transaction /IWFND/CACHE_CLEANUP.

regards,

Jason

sun197895 — Mon, 12 Jan 2015 13:46:56 GMT

I am basically a Java portal developer so definitely I think I did not do proper set-up at gateway server and that could be leading to these issues.

Coming to your question of implementing TDATASET_GET_ENTITY method....what I did is..

right click on GET_ENTITY(query) and then did the mapping using RFC. And then generated artifacts.

Attached screenshot

Message was edited by: Sun 197895

var oModel = new sap.ui.model.odata.ODataModel("/sap/opu/odata/sap/ZSCAPP_SRV/");

new sap.ui.getCore().setModel(oModel);

sun197895 — Mon, 12 Jan 2015 16:01:53 GMT

Thanks all for the help.

Today I learned few things though was not able to fix my filter issue.

But after going through few other posts and specially which Jason mentioned, I feel I have not properly set-up my Odata service which I would be working upon now.

Thanks again.