IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Change Saved Search directly in the DB

  • 1.  Change Saved Search directly in the DB

    Posted Wed January 18, 2012 08:14 AM

    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


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Change Saved Search directly in the DB

    Posted Tue January 31, 2012 05:32 AM

    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?


    #webMethods
    #Integration-Server-and-ESB


Related Content