Can you please share AppPortal Database schema.
Sep 09, 2019 07:11 AM
Brinda,
Unfortunately, there is no published schema available for App Portal. Not sure if you are interested, but the following is overview of some of the most commonly referenced tables.
Sep 09, 2019 09:03 AM
Thank you for sharing this info!
Sep 10, 2019 11:20 PM
Sep 11, 2019 07:36 AM
Sep 13, 2019 05:21 AM
Sep 13, 2019 07:12 AM
Here is a sample query that returns Order Number, Request ID, Current Approver, and Current Approval Level. Feel free to modify as desired to suit your needs.
SELECT pr.OrderNo AS [Order Number], ap.RequestID_FK AS [Request ID], u.Email + ' (' + p.ADGUID + ')' AS [Current Approver], ap.GroupIndex AS [Current Approval Level] FROM WD_ApprovalProcess ap JOIN WD_PackageRequests pr ON ap.RequestID_FK = pr.RequestID LEFT JOIN WD_Profile p ON ap.ADGUID = p.ADGUID LEFT JOIN WD_User u ON p.UniqueUserName = u.UniqueName WHERE IsCurrentApprover = 1 ORDER BY pr.OrderNo, ap.RequestID_FK, p.UniqueUserName, ap.GroupIndex
Sep 17, 2019 03:26 PM