on 09-29-2014 11:25 AM
hi All,
I am creating an odata service for read all requests which having same AppPernr (Perner of approver) value. I am trying to use filter in this but it is not working... Data type of AppPernr is PERSNO (NUMC 😎
When i am using following url its giving entire table values without any filteration:
http://xxx.xx.xx.xx:xxxx/sap/opu/odata/sap/ZGW_MOB_EXPMGMT_SRV/RequestListEntitySet?$filter=AppPernr eq '00040010'
And When I am using url as :
its giving me error as:
<ERROR_INFO>Invalid parametertype used at function 'eq' (Position: 10)</ERROR_INFO>
- <ERROR_RESOLUTION>
<SAP_NOTE>See SAP Note 1797736 for error analysis</SAP_NOTE>
<LINK_TO_SAP_NOTE>https://service.sap.com/sap/support/notes/1797736</LINK_TO_SAP_NOTE>
</ERROR_RESOLUTION>
Please help me in solving this issue.
Thanks and Regards,
Harshada
Tags were edited by: jitendra kansal
Hi Harshada,
You are saying that, the below URI works fine and it gives table output, Can you check by putting breakpoint in your RFC or DPC_EXT where ever your custom code implemeted ans see how the data is fetched in your backend.
http://xxx.xx.xx.xx:xxxx/sap/opu/odata/sap/ZGW_MOB_EXPMGMT_SRV/RequestListEntitySet?$filter=AppPernr eq '00040010'
If you want to display only AppPernr field in the response, you can add select filter to your URI
http://xxx.xx.xx.xx:xxxx/sap/opu/odata/sap/ZGW_MOB_EXPMGMT_SRV/RequestListEntitySet?$filter=AppPernr eq '00040010'&$select=AppPernr
Regards,
Vijay V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you implemented logic for filter in get_entityset method of class DPC_EXT class?
Regards,
Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.