Filter table in sapui5: Internal server error

[Former Member]

Hi Experts,

I can get the data from SAP tables and show them in the SAP UI5 table.

Although, when I try to filter the data in table.bindRows , the system gives the HTTP internal server error.

oTable.bindRows({

  path: '/RFCdataSet',

  filters:  [new sap.ui.model.Filter({

                path: 'RfcDesc',

                operator: sap.ui.model.FilterOperator.EQ,

                value1: "Test1"

           })]

  });

I have attached the files.

Could anyone let me know the cause of the error?

Regards,

Amruta

[Former Member · Accepted solution]

I could resolve this issue. Apparently, GET_ENTITYSET method needs to pass another parameter for filtering. I am using a function module which is mapped to GET_ENTITYSET method.

My key and the filter parameter were the same. So I had to create a dummy search parameter which acts as an input parameter for the function module.

Since, the result is mapped to the parameter "RfcDesc" (in the 3rd row) , I can not use it as input parameter for my funciton module.

Thus, I created another parameter "SearchRfcDesc" which is then passed to the function module.

Function module code snippet:

This resolved the issue and I then get the below result:

Regards,

Amruta

[Former Member]

Hi,

Im trying to do filter in server side itself! is that ok. I got value to be filtered, send request to backend values get filtered and gets return. Table gets refreshed after updating backend value.

Thanks,

[Former Member]

Also, when i test the oData service independently, using url

http://wfgteides01.wfg.local:8000/sap/opu/odata/sap/Z_ONLINE_EFC_SRV/RFCdataSet?$filter=RfcDesc eq Test1

I get the below error

Could anyone please let me know the cause behind this? Or where to look for the error?

Regards,

Amruta

[scott_stefanich]

Check for ABAP runtime errors in the back-end SAP system using transaction ST22.

Regards,

Scott

[Former Member]

Hi Scott,

Thank you for the suggestion. I checked today, but there are no runtime errors recorded in ST22.

What else could be the reason?

Is there any other way in which I can filter the table data?

Regards,

Amruta

[Former Member]

Unfortunately, it is not m.table. It is sap.ui.table.Table. with oData model

Whenever I use the filter like above it throws this error.

Could you please help me with this?

I have a search field and depending upon its value, I want to show the filtered data in the table.

[karthikarjun]

Hi AS D,

oTable.bindRows({

  path: '/RFCdataSet',

  filters:  [new sap.ui.model.Filter(

                 'RfcDesc', sap.ui.model.FilterOperator.EQ,"Test1" )

]

  });

Refer this:

Thanks,

Karthik A

[Former Member]

hi

Put an external breakpoint in your backend gateway services and debug. I think this is due to runtime errors in the backend.