Page Comparison

//Query to find out which Jira issues are linked to feedback. Here RESOURCE_ID is a Jira issue key.
SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB" WHERE "RESOURCE_TYPE"='ISSUE';

//Query to find out which Jira issues are linked to the feedback requests. Here RESOURCE_ID is a Jira issue key.
SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB_REQUESTS" WHERE "RESOURCE_TYPE"='ISSUE';

//Query to find out which Jira issues are linked to the issue as a key result. Here TITLE is a Jira issue key & ISSUE_ID //is a Jira issue id.
SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=2;

`//Query to find out which JQL is linked to JQL as a key result. Here ISSUE_DETAILS is a JQL.
SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=3;

//Query to find out which Jira issues are linked to issue as a key result action. Here TITLE is a Jira issue key & //ISSUE_ID is a Jira issue id.
SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=0;

//Query to find out which JQL is linked to JQL as a key result action. Here ISSUE_DETAILS is a JQL.
SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=1;

//Query to find out which Jira fields are linked to auto update metric key result configuration. Here FIELD is a Jira //field name.
SELECT DISTINCT "FIELD" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF" WHERE "AGGR_FUNCTION" IN (2,3);

//Query to find out which JQL is linked to auto-update metric key result configuration. Here JQL is a JQL.
SELECT DISTINCT "JQL" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF";

//Query to find out which Jira projects are associated with the project restrictions issue panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='issue_panel_enabled_exceptions';

//Query to find out which Jira projects are associated with the project restrictions feedback panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='cf_enabled_exceptions';

//Query to find out which Jira projects are associated with project restrictions OKR panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='okr_enabled_exceptions';

//Query to find out which Jira groups are associated with Jira group-based access setting.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='GROUP_ACCESS_EXCEPTIONS';

//Query to find out which Jira groups are associated with UpRaise team.
//Here JIRA_GROUPS are stored in an encrypted format.
SELECT DISTINCT "JIRA_GROUPS" FROM "AO_EB0AB3_UP_TEAMS";

//Query to find out Users using Upraise
select "ID","KEY","DISPLAY_NAME" from "AO_EB0AB3_UP_USERS" where "STATUS" !=2