Personal Insights
Wildcard Character Search in OData
Wildcard Character Search:
Wildcard character in a Select query is used to locate a specific item when you can’t remember exactly what to search.
To perform a wild card search, use the characters + and *.
+ will match any single character, and * will match any string of characters.
However, * can only be used as a wildcard at the beginning or end of a string.
Step1:
Create a new project in the SEGW T-Code.
Step2:
Add the properties by importing a structure/table.
Select the required fields/properties and mandatory to select at least one key filed from the list.
Generate Runtime objects.
Step3:
Now, redefine the AIRLINESET_GET_ENTITYSET method.
METHOD airlineset_get_entityset.
*** --- Get the Selected string
DATA(lv_str) = io_tech_request_context->get_search_string( ).
**** --- Replace
REPLACE ALL OCCURRENCES OF '*' IN lv_str WITH '%'.
*** --- Get Airline Details
SELECT carrid carrname currcode url FROM
scarr INTO CORRESPONDING FIELDS OF TABLE et_entityset
WHERE carrid LIKE lv_str.
IF et_entityset IS NOT INITIAL.
** -- Inline Count
es_response_context-inlinecount = lines( et_entityset ).
** -- Paging
CALL METHOD /iwbep/cl_mgw_data_util=>paging
EXPORTING
is_paging = is_paging
CHANGING
ct_data = et_entityset.
ENDIF.
ENDMETHOD.
Register the service.
Step4:
URI: /sap/opu/odata/SAP/ZWILD_CHARS_SRV/AirlineSet?search=A*&$format=json
Thanks for reading this blog.