Database Query Useful in Pega

This Post is about the Database query useful in pega and how to use them.
Everytime we need to deploy code to higher environment , we need to do certain validations to make sure all the rules are deployed and no retrofits are needed.this post is going to help me with the database queries in single page.

Click the button to copy the Query

Function	Run query to find schema
Query
Notes	Returns the schema for the rules table.

Function	Run query to find Count of Ruleset and RulesetCount
Query
Notes	Returns ruleset , ruleset version and count of rules in the ruleset .

Function	To get rules which needs Retrofit
Query
Notes	Return each rule name and the next higher ruleset version where the same rule exists

Please comment , if you need any function to be included here