Table name of Product
From which table does the Product displays all the contents.
Records --> Sysadmin --> Product
Product Name, Product version all the details are referred from which table in Pega CRM 7.3.1.
***Edited by Moderator: Pallavi to update platform capability tags***
Posted: 1 year ago
Hi,
Please check the blow query. This is the query running to pull the data.
WITH app_rulesets_pc0 AS ( SELECT "PC0AR".pzRuleSetName AS "pzRuleSetName", "PC0AR".pzRuleSetVersionMajor AS "pzRuleSetVersionMajor", "PC0AR".pzRuleSetVersionMinor AS "pzRuleSetVersionMinor", "PC0AR".pzRuleSetVersionPatch AS "pzRuleSetVersionPatch" FROM ( SELECT "PC0AR".pzRuleSetName, "PC0AR".pzRuleSetVersionMajor, "PC0AR".pzRuleSetVersionMinor, "PC0AR".pzRuleSetVersionPatch, ROW_NUMBER() OVER (PARTITION BY "PC0AR".pzRuleSetName ORDER BY "PC0AH".pzAppHeight) AS "pzRuleSetOrder" FROM PegaRulesSchema.pr_sys_app_hierarchy_flat "PC0AH" INNER JOIN PegaRulesSchema.pr_sys_app_ruleset_index "PC0AR" ON ("PC0AH".pzAppHash = "PC0AR".pzAppHash) WHERE "PC0AH".pzTopAppHash = ? ) "PC0AR" WHERE "PC0AR"."pzRuleSetOrder" = 1 UNION ALL SELECT CAST(? AS VARCHAR(128)) AS "pzRuleSetName", 1 AS "pzRulesetVersionMajor", 1 AS "pzRulesetVersionMinor", 1 AS "pzRuleSetVersionPatch" ) SELECT "PC0"."pyproductname" AS "pyProductName" , "PC0"."pyproductversion" AS "pyProductVersion" , CONCAT("PC0"."pyruleset",? ,"PC0"."pyrulesetversion") AS "pyTextValue(1)" , "PC0"."pxupdatedatetime" AS "pxUpdateDateTime" , "PC0"."pxupdateopname" AS "pxUpdateOpName" , "PC0"."pzinskey" AS "pzInsKey" FROM PegaRulesSchema.pr4_rule "PC0" INNER JOIN app_rulesets_pc0 "PC0AR" ON ((( ("PC0".pzRuleSetVersionMajor IS NULL OR "PC0".pzRuleSetVersionMajor = -1) AND ("PC0".pyRuleSet = "PC0AR"."pzRuleSetName")) OR (("PC0".pzRuleSetVersionMajor IS NOT NULL AND "PC0".pzRuleSetVersionMajor != -1) AND ("PC0".pyRuleSet = "PC0AR"."pzRuleSetName") AND ("PC0".pzRuleSetVersionMajor = "PC0AR"."pzRuleSetVersionMajor") AND (("PC0AR"."pzRuleSetVersionMinor" != -1 AND "PC0AR"."pzRuleSetVersionPatch" != -1 AND (("PC0".pzRuleSetVersionMinor < "PC0AR"."pzRuleSetVersionMinor") OR ("PC0".pzRuleSetVersionMinor = "PC0AR"."pzRuleSetVersionMinor" AND "PC0".pzRuleSetVersionPatch <= "PC0AR"."pzRuleSetVersionPatch"))) OR ("PC0AR"."pzRuleSetVersionMinor" != -1 AND "PC0AR"."pzRuleSetVersionPatch" = -1 AND "PC0".pzRuleSetVersionMinor <= "PC0AR"."pzRuleSetVersionMinor") OR ("PC0AR"."pzRuleSetVersionMinor" = -1)))) ) WHERE ( ( "PC0"."pymethodstatus" <> ? OR "PC0"."pymethodstatus" IS NULL ) AND ( "PC0"."pymethodstatus" <> ? OR "PC0"."pyruleset" NOT LIKE ? OR "PC0"."pymethodstatus" IS NULL ) ) AND "PC0"."pxobjclass" = ? ORDER BY 4 DESC