How to extend TREX index?

[Former Member]

Hi All,

does anyone know is it possible to extend TREX index with a new column?

I want to do that to search TREX for documents that have specific date.

1.I'd like to add a new column with type dats.

2.Then fill this column with data by select to database (usr02 table) - is it possible to extend query of a

search engine service that replicates the business objects from the database into the TREX index?

3.And finally extend the search query from e-Recruiting to TREX index that the index returns only documents for which a value in my new column is set as required.

Thanks for any help.

Lukasz

[Former Member]

Hi,

hope I understand your requirement:

You wnt to search for documents that have a specific date, for example SOP or Due Date.

Than you have to create a new property for dates (SOP or Due date).

When uploading documents you can choose a value for date.

Its also possible to extend your Seacrh Dialog so that you can search for documents referring this date.

Hope it helps

Steve

[Former Member]

Hi,

thanks for response.

I finally added a new column to search index for TREX, this column is standard LAST_CHANGED_BY.

Having this column in index I'm able to find out what is the name of the user, who changed the document indexed in trex. When I have the user, I also have form USR02 last login date for the user.

Now the dificult is how to add to search query for TREX a username that refers to my LAST_CHANGED_BY in index.

I've found a method (ADD_FILTER_ATTR) in search manager (CL_HRKWF_SEARCH_MANAGER) interface that ads attributes to query. I've added there a few usernames, but searching result is 0.

So now, I'm trying to find out how to properly add attribute - username to search query for TREX.

Regards