Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Arun Sudarsanam (ArunS850)
Accenture

Accenture
AU
ArunS850 Member since 2019 7 posts
Accenture
Posted: May 13, 2019
Last activity: May 13, 2019
Posted: 13 May 2019 0:47 EDT
Last activity: 13 May 2019 9:20 EDT
Closed

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***

To see attachments, please log in.
Pega Platform
System Administration

Posted: 5 years ago
Posted: 13 May 2019 4:52 EDT
Kranthi Kumar Gunda (gundk)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

Hi,

Please check the blow query. This is the query running to pull the data.

Show More

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


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice