OData: Fetch records based on Search – using Wildcard Character (*)

OData Wildcard Character Search.

The post describes how to fetch records using wildcard characters.

Records of Table: SCARR

Goto T Code: SEGW and Create new project with desired name:

Created Project will appear in left panel of SEGW TCode.

Now Right click on Data model → Import → DDIC structure:

Provide the Entity name and Structure name as shown below:

Select the desired field and click on Next:

As at least one field should be Key field, selecting CARRID here as Key:

You can check the created Entity in sub nodes of Data Model

Now Generate Runtime Objects by clicking below button,

you’ll get a popup → Next → Save

In Runtime Artifacts node you can see the generated Classes and Service name. Here service name is ZMTEST4_WILD_CHARS_SRV

We need to write our logic in GET_ENTITYSET method of Data Provider Extension class (DPC_EXT)

Double click on DPC_EXT class and navigate to GET_ENTITYSET method (In our case it is: SCARRSET_GET_ENTITYSET). We need to redefine this method using button.

Importing parameter: IO_TECH_REQUEST_CONTEXT of GET_ENTITYSET method captures input search string from front end.

Table parameter: ET_ENTITYSET send output records to frontend.

Code written in GET_ENTITYSET method:

  TYPES : BEGIN OF ty_scarr,
carrid    TYPE s_carr_id,
carrname  TYPE  s_carrname,
currcode  TYPE s_currcode,
url        TYPE s_carrurl,
END OF ty_scarr.

  DATA : lt_scarr TYPE STANDARD TABLE OF ty_scarr,
lv_str   TYPE string,
lw_eset  TYPE zcl_zmtest4_wild_chars_mpc=>ts_scarr.

FIELD-SYMBOLS : <fs_scarr> TYPE ty_scarr.

* Get the InputValues from frontend
CLEAR : lv_str.
lv_str = io_tech_request_context->get_search_string( ).

We need to replace ‘‘ with ‘%’
REPLACE ALL OCCURRENCES OF ‘*’ IN lv_str WITH ‘%’.

* Fetch records from table SCARR
  REFRESH : lt_scarr[].
  SELECT carrid
         carrname
         currcode
         url
    FROM scarr
    INTO TABLE lt_scarr
    WHERE carrid LIKE lv_str.
  IF sy–subrc IS INITIAL.
    UNASSIGN <fs_scarr>.
    LOOP AT lt_scarr ASSIGNING <fs_scarr>.
      MOVE-CORRESPONDING <fs_scarr> TO lw_eset.
      APPEND lw_eset TO et_entityset.
      CLEAR : lw_eset.
    ENDLOOP.
    UNASSIGN <fs_scarr>.
  ENDIF.