Question Re: Filter Option using Tcode - SEGW in Technology Q&A

Filter Option using Tcode - SEGW

Former Member — Wed, 13 Nov 2013 22:48:50 GMT

Hi All,

I am new to Odata services.. I am trying to create filter for object, while it fetch data using method - GET_ENTITYSET (Query). any how I am not able to do so..

I have selected the filter option at entity and entity_set.. but its not working..

I am passing filter parameters but in get_entityset method not getting data in table - IT_FILTER_SELECT_OPTIONS and IV_FILTER_STRING are coming blank..

Please advice how I can achieve it..

Regards,

Re: Filter Option using Tcode - SEGW

kammaje_cis — Wed, 13 Nov 2013 23:01:22 GMT

Can you share your URI? May the problem is in that,

Re: Filter Option using Tcode - SEGW

Former Member — Thu, 14 Nov 2013 15:30:33 GMT

Hi Krishna,

I am using get_entityset method to get filters.. In some of the article I read we need to do bit of coding to get the filter passed on URL..

DATA: lt_filters TYPE /iwbep/t_mgw_select_option,

*-get filter

lt_filters = io_tech_request_context->get_filter( )->get_filter_select_options( ).

I was able to read filter vales in program.. but in metadata whole entity is coming as filterable.. even though I have selected only couple of fields..

Any suggestions what I am missing..

Thanks...

Re: Filter Option using Tcode - SEGW

former_member184867 — Thu, 14 Nov 2013 16:44:09 GMT

Hi Rajesh,

by default all the properties are filterable ... if you need to set a property as non filterable you need to explicitly do that..

Regards,

Atanu

Re: Filter Option using Tcode - SEGW

kammaje_cis — Thu, 14 Nov 2013 23:05:35 GMT

As Atanu mentioned all properties are filterable by default. You can explicitly disable them using the corresponding API.

The fact that you marked as filterable or not- filterable has no bearing on the functionality. That is, if you mark a property as not- filterable, but pass the filter for that property in URI, and you have code to handle it, it will work. Metadata is only an indication for consuming clients, but does not validate/stop you.

Thanks

Krishna

Re: Filter Option using Tcode - SEGW

Former Member — Tue, 19 Nov 2013 16:17:51 GMT

Thanks, I am using following code to read the filter parameter values:

lt_filters = io_tech_request_context->get_filter( )->get_filter_select_options( ).

I am sure, it was working earlier but now in program LT_FILTER is not getting any value..

Re: Filter Option using Tcode - SEGW

kammaje_cis — Tue, 19 Nov 2013 16:22:46 GMT

that says problem is with your URI.

Thanks

Krishna

Re: Filter Option using Tcode - SEGW

Former Member — Tue, 19 Nov 2013 18:51:33 GMT

Thanks I checked the URL and its working fine ..