Change Saved Search directly in the DB

,
1

Hello,

I am trying to make some changes to saved searches directly in the database.
I have found out that the saved searches are stored in the T_WM_XT_SAVED_SEARCH table but I do not know in which table the relation between the user (TBLTHINGNAME.ITEMNAME=“userId”) and his saved searches are stored. Could someone help on this topic?

I have also found out that when a user deletes a saved search these are not visible anymore to the sysadmin user (Folders>System>Saved Searches>TaskName>userDN), or to the user himself, but they are not deleted from the table T_WM_XT_SAVED_SEARCH. Could someone please explain how this works and which is the relation between the table and the savedSearches?

Thank you,

Odina

2

The saved searches are stored in the following places :

  • t_xm_xt_saved_search → the saved search itself
  • tblthingname → the name of the saved search
  • unknown place → technical name of the saved search

After deleting the registrations from the tables t_xm_xt_saved_search and
tbthingname the user gets an error message when logging in → the technical
name of the saved search is still present in the DB and the framework tries to
load this saved search but finds no connection to its name.

Does anyone know where the technical name of the saved search is stored?