BPM, Workflow, and Case

 View Only
  • 1.  BPMDB tables descriptions for Querying

    Posted Thu March 16, 2023 12:15 PM

    Hi BPM Group.

    If possible to have access to detailed information about BPMDB database tables and fields to make query's and get information about it, for example users and groups for reporting and consolidations of users information?

    For example tables like:

    LSW_USR
    LSW_USR_XREF
    LSW_USR_GRP_XREF
    LSW_USR_GRP_MEM_XREF
    LSW_GRP_GRP_MEM_XREF

    Thanks In Advance



    ------------------------------
    PABLO IBARRA DUPRAT
    ------------------------------


  • 2.  RE: BPMDB tables descriptions for Querying

    IBM Champion
    Posted Fri March 17, 2023 12:18 AM

    Hi Pablo,

    There are no official documentation available of these tables as these are product internal. It's not recommended to directly access product internal tables via SQL queries. There are APIs available to retrieve user/group information, you should use those instead.



    ------------------------------
    Atanu Roy
    Solution Architect
    Salient Process
    ------------------------------



  • 3.  RE: BPMDB tables descriptions for Querying

    Posted Fri March 17, 2023 07:49 AM

    Hi Atanu, 

    Thanks for your answer, you can give a reference to this API's please, some URL or documentation?

    Thanks in advance



    ------------------------------
    PABLO IBARRA DUPRAT
    ------------------------------



  • 4.  RE: BPMDB tables descriptions for Querying

    IBM Champion
    Posted Fri March 17, 2023 09:15 AM

    Hi Pablo,

    Here is the documentation of the REST APIs - https://www.ibm.com/docs/en/baw/20.x?topic=apis-rest-interface-bpd-related-resources

    You can test the REST APIs from - https://host:port/bpmrest-ui

    JavaScript API reference - https://www.ibm.com/docs/en/baw/19.x?topic=apis-javascript-api-in-processes-service-flows



    ------------------------------
    Atanu Roy
    Solution Architect
    Salient Process
    ------------------------------