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?