on 06-03-2014 10:57 AM
Hello ,
I am creating a UI5 application on CRM server. I have created ZBAPIs in CRM and I consume these ZBAPIs in Netweaver Gateway server to create ODATA service. I have used service builder tool to achieve this. Howevr $filter proprty is not working for any entity set.
When i fire below query :
/sap/opu/odata/sap/ZCRM_RESOURCEPLANNINGTOOL_SRV/ResourcesSet/?$filter=PartnerId eq '0000000190'
I get all the records.
The entity property Filterable is set.
Please suggest.
Sheetal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sheetal,
the input parameters of the Z function modules have to be range tables in order for the $filter function to fully work beyond eq
regards
Dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sheetal,
Remove slash ( / ) after entity set name and give the parameter names should be case sensitive which are same as in metadata
use below URL
/sap/opu/odata/sap/ZCRM_RESOURCEPLANNINGTOOL_SRV/ResourcesSet?$filter=PartnerId eq '0000000190'
The custom bapi is having input parameters not required to implement the filter logic in DPC_EXT class if you are using service builder,the builder automatically created filter logic for the input fields..please make sure your bapi, how it is working in debug mode..
Thanks
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sheetal,
you need to implement logic for filter in get_entityset method of DPC_EXT class.
you will get the filter values in the method parameter IT_FILTER_SELECT_OPTIONS.
There is alternative way to get the values as well. Please see my blog
so you have to read the filter value and then accordingly use it to filter data.
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 |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.