ESH modeler - how to filter data

[Former Member]

Hi,

I've setup indexing in TREX in Enterprise Search for activities data from CRM (in ESH_COCKPIT). But now I need to filter data available in this search. I want to index only some particular activities types in TREX. How I can do it?

(BADI, esh_modeler, or else)?

BR
Radek

[zbigniew_h · Accepted solution]

Hi Radek,

To achieve this You'll have to add an entry to the table WFCD_ES_BOL_QPAR (Assign parameters to BOL extraction query). For example:

Let's say You've created a search connector for activities (BUS2000126) and You want to limit the index only to some specific BT types.

Needed table entry:

SAP_SW_COMP: software component name (tab: general in the esh_cockpit for you connector)

TEMPALTE_ID: same tab as above - field: model

BOL_QUERY: can be found in table WFCD_ES_BOL_Q using above two fields as the key

SEQUENCE_NUM: 01 if there's no other entry with this key or just a next free number

ATTR_NAME: PROCESS_TYPE

SIGN: I

OPERATOR: EQ

LOW: ZXXX

where ZXXX is Your BT type

Please remeber to recreate the index after adding the entry(ies).

BR,

Z.