on 04-27-2016 8:44 PM
Hi All,
we have a requirement to a bex variable with several single values.
once meta data is generated,how to pass multiple single values in URI.
please provide syntax.
Your help is much appreciated.
Hi All,
Thanks for all replies.
we figured out a solution by passing the value of filters to the variables of Bex query in the classes generated by ODATA query.
Filters works once the result set is generated(millions of records).but we need the result set (hundreds of records)to be generated based on the values given.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
You have a question and need help by the community? Instead of posting into an old question thread, it is more helpful for you, if you create your own question. Here is how to get started:
That's it. Thank you!
Best regards
Jennifer
Your SAP Community moderator
Hi Samy,
You can filter by several values using the following url:
Collection?$filter=Field1 eq 'value1' and Filed2 eq 'value2' ...
If you want a real example, see the following post:
OData Query | Method Parameter | Alternative way to get the value | Coding required to implement Query Operation |
---|---|---|---|
UserCollection?$filter=UserID eq '123' and LastName eq 'Mahajan' | IT_FILTER_SELECT_OPTIONS and IV_FILTER_STRING | DATA: my_filter_options TYPE/iwbep/t_mgw_select_option, my_filter_string TYPE string. my_filter_options =io_tech_request_context->get_filter( )->get_filter_select_options( ). my_filter_string = io_tech_request_context->get_filter( )->get_filter_string( ). | Yes |
Regards,
Emanuel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Emanuel,
thanks for the quick response,
we are trying to pass the values to variables before we get usercollection.
filter option works once usercollection is filled with data.
any way can we pass multiple values to a parameter entity.(we are looking for several single values for a variable as input for query to execute)
please correct me if am wrong.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
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.