- Created by Cristina Balcázar, last modified on Jul 07, 2023
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 10 Next »
All administrative functions of Herzum Approval require you to be a user with the Jira Cloud System Administrator's global permission.
Overview
At the moment, Herzum Approval Migration Tool is only available for customers with Jira Server / Data Center Jira configured with PostgreSQL and Oracle
The following commands must be run within your database management application. Inside the database, where the information of your Jira instance is located
Backup File
In order to generate your own backup file, please complete the following steps.
Remember: the backup file must be an XML file.
Execute the following queries:
Please click on the following box to display the queries you need to run for PostgresSQL
Queries for PostgresSQL
/*Replace <table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> tag with <CWD_USER> and </table> with </CWD_USER>*/
SELECT query_to_xml(
'SELECT id, user_name, email_address
FROM public.cwd_user;', true, false, '')
/*Replace <table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> tag with <ISSUETYPE> and </table> tag with </ISSUETYPE>*/
SELECT query_to_xml(
'SELECT id, pname
FROM public.issuetype;', true, false, '')
/*Replace <table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> tag with <PROJECT_KEY> and </table> tag with </PROJECT_KEY>*/
SELECT query_to_xml(
'SELECT project_id, project_key
FROM public.project_key;', true, false, '')
/*Replace <table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> tag with <JIRAISSUE> and </table> tag with </JIRAISSUE>*/
SELECT query_to_xml(
'SELECT id, issuenum, project
FROM public.jiraissue;', true, false, '')
/*Replace <table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> tag with <ISSUESTATUS> and </table> tag with </ISSUESTATUS>*/
SELECT query_to_xml(
'SELECT id, pname
FROM public.issuestatus;', true, false, '')
/*Place each result of this query between <CUSTOMFIELD></CUSTOMFIELD> tags*/
SELECT CONCAT(
'<row>',
'<id>', id, '</id>',
'<cfname>', "cfname", '</cfname>',
'</row>') data_xml
FROM public.customfield WHERE customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:userpicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:multigrouppicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:multiuserpicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:grouppicker';
/*Place each result of this query between <WORKFLOWS></WORKFLOWS> tags*/
SELECT CONCAT('<action ',removeText.result,'</action>')
FROM (SELECT SUBSTRING(actionFilter."action" FROM 0 FOR (POSITION('>' in actionFilter."action")+1)) AS result
FROM
(SELECT unnest(string_to_array(descriptor, ' <action ')) AS action
from jiraworkflows) as actionFilter) AS removeText WHERE POSITION('name' in removeText.result)>0
/*Place each result of this query between <AO_D195E9_APPROVAL></AO_D195E9_APPROVAL> tags*/
SELECT CONCAT(
'<row>',
'<ASSIGNEE_ENABLED>', "ASSIGNEE_ENABLED", '</ASSIGNEE_ENABLED>',
'<CONDITIONAL_RULE_ID>', "CONDITIONAL_RULE_ID", '</CONDITIONAL_RULE_ID>',
'<CONFIG_ID>', "CONFIG_ID", '</CONFIG_ID>',
'<DESCRIPTION>', "DESCRIPTION", '</DESCRIPTION>',
'<GROUPS>', "GROUPS", '</GROUPS>',
'<GROUP_PICKER>', "GROUP_PICKER", '</GROUP_PICKER>',
'<ID>', "ID", '</ID>',
'<NAME>', "NAME", '</NAME>',
'<NOT_ASSIGNEE>', "NOT_ASSIGNEE", '</NOT_ASSIGNEE>',
'<NOT_GROUPS>', "NOT_GROUPS", '</NOT_GROUPS>',
'<NOT_GROUP_PICKER>', "NOT_GROUP_PICKER", '</NOT_GROUP_PICKER>',
'<NOT_LEAD>', "NOT_LEAD", '</NOT_LEAD>',
'<NOT_REPORTER>', "NOT_REPORTER", '</NOT_REPORTER>',
'<NOT_ROLES>', "NOT_ROLES", '</NOT_ROLES>',
'<NOT_USERS>', "NOT_USERS", '</NOT_USERS>',
'<NOT_USER_PICKER>', "NOT_USER_PICKER", '</NOT_USER_PICKER>',
'<NOT_USER_PICKER_ANY>', "NOT_USER_PICKER_ANY", '</NOT_USER_PICKER_ANY>',
'<OPERATOR>', "OPERATOR", '</OPERATOR>',
'<PROJECT_LEAD_ENABLED>', "PROJECT_LEAD_ENABLED", '</PROJECT_LEAD_ENABLED>',
'<REPORTER_ENABLED>', "REPORTER_ENABLED", '</REPORTER_ENABLED>',
'<ROLES>', "ROLES", '</ROLES>',
'<SA>', "SA", '</SA>',
'<SHOW_TYPE>', "SHOW_TYPE", '</SHOW_TYPE>',
'<USERS>', REPLACE ("USERS", '&', '&'), '</USERS>',
'<USER_PICKER>', "USER_PICKER", '</USER_PICKER>',
'<USER_PICKER_ALL_EXPR>', "USER_PICKER_ALL_EXPR", '</USER_PICKER_ALL_EXPR>',
'<USER_PICKER_ANY>', "USER_PICKER_ANY", '</USER_PICKER_ANY>',
'<USER_PICKER_ANY_EXPR>', "USER_PICKER_ANY_EXPR", '</USER_PICKER_ANY_EXPR>',
'<EXPR_IN_DETAIL>', "EXPR_IN_DETAIL", '</EXPR_IN_DETAIL>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL";
/*Place each result of this query between <AO_D195E9_CONFIG_PROPERTIES></AO_D195E9_CONFIG_PROPERTIES> tags*/
SELECT CONCAT(
'<row>',
'<DESCRIPTION>', "DESCRIPTION", '</DESCRIPTION>',
'<ID>', "ID", '</ID>',
'<PROPERTY>', "PROPERTY", '</PROPERTY>',
'<VALUE>', "VALUE", '</VALUE>',
'</row>') data_xml
FROM public."AO_D195E9_CONFIG_PROPERTIES";
/*Place each result of this query between <AO_D195E9_CONFIG></AO_D195E9_CONFIG> tags*/
SELECT CONCAT(
CONCAT(
'<row>',
'<ABSTAIN_ACTION_ENABLED>', "ABSTAIN_ACTION_ENABLED", '</ABSTAIN_ACTION_ENABLED>',
'<APPROVAL_TAG>', "APPROVAL_TAG", '</APPROVAL_TAG>',
'<APP_COND_WF_UPDATABLE>', "APP_COND_WF_UPDATABLE", '</APP_COND_WF_UPDATABLE>',
'<APP_PANEL_FILTER>', "APP_PANEL_FILTER", '</APP_PANEL_FILTER>',
'<AUTO_GRANT_PERM>', "AUTO_GRANT_PERM", '</AUTO_GRANT_PERM>',
'<AWT_CMRA>', "AWT_CMRA", '</AWT_CMRA>',
'<CHECK_INFO>', "CHECK_INFO", '</CHECK_INFO>',
'<CUSTOM_COMMENT>', "CUSTOM_COMMENT", '</CUSTOM_COMMENT>',
'<CUSTOM_DEFINE_APPROVAL>', "CUSTOM_DEFINE_APPROVAL", '</CUSTOM_DEFINE_APPROVAL>',
'<CUSTOM_REQUESTER_APPROVAL>', "CUSTOM_REQUESTER_APPROVAL", '</CUSTOM_REQUESTER_APPROVAL>',
'<DELEGATION_ENABLED>', "DELEGATION_ENABLED", '</DELEGATION_ENABLED>',
'<ENABLED_NAC>', "ENABLED_NAC", '</ENABLED_NAC>',
'<EXPANED_APP_PANEL>', "EXPANED_APP_PANEL", '</EXPANED_APP_PANEL>',
'<FROM_EMAIL>', "FROM_EMAIL", '</FROM_EMAIL>',
'<HIDE_HACTION_ABSTAINED>', "HIDE_HACTION_ABSTAINED", '</HIDE_HACTION_ABSTAINED>',
'<HIDE_HACTION_APPROVED>', "HIDE_HACTION_APPROVED", '</HIDE_HACTION_APPROVED>',
'<HIDE_HACTION_APP_NOTIFY>', "HIDE_HACTION_APP_NOTIFY", '</HIDE_HACTION_APP_NOTIFY>',
'<HIDE_HACTION_AUNOTIFY>', "HIDE_HACTION_AUNOTIFY", '</HIDE_HACTION_AUNOTIFY>',
'<HIDE_HACTION_AUTRANS>', "HIDE_HACTION_AUTRANS", '</HIDE_HACTION_AUTRANS>',
'<HIDE_HACTION_COMMENT>', "HIDE_HACTION_COMMENT", '</HIDE_HACTION_COMMENT>',
'<HIDE_HACTION_NPENDING>', "HIDE_HACTION_NPENDING", '</HIDE_HACTION_NPENDING>',
'<HIDE_HACTION_PENDING>', "HIDE_HACTION_PENDING", '</HIDE_HACTION_PENDING>',
'<HIDE_HACTION_REJECTED>', "HIDE_HACTION_REJECTED", '</HIDE_HACTION_REJECTED>',
'<HIDE_HACTION_REPLY_NOTIFY>', "HIDE_HACTION_REPLY_NOTIFY", '</HIDE_HACTION_REPLY_NOTIFY>',
'<HIDE_HACTION_SING_NOTIFY>', "HIDE_HACTION_SING_NOTIFY", '</HIDE_HACTION_SING_NOTIFY>',
'<HIDE_HISTORY_ACTION>', "HIDE_HISTORY_ACTION", '</HIDE_HISTORY_ACTION>',
'<HIDE_HISTORY_APPROVAL>', "HIDE_HISTORY_APPROVAL", '</HIDE_HISTORY_APPROVAL>',
'<HIDE_HISTORY_APPROVER_C>', "HIDE_HISTORY_APPROVER_C", '</HIDE_HISTORY_APPROVER_C>',
'<HIDE_HISTORY_DESTINATION_S>', "HIDE_HISTORY_DESTINATION_S", '</HIDE_HISTORY_DESTINATION_S>',
'<HIDE_HISTORY_SOURCE_S>', "HIDE_HISTORY_SOURCE_S", '</HIDE_HISTORY_SOURCE_S>',
'<HIDE_HISTORY_TRANS>', "HIDE_HISTORY_TRANS", '</HIDE_HISTORY_TRANS>',
'<HIDE_MENU>', "HIDE_MENU", '</HIDE_MENU>'), CONCAT(
'<HIDE_PACOMMENT>', "HIDE_PACOMMENT", '</HIDE_PACOMMENT>',
'<HIDE_PACTION>', "HIDE_PACTION", '</HIDE_PACTION>',
'<HIDE_PAPP_NAME>', "HIDE_PAPP_NAME", '</HIDE_PAPP_NAME>',
'<HIDE_PDETAIL>', "HIDE_PDETAIL", '</HIDE_PDETAIL>',
'<HIDE_PREQUEST_NOTIF>', "HIDE_PREQUEST_NOTIF", '</HIDE_PREQUEST_NOTIF>',
'<HISTORY_COLUMN_TITLES>', "HISTORY_COLUMN_TITLES", '</HISTORY_COLUMN_TITLES>',
'<HISTORY_EXPAND_ROWS>', "HISTORY_EXPAND_ROWS", '</HISTORY_EXPAND_ROWS>',
'<HISTORY_FILTER>', "HISTORY_FILTER", '</HISTORY_FILTER>',
'<HISTORY_GROUP_BY>', "HISTORY_GROUP_BY", '</HISTORY_GROUP_BY>',
'<ID>', "ID", '</ID>',
'<LABEL_ABSTAIN_BUTTON>', "LABEL_ABSTAIN_BUTTON", '</LABEL_ABSTAIN_BUTTON>',
'<LABEL_ACTION_APPROVAL>', "LABEL_ACTION_APPROVAL", '</LABEL_ACTION_APPROVAL>',
'<LABEL_APPROVAL_BUTTON>', "LABEL_APPROVAL_BUTTON", '</LABEL_APPROVAL_BUTTON>',
'<LABEL_APPROVAL_NAME>', "LABEL_APPROVAL_NAME", '</LABEL_APPROVAL_NAME>',
'<LABEL_APP_COMMENT>', "LABEL_APP_COMMENT", '</LABEL_APP_COMMENT>',
'<LABEL_DETAIL>', "LABEL_DETAIL", '</LABEL_DETAIL>',
'<LABEL_HISTORY_ACTION>', "LABEL_HISTORY_ACTION", '</LABEL_HISTORY_ACTION>',
'<LABEL_HISTORY_APPROVAL>', "LABEL_HISTORY_APPROVAL", '</LABEL_HISTORY_APPROVAL>',
'<LABEL_HISTORY_APPROVER_C>', "LABEL_HISTORY_APPROVER_C", '</LABEL_HISTORY_APPROVER_C>',
'<LABEL_HISTORY_DESTINATION_S>', "LABEL_HISTORY_DESTINATION_S", '</LABEL_HISTORY_DESTINATION_S>',
'<LABEL_HISTORY_SOURCE_S>', "LABEL_HISTORY_SOURCE_S", '</LABEL_HISTORY_SOURCE_S>',
'<LABEL_HISTORY_TRANS>', "LABEL_HISTORY_TRANS", '</LABEL_HISTORY_TRANS>',
'<LABEL_REJECT_BUTTON>', "LABEL_REJECT_BUTTON", '</LABEL_REJECT_BUTTON>',
'<LABEL_REQUEST_APPROVAL>', "LABEL_REQUEST_APPROVAL", '</LABEL_REQUEST_APPROVAL>',
'<LABEL_REQUEST_APPROVALS>', "LABEL_REQUEST_APPROVALS", '</LABEL_REQUEST_APPROVALS>',
'<LABEL_REQUEST_NOTIFY>', "LABEL_REQUEST_NOTIFY", '</LABEL_REQUEST_NOTIFY>',
'<LABEL_RESET_BUTTON>', "LABEL_RESET_BUTTON", '</LABEL_RESET_BUTTON>',
'<LARGE_BUTTONS>', "LARGE_BUTTONS", '</LARGE_BUTTONS>',
'<LOCK_ACTION_ENABLED>', "LOCK_ACTION_ENABLED", '</LOCK_ACTION_ENABLED>',
'<NOTIFICATION_RECIPIENT_CUSTOM>', "NOTIFICATION_RECIPIENT_CUSTOM", '</NOTIFICATION_RECIPIENT_CUSTOM>',
'<RESPONSIVE_AWT>', "RESPONSIVE_AWT", '</RESPONSIVE_AWT>',
'<TAB_COMM_DISABLED>', "TAB_COMM_DISABLED", '</TAB_COMM_DISABLED>'), CONCAT(
'<TAB_HISTORY_ENABLED>', "TAB_HISTORY_ENABLED", '</TAB_HISTORY_ENABLED>',
'<USER_APPROVER_BULK>', "USER_APPROVER_BULK", '</USER_APPROVER_BULK>',
'<USER_AWT>', "USER_AWT", '</USER_AWT>',
'<USER_COND_RULE>', "USER_COND_RULE", '</USER_COND_RULE>',
'<USER_LARGE_BUTTONS>', "USER_LARGE_BUTTONS", '</USER_LARGE_BUTTONS>',
'<USER_NOTIFY_NAC>', "USER_NOTIFY_NAC", '</USER_NOTIFY_NAC>',
'<VIEW_WORKFLOW>', "VIEW_WORKFLOW", '</VIEW_WORKFLOW>',
'</row>')) data_xml
FROM public."AO_D195E9_CONFIG";
/*Place each result of this query between <AO_D195E9_CONDITIONAL_RULE></AO_D195E9_CONDITIONAL_RULE> tags*/
SELECT CONCAT(
'<row>',
'<CONDITIONAL_NAME>', "CONDITIONAL_NAME", '</CONDITIONAL_NAME>',
'<CONDITIONAL_RULE>', "CONDITIONAL_RULE", '</CONDITIONAL_RULE>',
'<ID>', "ID", '</ID>',
'<USER_EVALUATOR>', "USER_EVALUATOR", '</USER_EVALUATOR>',
'</row>') data_xml
FROM public."AO_D195E9_CONDITIONAL_RULE";
/*Place each result of this query between <AO_D195E9_CUSTOM_MAIL_TEMPLATE></AO_D195E9_CUSTOM_MAIL_TEMPLATE> tags*/
SELECT CONCAT(CONCAT(
'<row>',
'<BODY_SECTION>', REPLACE ("BODY_SECTION", '&', '&'), '</BODY_SECTION>',
'<BUTTON_LINKS_TYPE>', "BUTTON_LINKS_TYPE", '</BUTTON_LINKS_TYPE>',
'<BUTTON_TEXTS>', "BUTTON_TEXTS", '</BUTTON_TEXTS>',
'<COMMENT_ENABLED>', "COMMENT_ENABLED", '</COMMENT_ENABLED>',
'<COMMENT_ENABLED_IF_REQUIRED>', "COMMENT_ENABLED_IF_REQUIRED", '</COMMENT_ENABLED_IF_REQUIRED>',
'<CONDITIONAL_RULE_ID>', "CONDITIONAL_RULE_ID", '</CONDITIONAL_RULE_ID>',
'<CONDITION_ENABLING_TEMPLATE_ID>', "CONDITION_ENABLING_TEMPLATE_ID", '</CONDITION_ENABLING_TEMPLATE_ID>',
'<CUSTOM_APPROVAL_INSTRUCT>', REPLACE ("CUSTOM_APPROVAL_INSTRUCT", '&', '&'), '</CUSTOM_APPROVAL_INSTRUCT>',
'<CUSTOM_TEMPLATE_NAME>', "CUSTOM_TEMPLATE_NAME", '</CUSTOM_TEMPLATE_NAME>',
'<FOOTER>', "FOOTER", '</FOOTER>',
'<HEADER>', "HEADER", '</HEADER>',
'<HIDE_APPROVAL_BUTTON>', "HIDE_APPROVAL_BUTTON", '</HIDE_APPROVAL_BUTTON>',
'<HIDE_APPROVAL_COMMENT>', "HIDE_APPROVAL_COMMENT", '</HIDE_APPROVAL_COMMENT>',
'<HIDE_APPROVAL_INSTRUCT>', "HIDE_APPROVAL_INSTRUCT", '</HIDE_APPROVAL_INSTRUCT>',
'<HIDE_ASSIGNEE>', "HIDE_ASSIGNEE", '</HIDE_ASSIGNEE>',
'<HIDE_COMMENT>', "HIDE_COMMENT", '</HIDE_COMMENT>'), CONCAT(
'<HIDE_CREATED>', "HIDE_CREATED", '</HIDE_CREATED>',
'<HIDE_DESCRIPTION>', "HIDE_DESCRIPTION", '</HIDE_DESCRIPTION>',
'<HIDE_ISSUE_TYPE>', "HIDE_ISSUE_TYPE", '</HIDE_ISSUE_TYPE>',
'<HIDE_LOGO>', "HIDE_LOGO", '</HIDE_LOGO>',
'<HIDE_PRIORITY>', "HIDE_PRIORITY", '</HIDE_PRIORITY>',
'<HIDE_PROJECT>', "HIDE_PROJECT", '</HIDE_PROJECT>',
'<HIDE_REPORTER>', "HIDE_REPORTER", '</HIDE_REPORTER>',
'<HIDE_WORKFLOW_TRANS>', "HIDE_WORKFLOW_TRANS", '</HIDE_WORKFLOW_TRANS>',
'<ID>', "ID", '</ID>',
'<IS_BOTTOM_BODY_SECTION>', "IS_BOTTOM_BODY_SECTION", '</IS_BOTTOM_BODY_SECTION>',
'<IS_BOTTOM_BUTTON>', "IS_BOTTOM_BUTTON", '</IS_BOTTOM_BUTTON>',
'<IS_EMAIL_TEMPLATE_DEFAULT>', "IS_EMAIL_TEMPLATE_DEFAULT", '</IS_EMAIL_TEMPLATE_DEFAULT>',
'<IS_EMAIL_TEMPLATE_REPLY>', "IS_EMAIL_TEMPLATE_REPLY", '</IS_EMAIL_TEMPLATE_REPLY>',
'<PROJECT_ID>', "PROJECT_ID", '</PROJECT_ID>',
'<SHOW_LINKED_ISSUES>', "SHOW_LINKED_ISSUES", '</SHOW_LINKED_ISSUES>',
'<SHOW_SUBTASKS>', "SHOW_SUBTASKS", '</SHOW_SUBTASKS>',
'<SUBJECT>', REPLACE ("SUBJECT", '&', '&'), '</SUBJECT>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>')) data_xml
FROM public."AO_D195E9_CUSTOM_MAIL_TEMPLATE";
/*Place each result of this query between <AO_D195E9_APPROVAL_NOT_NOTIFY></AO_D195E9_APPROVAL_NOT_NOTIFY> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<RECIPIENT>', "RECIPIENT", '</RECIPIENT>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_NOT_NOTIFY";
/*Place each result of this query between <AO_D195E9_NTF_SCHEME></AO_D195E9_NTF_SCHEME> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<DESCRIPTION>', "DESCRIPTION", '</DESCRIPTION>',
'<NAME>', "NAME", '</NAME>',
'</row>') data_xml
FROM public."AO_D195E9_NTF_SCHEME";
/*Place each result of this query between <AO_D195E9_NTF_SCHEME_DETAIL></AO_D195E9_NTF_SCHEME_DETAIL> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<CUSTOM_MAIL_TEMPLATE_ID>', "CUSTOM_MAIL_TEMPLATE_ID", '</CUSTOM_MAIL_TEMPLATE_ID>',
'<EVENT_TYPE_ID>', "EVENT_TYPE_ID", '</EVENT_TYPE_ID>',
'<NOTIFY_EXPRESSION>', "NOTIFY_EXPRESSION", '</NOTIFY_EXPRESSION>',
'<NTF_SCHEME_ID>', "NTF_SCHEME_ID", '</NTF_SCHEME_ID>',
'</row>') data_xml
FROM public."AO_D195E9_NTF_SCHEME_DETAIL";
/*Place each result of this query between <AO_D195E9_APPROVAL_RECIPIENTS></AO_D195E9_APPROVAL_RECIPIENTS> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<EVENTS>', "EVENTS", '</EVENTS>',
'<RECIPIENT>', "RECIPIENT", '</RECIPIENT>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_RECIPIENTS";
/*Place each result of this query between <AO_D195E9_APPROVAL_PROJECTS></AO_D195E9_APPROVAL_PROJECTS> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<PROJECT_ID>', "PROJECT_ID", '</PROJECT_ID>',
'<REQUESTER_TYPE>', "REQUESTER_TYPE", '</REQUESTER_TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_PROJECTS";
/*Place each result of this query between <AO_D195E9_APPROVAL_REQUESTERS></AO_D195E9_APPROVAL_REQUESTERS> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<ISSUE_TYPE_ID>', "ISSUE_TYPE_ID", '</ISSUE_TYPE_ID>',
'<PROJECT_ID>', "PROJECT_ID", '</PROJECT_ID>',
'<REQUESTER>', "REQUESTER", '</REQUESTER>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_REQUESTERS";
/*Place each result of this query between <AO_D195E9_APPROVAL_DEFINERS></AO_D195E9_APPROVAL_DEFINERS> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<ISSUE_TYPE_ID>', "ISSUE_TYPE_ID", '</ISSUE_TYPE_ID>',
'<PROJECT_ID>', "PROJECT_ID", '</PROJECT_ID>',
'<DEFINER>', "DEFINER", '</DEFINER>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_DEFINERS";
/*Place each result of this query between <AO_D195E9_APPROVAL_MENU_PERM></AO_D195E9_APPROVAL_MENU_PERM> tags*/
SELECT CONCAT(
'<row>',
'<ID>', "ID", '</ID>',
'<ITEM>', "ITEM", '</ITEM>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_MENU_PERM";
/*Place each result of this query between <AO_D195E9_APPROVAL_MAPPING></AO_D195E9_APPROVAL_MAPPING> tags*/
SELECT CONCAT(
CONCAT(
'<row>',
'<ABSTAIN_ACTION_STATUS>', "ABSTAIN_ACTION_STATUS", '</ABSTAIN_ACTION_STATUS>',
'<AREA_COND_RULE_ID>', "AREA_COND_RULE_ID", '</AREA_COND_RULE_ID>',
'<AREA_DATE_PICKER>', "AREA_DATE_PICKER", '</AREA_DATE_PICKER>',
'<AREA_ELAPSED_TIME>', "AREA_ELAPSED_TIME", '</AREA_ELAPSED_TIME>',
'<AREA_SERVICE_NAME>', "AREA_SERVICE_NAME", '</AREA_SERVICE_NAME>',
'<ARN>', "ARN", '</ARN>',
'<AWT>', "AWT", '</AWT>',
'<AWTAD>', "AWTAD", '</AWTAD>',
'<AWTR>', "AWTR", '</AWTR>',
'<CONDITIONAL_RULE_ID>', "CONDITIONAL_RULE_ID", '</CONDITIONAL_RULE_ID>',
'<CONFIG_ID>', "CONFIG_ID", '</CONFIG_ID>'),
CONCAT(
'<DA_DECISION>', "DA_DECISION", '</DA_DECISION>',
'<DA_ELAPSED_TIME>', "DA_ELAPSED_TIME", '</DA_ELAPSED_TIME>',
'<DA_SERVICE_NAME>', "DA_SERVICE_NAME", '</DA_SERVICE_NAME>',
'<DA_USER_KEY>', "DA_USER_KEY", '</DA_USER_KEY>',
'<DESTINATION_STATUS_ID>', "DESTINATION_STATUS_ID", '</DESTINATION_STATUS_ID>',
'<ID>', "ID", '</ID>',
'<ISSUE_TYPE_ID>', "ISSUE_TYPE_ID", '</ISSUE_TYPE_ID>',
'<IS_DELETE>', "IS_DELETE", '</IS_DELETE>',
'<IS_DRAFT>', "IS_DRAFT", '</IS_DRAFT>',
'<IS_LOCKED>', "IS_LOCKED", '</IS_LOCKED>',
'<IS_NOT_SINGLE>', "IS_NOT_SINGLE", '</IS_NOT_SINGLE>',
'<LOCKED_DATE>', "LOCKED_DATE", '</LOCKED_DATE>',
'<LOCKED_INFO>', "LOCKED_INFO", '</LOCKED_INFO>'
), CONCAT(
'<MAIL_TEMPLATE_REPLY_ID>', "MAIL_TEMPLATE_REPLY_ID", '</MAIL_TEMPLATE_REPLY_ID>',
'<MAIL_TEMPLATE_REQUEST_ID>', "MAIL_TEMPLATE_REQUEST_ID", '</MAIL_TEMPLATE_REQUEST_ID>',
'<MRA>', "MRA", '</MRA>',
'<MRR>', "MRR", '</MRR>',
'<NAC>', "NAC", '</NAC>',
'<ORDER_MAP>', "ORDER_MAP", '</ORDER_MAP>',
'<PROJECT_ID>', "PROJECT_ID", '</PROJECT_ID>',
'<RAC>', "RAC", '</RAC>',
'<RACA>', "RACA", '</RACA>',
'<REPLY_NOTIFICATION_SCHEMA_ID>', "REPLY_NOTIFICATION_SCHEMA_ID", '</REPLY_NOTIFICATION_SCHEMA_ID>',
'<SA>', "SA", '</SA>',
'<SAAD>', "SAAD", '</SAAD>',
'<SHOW_APPROVAL_BUTTONS_JSD>', "SHOW_APPROVAL_BUTTONS_JSD", '</SHOW_APPROVAL_BUTTONS_JSD>',
'<SHOW_APPROVAL_STATUS_JSD>', "SHOW_APPROVAL_STATUS_JSD", '</SHOW_APPROVAL_STATUS_JSD>',
'<SOURCE_STATUS_ID>', "SOURCE_STATUS_ID", '</SOURCE_STATUS_ID>',
'<SUPER_APPROVERS_EXPR>', "SUPER_APPROVERS_EXPR", '</SUPER_APPROVERS_EXPR>',
'<TRANSITION_ID>', "TRANSITION_ID", '</TRANSITION_ID>',
'<TRANSITION_ON_REJECTING>', "TRANSITION_ON_REJECTING", '</TRANSITION_ON_REJECTING>',
'</row>')
) data_xml
FROM public."AO_D195E9_APPROVAL_MAPPING";
/*Place each result of this query between <AO_D195E9_APPROVAL_MAPPING_REL></AO_D195E9_APPROVAL_MAPPING_REL> tags*/
SELECT CONCAT(
'<row>',
'<APPROVAL_ID>', "APPROVAL_ID", '</APPROVAL_ID>',
'<APPROVAL_MAPPING_ID>', "APPROVAL_MAPPING_ID", '</APPROVAL_MAPPING_ID>',
'<ID>', "ID", '</ID>',
'<IS_OPTIONAL_APPROVAL>', "IS_OPTIONAL_APPROVAL", '</IS_OPTIONAL_APPROVAL>',
'<SORT_SA>', "SORT_SA", '</SORT_SA>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_MAPPING_REL";
/*Place each result of this query between <AO_D195E9_ISSUE_APPROVAL></AO_D195E9_ISSUE_APPROVAL> tags*/ SELECT CONCAT( CONCAT( '<row>', '<ABSTAIN_ACTION_STATUS>', "ABSTAIN_ACTION_STATUS", '</ABSTAIN_ACTION_STATUS>', '<APPROVAL_ID>', "APPROVAL_ID", '</APPROVAL_ID>', '<APPROVAL_STATUS>', "APPROVAL_STATUS", '</APPROVAL_STATUS>', '<APPROVER_USER>', "APPROVER_USER", '</APPROVER_USER>', '<AREA_COND_RULE_ID>', "AREA_COND_RULE_ID", '</AREA_COND_RULE_ID>', '<AREA_DATE_PICKER>', "AREA_DATE_PICKER", '</AREA_DATE_PICKER>', '<AREA_ELAPSED_TIME>', "AREA_ELAPSED_TIME", '</AREA_ELAPSED_TIME>', '<AREA_SERVICE_NAME>', "AREA_SERVICE_NAME", '</AREA_SERVICE_NAME>', '<ARN>', "ARN", '</ARN>', '<AWT>', "AWT", '</AWT>', '<AWTAD>', "AWTAD", '</AWTAD>', '<AWTR>', "AWTR", '</AWTR>', '<COMMENT_NOTIFICATION_DATE>', "COMMENT_NOTIFICATION_DATE", '</COMMENT_NOTIFICATION_DATE>', '<CONDITIONAL_RULE_ID>', "CONDITIONAL_RULE_ID", '</CONDITIONAL_RULE_ID>', '<CUSTOM_APPROVER>', "CUSTOM_APPROVER", '</CUSTOM_APPROVER>'), CONCAT( '<DATE>', "DATE", '</DATE>', '<DA_DECISION>', "DA_DECISION", '</DA_DECISION>', '<DA_ELAPSED_TIME>', "DA_ELAPSED_TIME", '</DA_ELAPSED_TIME>', '<DA_SERVICE_NAME>', "DA_SERVICE_NAME", '</DA_SERVICE_NAME>', '<DA_USER_KEY>', "DA_USER_KEY", '</DA_USER_KEY>', '<DEFINE_CUSTOM_APPROVAL>', "DEFINE_CUSTOM_APPROVAL", '</DEFINE_CUSTOM_APPROVAL>', '<DELEGATOR_KEY>', "DELEGATOR_KEY", '</DELEGATOR_KEY>', '<ERROR_TRANSIT>', "ERROR_TRANSIT", '</ERROR_TRANSIT>', '<ERROR_TRANSIT_TYPE>', "ERROR_TRANSIT_TYPE", '</ERROR_TRANSIT_TYPE>', '<HAS_CONFIG_FOR_SINGLE_ISSUE>', "HAS_CONFIG_FOR_SINGLE_ISSUE", '</HAS_CONFIG_FOR_SINGLE_ISSUE>', '<ID>', "ID", '</ID>', '<ISSUE_ID>', "ISSUE_ID", '</ISSUE_ID>', '<ISSUE_STATUS>', "ISSUE_STATUS", '</ISSUE_STATUS>', '<IS_OPTIONAL_APPROVAL>', "IS_OPTIONAL_APPROVAL", '</IS_OPTIONAL_APPROVAL>', '<MAIL_TEMPLATE_REPLY_ID>', "MAIL_TEMPLATE_REPLY_ID", '</MAIL_TEMPLATE_REPLY_ID>' ), CONCAT( '<MAIL_TEMPLATE_REQUEST_ID>', "MAIL_TEMPLATE_REQUEST_ID", '</MAIL_TEMPLATE_REQUEST_ID>', '<MRA>', "MRA", '</MRA>', '<MRR>', "MRR", '</MRR>', '<NAC>', "NAC", '</NAC>', '<NOTIFICATION_DATE>', "NOTIFICATION_DATE", '</NOTIFICATION_DATE>', '<RAC>', "RAC", '</RAC>', '<RACA>', "RACA", '</RACA>', '<REPLY_NOTIFICATION_SCHEMA_ID>', "REPLY_NOTIFICATION_SCHEMA_ID", '</REPLY_NOTIFICATION_SCHEMA_ID>', '<SA>', "SA", '</SA>', '<SAAD>', "SAAD", '</SAAD>', '<SHOW_APPROVAL_BUTTONS_JSD>', "SHOW_APPROVAL_BUTTONS_JSD", '</SHOW_APPROVAL_BUTTONS_JSD>', '<SHOW_APPROVAL_STATUS_JSD>', "SHOW_APPROVAL_STATUS_JSD", '</SHOW_APPROVAL_STATUS_JSD>', '<SORT_SA>', "SORT_SA", '</SORT_SA>', '<SOURCE_STATUS_ID>', "SOURCE_STATUS_ID", '</SOURCE_STATUS_ID>', '<SUBMITTED_DATE>', "SUBMITTED_DATE", '</SUBMITTED_DATE>', '<SUPER_APPROVERS_EXPR>', "SUPER_APPROVERS_EXPR", '</SUPER_APPROVERS_EXPR>', '<TRANSITION_ID>', "TRANSITION_ID", '</TRANSITION_ID>', '<TRANSITION_NAME>', "TRANSITION_NAME", '</TRANSITION_NAME>', '<TRANSITION_ON_REJECTING>', "TRANSITION_ON_REJECTING", '</TRANSITION_ON_REJECTING>', '<TYPE>', "TYPE", '</TYPE>', '</row>') ) data_xml FROM public."AO_D195E9_ISSUE_APPROVAL" WHERE "TYPE" = 'SINGLE_ISSUE';
/*Place each result of this query between <AO_D195E9_APPROVAL_MRA></AO_D195E9_APPROVAL_MRA> tags*/
SELECT CONCAT(
'<row>',
'<APPROVAL_MAPPING_ID>', "APPROVAL_MAPPING_ID", '</APPROVAL_MAPPING_ID>',
'<CONDITIONAL_RULE_ID>', "CONDITIONAL_RULE_ID", '</CONDITIONAL_RULE_ID>',
'<ID>', "ID", '</ID>',
'<ISSUE_ID>', "ISSUE_ID", '</ISSUE_ID>',
'<MRA>', "MRA", '</MRA>',
'<ORDER>', "ORDER", '</ORDER>',
'<SOURCE_STATUS_ID>', "SOURCE_STATUS_ID", '</SOURCE_STATUS_ID>',
'<TRANSITION_ID>', "TRANSITION_ID", '</TRANSITION_ID>',
'<TYPE>', "TYPE", '</TYPE>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_MRA";
/*Place each result of this query between <AO_D195E9_APPROVAL_HISTORY></AO_D195E9_APPROVAL_HISTORY> tags*/
SELECT CONCAT(
'<row>',
'<ACTION>', "ACTION", '</ACTION>',
'<APPROVAL_COMMENT>', "APPROVAL_COMMENT", '</APPROVAL_COMMENT>',
'<APPROVAL_DETAIL>', "APPROVAL_DETAIL", '</APPROVAL_DETAIL>',
'<APPROVAL_NAME>', "APPROVAL_NAME", '</APPROVAL_NAME>',
'<COMMENT>', "COMMENT", '</COMMENT>',
'<DATE>', "DATE", '</DATE>',
'<DELEGATOR_KEY>', "DELEGATOR_KEY", '</DELEGATOR_KEY>',
'<DESTINATION_STATUS>', "DESTINATION_STATUS", '</DESTINATION_STATUS>',
'<EXECUTOR>', "EXECUTOR", '</EXECUTOR>',
'<EXECUTOR_KEY>', "EXECUTOR_KEY", '</EXECUTOR_KEY>',
'<ID>', "ID", '</ID>',
'<ISSUE_ID>', "ISSUE_ID", '</ISSUE_ID>',
'<NOTIFICATION_DATE>', "NOTIFICATION_DATE", '</NOTIFICATION_DATE>',
'<SOURCE_STATUS>', "SOURCE_STATUS", '</SOURCE_STATUS>',
'<SUBMITTED_DATE>', "SUBMITTED_DATE", '</SUBMITTED_DATE>',
'<TRANSITION_NAME>', "TRANSITION_NAME", '</TRANSITION_NAME>',
'</row>') data_xml
FROM public."AO_D195E9_APPROVAL_HISTORY";
/*Replace <table> tag with <AO_D195E9_APPROVAL_DELEGATED>*/
SELECT query_to_xml(
'SELECT *
FROM public."AO_D195E9_APPROVAL_DELEGATED";', true , false, '')
/*Replace <table> tag with <AO_D195E9_LANGUAGE_PACK>*/
SELECT query_to_xml(
'SELECT *
FROM public."AO_D195E9_LANGUAGE_PACK" where "LOCALE" is not null;', true , false, '')
/*Replace <table> tag with <AO_D195E9_LANG_PACK_KEY_VAL>*/
SELECT query_to_xml(
'SELECT "ID", "LANGUAGE_PACK_ID", "PROPERTY_KEY", "VALUE"
FROM public."AO_D195E9_LANG_PACK_KEY_VAL" WHERE "LANGUAGE_PACK_ID" IN
(SELECT "ID"
FROM public."AO_D195E9_LANGUAGE_PACK" where "LOCALE" is not null);', true , false, 'AO_D195E9_LANGUAGE_PACK')
Please click on the following box to display the queries you need to run for Oracle
Queries for Oracle
/*Replace <?xml version="1.0"?><ROWSET> tags with <CWD_USER> and end </ROWSET> tag with </CWD_USER>*/ SELECT dbms_xmlgen.getXML( 'SELECT id, user_name, email_address FROM CWD_USER') query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <ISSUETYPE> and end </ROWSET> tag with </ISSUETYPE>*/
SELECT dbms_xmlgen.getXML(
'SELECT id, pname
FROM ISSUETYPE') query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <PROJECT_KEY> and end </ROWSET> tag with </PROJECT_KEY>*/
SELECT dbms_xmlgen.getXML(
'SELECT project_id, project_key
FROM project_key') query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <JIRAISSUE> and end </ROWSET> tag with </JIRAISSUE>*/
SELECT dbms_xmlgen.getXML(
'SELECT id, issuenum, project
FROM jiraissue') query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <ISSUESTATUS> and end </ROWSET> tag with </ISSUESTATUS>*/
SELECT dbms_xmlgen.getXML(
'SELECT id, pname
FROM issuestatus') query_xml from dual
/*Place each result of this query between <CUSTOMFIELD></CUSTOMFIELD> tags*/
SELECT
'<row>' ||
'<id>' || id || '</id>' ||
'<cfname>'|| cfname|| '</cfname>'||
'</row>'
FROM customfield WHERE customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:userpicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:multigrouppicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:multiuserpicker'
OR customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:grouppicker'
/*Place each result of this query between <WORKFLOWS></WORKFLOWS> tags*/
/*Omit null results*/
WITH bounds (value, spos, epos) AS (
SELECT DESCRIPTOR,
1,
INSTR(DESCRIPTOR, ' <action ', 1)
FROM JIRAWORKFLOWS
UNION ALL
SELECT value,
epos + 9,
INSTR(value, ' <action ', epos + 9)
FROM bounds
WHERE epos > 0
)
SELECT CASE epos
WHEN 0
THEN
CASE
WHEN INSTR(SUBSTR(SUBSTR(value, spos),0, INSTR(SUBSTR(value, spos),'>',1)+1),'name',1)>0
THEN '<action ' || SUBSTR(SUBSTR(value, spos),0, INSTR(SUBSTR(value, spos),'>',1)) ||'</action>'
END
ELSE
CASE
WHEN INSTR(SUBSTR(SUBSTR(value, spos, epos - spos),0, INSTR(SUBSTR(value, spos),'>',1)+1),'name',1)>0
THEN '<action ' || SUBSTR(SUBSTR(value, spos, epos - spos),0, INSTR(SUBSTR(value, spos),'>',1)) ||'</action>'
END
END AS action
FROM bounds
/*Place each result of this query between <AO_D195E9_APPROVAL></AO_D195E9_APPROVAL> tags*/
SELECT
'<row>'||
'<ASSIGNEE_ENABLED>'|| "ASSIGNEE_ENABLED"|| '</ASSIGNEE_ENABLED>'||
'<CONDITIONAL_RULE_ID>'|| "CONDITIONAL_RULE_ID"|| '</CONDITIONAL_RULE_ID>'||
'<CONFIG_ID>'|| CONFIG_ID || '</CONFIG_ID>'||
'<DESCRIPTION>'||DESCRIPTION|| '</DESCRIPTION>'||
'<GROUPS>'||GROUPS|| '</GROUPS>'||
'<GROUP_PICKER>'||GROUP_PICKER|| '</GROUP_PICKER>'||
'<ID>'||ID|| '</ID>'||
'<NAME>'||NAME|| '</NAME>'||
'<NOT_ASSIGNEE>'||NOT_ASSIGNEE|| '</NOT_ASSIGNEE>'||
'<NOT_GROUPS>'||NOT_GROUPS|| '</NOT_GROUPS>'||
'<NOT_GROUP_PICKER>'||NOT_GROUP_PICKER|| '</NOT_GROUP_PICKER>'||
'<NOT_LEAD>'||NOT_LEAD|| '</NOT_LEAD>'||
'<NOT_REPORTER>'||NOT_REPORTER|| '</NOT_REPORTER>'||
'<NOT_ROLES>'||NOT_ROLES|| '</NOT_ROLES>'||
'<NOT_USERS>'||NOT_USERS|| '</NOT_USERS>'||
'<NOT_USER_PICKER>'||NOT_USER_PICKER|| '</NOT_USER_PICKER>'||
'<NOT_USER_PICKER_ANY>'||NOT_USER_PICKER_ANY|| '</NOT_USER_PICKER_ANY>'||
'<OPERATOR>'||OPERATOR|| '</OPERATOR>'||
'<PROJECT_LEAD_ENABLED>'||PROJECT_LEAD_ENABLED|| '</PROJECT_LEAD_ENABLED>'||
'<REPORTER_ENABLED>'||REPORTER_ENABLED|| '</REPORTER_ENABLED>'||
'<ROLES>'||ROLES|| '</ROLES>'||
'<SA>'||SA|| '</SA>'||
'<SHOW_TYPE>'||SHOW_TYPE|| '</SHOW_TYPE>'||
'<USERS>'||REPLACE ("USERS", '&', '&')|| '</USERS>'||
'<USER_PICKER>'||USER_PICKER|| '</USER_PICKER>'||
'<USER_PICKER_ALL_EXPR>'||USER_PICKER_ALL_EXPR|| '</USER_PICKER_ALL_EXPR>'||
'<USER_PICKER_ANY>'||USER_PICKER_ANY|| '</USER_PICKER_ANY>'||
'<USER_PICKER_ANY_EXPR>'||USER_PICKER_ANY_EXPR|| '</USER_PICKER_ANY_EXPR>'||
'<EXPR_IN_DETAIL>'||EXPR_IN_DETAIL|| '</EXPR_IN_DETAIL>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL";
/*Place each result of this query between <AO_D195E9_CONFIG_PROPERTIES></AO_D195E9_CONFIG_PROPERTIES> tags*/
SELECT
'<row>' ||
'<DESCRIPTION>'|| "DESCRIPTION"|| '</DESCRIPTION>'||
'<ID>'|| "ID"|| '</ID>'||
'<PROPERTY>'|| "PROPERTY"|| '</PROPERTY>'||
'<VALUE>'|| "VALUE"|| '</VALUE>'||
'</row>' data_xml
FROM "AO_D195E9_CONFIG_PROPERTIES";
/*Place each result of this query between <AO_D195E9_CONFIG></AO_D195E9_CONFIG> tags*/
SELECT
(
'<row>'||
'<ABSTAIN_ACTION_ENABLED>'|| "ABSTAIN_ACTION_ENABLED"|| '</ABSTAIN_ACTION_ENABLED>'||
'<APPROVAL_TAG>'|| "APPROVAL_TAG"|| '</APPROVAL_TAG>'||
'<APP_COND_WF_UPDATABLE>'|| "APP_COND_WF_UPDATABLE"|| '</APP_COND_WF_UPDATABLE>'||
'<APP_PANEL_FILTER>'|| "APP_PANEL_FILTER"|| '</APP_PANEL_FILTER>'||
'<AUTO_GRANT_PERM>'|| "AUTO_GRANT_PERM"|| '</AUTO_GRANT_PERM>'||
'<AWT_CMRA>'|| "AWT_CMRA"|| '</AWT_CMRA>'||
'<CHECK_INFO>'|| "CHECK_INFO"|| '</CHECK_INFO>'||
'<CUSTOM_COMMENT>'|| "CUSTOM_COMMENT"|| '</CUSTOM_COMMENT>'||
'<CUSTOM_DEFINE_APPROVAL>'|| "CUSTOM_DEFINE_APPROVAL"|| '</CUSTOM_DEFINE_APPROVAL>'||
'<CUSTOM_REQUESTER_APPROVAL>'|| "CUSTOM_REQUESTER_APPROVAL"|| '</CUSTOM_REQUESTER_APPROVAL>'||
'<DELEGATION_ENABLED>'|| "DELEGATION_ENABLED"|| '</DELEGATION_ENABLED>'||
'<ENABLED_NAC>'|| "ENABLED_NAC"|| '</ENABLED_NAC>'||
'<EXPANED_APP_PANEL>'|| "EXPANED_APP_PANEL"|| '</EXPANED_APP_PANEL>'||
'<FROM_EMAIL>'|| "FROM_EMAIL"|| '</FROM_EMAIL>'||
'<HIDE_HACTION_ABSTAINED>'|| "HIDE_HACTION_ABSTAINED"|| '</HIDE_HACTION_ABSTAINED>'||
'<HIDE_HACTION_APPROVED>'|| "HIDE_HACTION_APPROVED"|| '</HIDE_HACTION_APPROVED>'||
'<HIDE_HACTION_APP_NOTIFY>'|| "HIDE_HACTION_APP_NOTIFY"|| '</HIDE_HACTION_APP_NOTIFY>'||
'<HIDE_HACTION_AUNOTIFY>'|| "HIDE_HACTION_AUNOTIFY"|| '</HIDE_HACTION_AUNOTIFY>'||
'<HIDE_HACTION_AUTRANS>'|| "HIDE_HACTION_AUTRANS"|| '</HIDE_HACTION_AUTRANS>'||
'<HIDE_HACTION_COMMENT>'|| "HIDE_HACTION_COMMENT"|| '</HIDE_HACTION_COMMENT>'||
'<HIDE_HACTION_NPENDING>'|| "HIDE_HACTION_NPENDING"|| '</HIDE_HACTION_NPENDING>'||
'<HIDE_HACTION_PENDING>'|| "HIDE_HACTION_PENDING"|| '</HIDE_HACTION_PENDING>'||
'<HIDE_HACTION_REJECTED>'|| "HIDE_HACTION_REJECTED"|| '</HIDE_HACTION_REJECTED>'||
'<HIDE_HACTION_REPLY_NOTIFY>'|| "HIDE_HACTION_REPLY_NOTIFY"|| '</HIDE_HACTION_REPLY_NOTIFY>'||
'<HIDE_HACTION_SING_NOTIFY>'|| "HIDE_HACTION_SING_NOTIFY"|| '</HIDE_HACTION_SING_NOTIFY>'||
'<HIDE_HISTORY_ACTION>'|| "HIDE_HISTORY_ACTION"|| '</HIDE_HISTORY_ACTION>'||
'<HIDE_HISTORY_APPROVAL>'|| "HIDE_HISTORY_APPROVAL"|| '</HIDE_HISTORY_APPROVAL>'||
'<HIDE_HISTORY_APPROVER_C>'|| "HIDE_HISTORY_APPROVER_C"|| '</HIDE_HISTORY_APPROVER_C>'||
'<HIDE_HISTORY_DESTINATION_S>'|| "HIDE_HISTORY_DESTINATION_S"|| '</HIDE_HISTORY_DESTINATION_S>'||
'<HIDE_HISTORY_SOURCE_S>'|| "HIDE_HISTORY_SOURCE_S"|| '</HIDE_HISTORY_SOURCE_S>'||
'<HIDE_HISTORY_TRANS>'|| "HIDE_HISTORY_TRANS"|| '</HIDE_HISTORY_TRANS>'||
'<HIDE_MENU>'|| "HIDE_MENU"|| '</HIDE_MENU>') || (
'<HIDE_PACOMMENT>'|| "HIDE_PACOMMENT"|| '</HIDE_PACOMMENT>'||
'<HIDE_PACTION>'|| "HIDE_PACTION"|| '</HIDE_PACTION>'||
'<HIDE_PAPP_NAME>'|| "HIDE_PAPP_NAME"|| '</HIDE_PAPP_NAME>'||
'<HIDE_PDETAIL>'|| "HIDE_PDETAIL"|| '</HIDE_PDETAIL>'||
'<HIDE_PREQUEST_NOTIF>'|| "HIDE_PREQUEST_NOTIF"|| '</HIDE_PREQUEST_NOTIF>'||
'<HISTORY_COLUMN_TITLES>'|| "HISTORY_COLUMN_TITLES"|| '</HISTORY_COLUMN_TITLES>'||
'<HISTORY_EXPAND_ROWS>'|| "HISTORY_EXPAND_ROWS"|| '</HISTORY_EXPAND_ROWS>'||
'<HISTORY_FILTER>'|| "HISTORY_FILTER"|| '</HISTORY_FILTER>'||
'<HISTORY_GROUP_BY>'|| "HISTORY_GROUP_BY"|| '</HISTORY_GROUP_BY>'||
'<ID>'|| "ID"|| '</ID>'||
'<LABEL_ABSTAIN_BUTTON>'|| "LABEL_ABSTAIN_BUTTON"|| '</LABEL_ABSTAIN_BUTTON>'||
'<LABEL_ACTION_APPROVAL>'|| "LABEL_ACTION_APPROVAL"|| '</LABEL_ACTION_APPROVAL>'||
'<LABEL_APPROVAL_BUTTON>'|| "LABEL_APPROVAL_BUTTON"|| '</LABEL_APPROVAL_BUTTON>'||
'<LABEL_APPROVAL_NAME>'|| "LABEL_APPROVAL_NAME"|| '</LABEL_APPROVAL_NAME>'||
'<LABEL_APP_COMMENT>'|| "LABEL_APP_COMMENT"|| '</LABEL_APP_COMMENT>'||
'<LABEL_DETAIL>'|| "LABEL_DETAIL"|| '</LABEL_DETAIL>'||
'<LABEL_HISTORY_ACTION>'|| "LABEL_HISTORY_ACTION"|| '</LABEL_HISTORY_ACTION>'||
'<LABEL_HISTORY_APPROVAL>'|| "LABEL_HISTORY_APPROVAL"|| '</LABEL_HISTORY_APPROVAL>'||
'<LABEL_HISTORY_APPROVER_C>'|| "LABEL_HISTORY_APPROVER_C"|| '</LABEL_HISTORY_APPROVER_C>'||
'<LABEL_HISTORY_DESTINATION_S>'|| "LABEL_HISTORY_DESTINATION_S"|| '</LABEL_HISTORY_DESTINATION_S>'||
'<LABEL_HISTORY_SOURCE_S>'|| "LABEL_HISTORY_SOURCE_S"|| '</LABEL_HISTORY_SOURCE_S>'||
'<LABEL_HISTORY_TRANS>'|| "LABEL_HISTORY_TRANS"|| '</LABEL_HISTORY_TRANS>'||
'<LABEL_REJECT_BUTTON>'|| "LABEL_REJECT_BUTTON"|| '</LABEL_REJECT_BUTTON>'||
'<LABEL_REQUEST_APPROVAL>'|| "LABEL_REQUEST_APPROVAL"|| '</LABEL_REQUEST_APPROVAL>'||
'<LABEL_REQUEST_APPROVALS>'|| "LABEL_REQUEST_APPROVALS"|| '</LABEL_REQUEST_APPROVALS>'||
'<LABEL_REQUEST_NOTIFY>'|| "LABEL_REQUEST_NOTIFY"|| '</LABEL_REQUEST_NOTIFY>'||
'<LABEL_RESET_BUTTON>'|| "LABEL_RESET_BUTTON"|| '</LABEL_RESET_BUTTON>'||
'<LARGE_BUTTONS>'|| "LARGE_BUTTONS"|| '</LARGE_BUTTONS>'||
'<LOCK_ACTION_ENABLED>'|| "LOCK_ACTION_ENABLED"|| '</LOCK_ACTION_ENABLED>'||
'<NOTIFICATION_RECIPIENT_CUSTOM>'|| "NOTIFICATION_RECIPIENT_CUSTOM"|| '</NOTIFICATION_RECIPIENT_CUSTOM>'||
'<RESPONSIVE_AWT>'|| "RESPONSIVE_AWT"|| '</RESPONSIVE_AWT>'||
'<TAB_COMM_DISABLED>'|| "TAB_COMM_DISABLED"|| '</TAB_COMM_DISABLED>') ||(
'<TAB_HISTORY_ENABLED>'|| "TAB_HISTORY_ENABLED"|| '</TAB_HISTORY_ENABLED>'||
'<USER_APPROVER_BULK>'|| "USER_APPROVER_BULK"|| '</USER_APPROVER_BULK>'||
'<USER_AWT>'|| "USER_AWT"|| '</USER_AWT>'||
'<USER_COND_RULE>'|| "USER_COND_RULE"|| '</USER_COND_RULE>'||
'<USER_LARGE_BUTTONS>'|| "USER_LARGE_BUTTONS"|| '</USER_LARGE_BUTTONS>'||
'<USER_NOTIFY_NAC>'|| "USER_NOTIFY_NAC"|| '</USER_NOTIFY_NAC>'||
'<VIEW_WORKFLOW>'|| "VIEW_WORKFLOW"|| '</VIEW_WORKFLOW>'||
'</row>') data_xml
FROM "AO_D195E9_CONFIG";
/*Place each result of this query between <AO_D195E9_CONDITIONAL_RULE></AO_D195E9_CONDITIONAL_RULE> tags*/
SELECT
'<row>'||
'<CONDITIONAL_NAME>'|| "CONDITIONAL_NAME"|| '</CONDITIONAL_NAME>'||
'<CONDITIONAL_RULE>'|| "CONDITIONAL_RULE"|| '</CONDITIONAL_RULE>'||
'<ID>'|| "ID"|| '</ID>'||
'<USER_EVALUATOR>'|| "USER_EVALUATOR"|| '</USER_EVALUATOR>'||
'</row>' data_xml
FROM "AO_D195E9_CONDITIONAL_RULE";
/*Place each result of this query between <AO_D195E9_CUSTOM_MAIL_TEMPLATE></AO_D195E9_CUSTOM_MAIL_TEMPLATE> tags*/
SELECT (
'<row>'||
'<BODY_SECTION>'|| REPLACE ("BODY_SECTION", '&', '&')|| '</BODY_SECTION>'||
'<BUTTON_LINKS_TYPE>'|| "BUTTON_LINKS_TYPE"|| '</BUTTON_LINKS_TYPE>'||
'<BUTTON_TEXTS>'|| "BUTTON_TEXTS"|| '</BUTTON_TEXTS>'||
'<COMMENT_ENABLED>'|| "COMMENT_ENABLED"|| '</COMMENT_ENABLED>'||
'<COMMENT_ENABLED_IF_REQUIRED>'|| "COMMENT_ENABLED_IF_REQUIRED"|| '</COMMENT_ENABLED_IF_REQUIRED>'||
'<CONDITIONAL_RULE_ID>'|| "CONDITIONAL_RULE_ID"|| '</CONDITIONAL_RULE_ID>'||
'<CONDITION_ENABLING_TEMPLATE_ID>'|| "CONDITION_ENABLING_TEMPLATE_ID"|| '</CONDITION_ENABLING_TEMPLATE_ID>'||
'<CUSTOM_APPROVAL_INSTRUCT>'|| REPLACE ("CUSTOM_APPROVAL_INSTRUCT", '&', '&')|| '</CUSTOM_APPROVAL_INSTRUCT>'||
'<CUSTOM_TEMPLATE_NAME>'|| "CUSTOM_TEMPLATE_NAME"|| '</CUSTOM_TEMPLATE_NAME>'||
'<FOOTER>'|| "FOOTER"|| '</FOOTER>'||
'<HEADER>'|| "HEADER"|| '</HEADER>'||
'<HIDE_APPROVAL_BUTTON>'|| "HIDE_APPROVAL_BUTTON"|| '</HIDE_APPROVAL_BUTTON>'||
'<HIDE_APPROVAL_COMMENT>'|| "HIDE_APPROVAL_COMMENT"|| '</HIDE_APPROVAL_COMMENT>'||
'<HIDE_APPROVAL_INSTRUCT>'|| "HIDE_APPROVAL_INSTRUCT"|| '</HIDE_APPROVAL_INSTRUCT>'||
'<HIDE_ASSIGNEE>'|| "HIDE_ASSIGNEE"|| '</HIDE_ASSIGNEE>'||
'<HIDE_COMMENT>'|| "HIDE_COMMENT"|| '</HIDE_COMMENT>') || (
'<HIDE_CREATED>'|| "HIDE_CREATED"|| '</HIDE_CREATED>'||
'<HIDE_DESCRIPTION>'|| "HIDE_DESCRIPTION"|| '</HIDE_DESCRIPTION>'||
'<HIDE_ISSUE_TYPE>'|| "HIDE_ISSUE_TYPE"|| '</HIDE_ISSUE_TYPE>'||
'<HIDE_LOGO>'|| "HIDE_LOGO"|| '</HIDE_LOGO>'||
'<HIDE_PRIORITY>'|| "HIDE_PRIORITY"|| '</HIDE_PRIORITY>'||
'<HIDE_PROJECT>'|| "HIDE_PROJECT"|| '</HIDE_PROJECT>'||
'<HIDE_REPORTER>'|| "HIDE_REPORTER"|| '</HIDE_REPORTER>'||
'<HIDE_WORKFLOW_TRANS>'|| "HIDE_WORKFLOW_TRANS"|| '</HIDE_WORKFLOW_TRANS>'||
'<ID>'|| "ID"|| '</ID>'||
'<IS_BOTTOM_BODY_SECTION>'|| "IS_BOTTOM_BODY_SECTION"|| '</IS_BOTTOM_BODY_SECTION>'||
'<IS_BOTTOM_BUTTON>'|| "IS_BOTTOM_BUTTON"|| '</IS_BOTTOM_BUTTON>'||
'<IS_EMAIL_TEMPLATE_DEFAULT>'|| "IS_EMAIL_TEMPLATE_DEFAULT"|| '</IS_EMAIL_TEMPLATE_DEFAULT>'||
'<IS_EMAIL_TEMPLATE_REPLY>'|| "IS_EMAIL_TEMPLATE_REPLY"|| '</IS_EMAIL_TEMPLATE_REPLY>'||
'<PROJECT_ID>'|| "PROJECT_ID"|| '</PROJECT_ID>'||
'<SHOW_LINKED_ISSUES>'|| "SHOW_LINKED_ISSUES"|| '</SHOW_LINKED_ISSUES>'||
'<SHOW_SUBTASKS>'|| "SHOW_SUBTASKS"|| '</SHOW_SUBTASKS>'||
'<SUBJECT>'|| REPLACE ("SUBJECT", '&','&')|| '</SUBJECT>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>') data_xml
FROM "AO_D195E9_CUSTOM_MAIL_TEMPLATE";
/*Place each result of this query between <AO_D195E9_APPROVAL_NOT_NOTIFY></AO_D195E9_APPROVAL_NOT_NOTIFY> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<RECIPIENT>'|| "RECIPIENT"|| '</RECIPIENT>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_NOT_NOTIFY";
/*Place each result of this query between <AO_D195E9_NTF_SCHEME></AO_D195E9_NTF_SCHEME> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<DESCRIPTION>'|| "DESCRIPTION"|| '</DESCRIPTION>'||
'<NAME>'|| "NAME"|| '</NAME>'||
'</row>' data_xml
FROM "AO_D195E9_NTF_SCHEME";
/*Place each result of this query between <AO_D195E9_NTF_SCHEME_DETAIL></AO_D195E9_NTF_SCHEME_DETAIL> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<CUSTOM_MAIL_TEMPLATE_ID>'|| "CUSTOM_MAIL_TEMPLATE_ID"|| '</CUSTOM_MAIL_TEMPLATE_ID>'||
'<EVENT_TYPE_ID>'|| "EVENT_TYPE_ID"|| '</EVENT_TYPE_ID>'||
'<NOTIFY_EXPRESSION>'|| "NOTIFY_EXPRESSION"|| '</NOTIFY_EXPRESSION>'||
'<NTF_SCHEME_ID>'|| "NTF_SCHEME_ID"|| '</NTF_SCHEME_ID>'||
'</row>' data_xml
FROM "AO_D195E9_NTF_SCHEME_DETAIL";
/*Place each result of this query between <AO_D195E9_APPROVAL_RECIPIENTS></AO_D195E9_APPROVAL_RECIPIENTS> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<EVENTS>'|| "EVENTS"|| '</EVENTS>'||
'<RECIPIENT>'|| "RECIPIENT"|| '</RECIPIENT>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_RECIPIENTS";
/*Place each result of this query between <AO_D195E9_APPROVAL_PROJECTS></AO_D195E9_APPROVAL_PROJECTS> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<PROJECT_ID>'|| "PROJECT_ID"|| '</PROJECT_ID>'||
'<REQUESTER_TYPE>'|| "REQUESTER_TYPE"|| '</REQUESTER_TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_PROJECTS";
/*Place each result of this query between <AO_D195E9_APPROVAL_REQUESTERS></AO_D195E9_APPROVAL_REQUESTERS> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<ISSUE_TYPE_ID>'|| "ISSUE_TYPE_ID"|| '</ISSUE_TYPE_ID>'||
'<PROJECT_ID>'|| "PROJECT_ID"|| '</PROJECT_ID>'||
'<REQUESTER>'|| "REQUESTER"|| '</REQUESTER>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_REQUESTERS";
/*Place each result of this query between <AO_D195E9_APPROVAL_DEFINERS></AO_D195E9_APPROVAL_DEFINERS> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<ISSUE_TYPE_ID>'|| "ISSUE_TYPE_ID"|| '</ISSUE_TYPE_ID>'||
'<PROJECT_ID>'|| "PROJECT_ID"|| '</PROJECT_ID>'||
'<DEFINER>'|| "DEFINER"|| '</DEFINER>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_DEFINERS";
/*Place each result of this query between <AO_D195E9_APPROVAL_MENU_PERM></AO_D195E9_APPROVAL_MENU_PERM> tags*/
SELECT
'<row>'||
'<ID>'|| "ID"|| '</ID>'||
'<ITEM>'|| "ITEM"|| '</ITEM>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_MENU_PERM";
/*Place each result of this query between <AO_D195E9_APPROVAL_MAPPING></AO_D195E9_APPROVAL_MAPPING> tags*/
SELECT
(
'<row>'||
'<ABSTAIN_ACTION_STATUS>'|| "ABSTAIN_ACTION_STATUS"|| '</ABSTAIN_ACTION_STATUS>'||
'<AREA_COND_RULE_ID>'|| "AREA_COND_RULE_ID"|| '</AREA_COND_RULE_ID>'||
'<AREA_DATE_PICKER>'|| "AREA_DATE_PICKER"|| '</AREA_DATE_PICKER>'||
'<AREA_ELAPSED_TIME>'|| "AREA_ELAPSED_TIME"|| '</AREA_ELAPSED_TIME>'||
'<AREA_SERVICE_NAME>'|| "AREA_SERVICE_NAME"|| '</AREA_SERVICE_NAME>'||
'<ARN>'|| "ARN"|| '</ARN>'||
'<AWT>'|| "AWT"|| '</AWT>'||
'<AWTAD>'|| "AWTAD"|| '</AWTAD>'||
'<AWTR>'|| "AWTR"|| '</AWTR>'||
'<CONDITIONAL_RULE_ID>'|| "CONDITIONAL_RULE_ID"|| '</CONDITIONAL_RULE_ID>'||
'<CONFIG_ID>'|| "CONFIG_ID"|| '</CONFIG_ID>')||
(
'<DA_DECISION>'|| "DA_DECISION"|| '</DA_DECISION>'||
'<DA_ELAPSED_TIME>'|| "DA_ELAPSED_TIME"|| '</DA_ELAPSED_TIME>'||
'<DA_SERVICE_NAME>'|| "DA_SERVICE_NAME"|| '</DA_SERVICE_NAME>'||
'<DA_USER_KEY>'|| "DA_USER_KEY"|| '</DA_USER_KEY>'||
'<DESTINATION_STATUS_ID>'|| "DESTINATION_STATUS_ID"|| '</DESTINATION_STATUS_ID>'||
'<ID>'|| "ID"|| '</ID>'||
'<ISSUE_TYPE_ID>'|| "ISSUE_TYPE_ID"|| '</ISSUE_TYPE_ID>'||
'<IS_DELETE>'|| "IS_DELETE"|| '</IS_DELETE>'||
'<IS_DRAFT>'|| "IS_DRAFT"|| '</IS_DRAFT>'||
'<IS_LOCKED>'|| "IS_LOCKED"|| '</IS_LOCKED>'||
'<IS_NOT_SINGLE>'|| "IS_NOT_SINGLE"|| '</IS_NOT_SINGLE>'||
'<LOCKED_DATE>'|| "LOCKED_DATE"|| '</LOCKED_DATE>'||
'<LOCKED_INFO>'|| "LOCKED_INFO"|| '</LOCKED_INFO>'
)|| (
'<MAIL_TEMPLATE_REPLY_ID>'|| "MAIL_TEMPLATE_REPLY_ID"|| '</MAIL_TEMPLATE_REPLY_ID>'||
'<MAIL_TEMPLATE_REQUEST_ID>'|| "MAIL_TEMPLATE_REQUEST_ID"|| '</MAIL_TEMPLATE_REQUEST_ID>'||
'<MRA>'|| "MRA"|| '</MRA>'||
'<MRR>'|| "MRR"|| '</MRR>'||
'<NAC>'|| "NAC"|| '</NAC>'||
'<ORDER_MAP>'|| "ORDER_MAP"|| '</ORDER_MAP>'||
'<PROJECT_ID>'|| "PROJECT_ID"|| '</PROJECT_ID>'||
'<RAC>'|| "RAC"|| '</RAC>'||
'<RACA>'|| "RACA"|| '</RACA>'||
'<REPLY_NOTIFICATION_SCHEMA_ID>'|| "REPLY_NOTIFICATION_SCHEMA_ID"|| '</REPLY_NOTIFICATION_SCHEMA_ID>'||
'<SA>'|| "SA"|| '</SA>'||
'<SAAD>'|| "SAAD"|| '</SAAD>'||
'<SHOW_APPROVAL_BUTTONS_JSD>'|| "SHOW_APPROVAL_BUTTONS_JSD"|| '</SHOW_APPROVAL_BUTTONS_JSD>'||
'<SHOW_APPROVAL_STATUS_JSD>'|| "SHOW_APPROVAL_STATUS_JSD"|| '</SHOW_APPROVAL_STATUS_JSD>'||
'<SOURCE_STATUS_ID>'|| "SOURCE_STATUS_ID"|| '</SOURCE_STATUS_ID>'||
'<SUPER_APPROVERS_EXPR>'|| "SUPER_APPROVERS_EXPR"|| '</SUPER_APPROVERS_EXPR>'||
'<TRANSITION_ID>'|| "TRANSITION_ID"|| '</TRANSITION_ID>'||
'<TRANSITION_ON_REJECTING>'|| "TRANSITION_ON_REJECTING"|| '</TRANSITION_ON_REJECTING>'||
'</row>'
) data_xml
FROM "AO_D195E9_APPROVAL_MAPPING";
/*Place each result of this query between <AO_D195E9_APPROVAL_MAPPING_REL></AO_D195E9_APPROVAL_MAPPING_REL> tags*/
SELECT
'<row>'||
'<APPROVAL_ID>'|| "APPROVAL_ID"|| '</APPROVAL_ID>'||
'<APPROVAL_MAPPING_ID>'|| "APPROVAL_MAPPING_ID"|| '</APPROVAL_MAPPING_ID>'||
'<ID>'|| "ID"|| '</ID>'||
'<IS_OPTIONAL_APPROVAL>'|| "IS_OPTIONAL_APPROVAL"|| '</IS_OPTIONAL_APPROVAL>'||
'<SORT_SA>'|| "SORT_SA"|| '</SORT_SA>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_MAPPING_REL";
/*Place each result of this query between <AO_D195E9_ISSUE_APPROVAL></AO_D195E9_ISSUE_APPROVAL> tags*/ SELECT ( '<row>'|| '<ABSTAIN_ACTION_STATUS>'|| "ABSTAIN_ACTION_STATUS"|| '</ABSTAIN_ACTION_STATUS>'|| '<APPROVAL_ID>'|| "APPROVAL_ID"|| '</APPROVAL_ID>'|| '<APPROVAL_STATUS>'|| "APPROVAL_STATUS"|| '</APPROVAL_STATUS>'|| '<APPROVER_USER>'|| "APPROVER_USER"|| '</APPROVER_USER>'|| '<AREA_COND_RULE_ID>'|| "AREA_COND_RULE_ID"|| '</AREA_COND_RULE_ID>'|| '<AREA_DATE_PICKER>'|| "AREA_DATE_PICKER"|| '</AREA_DATE_PICKER>'|| '<AREA_ELAPSED_TIME>'|| "AREA_ELAPSED_TIME"|| '</AREA_ELAPSED_TIME>'|| '<AREA_SERVICE_NAME>'|| "AREA_SERVICE_NAME"|| '</AREA_SERVICE_NAME>'|| '<ARN>'|| "ARN"|| '</ARN>'|| '<AWT>'|| "AWT"|| '</AWT>'|| '<AWTAD>'|| "AWTAD"|| '</AWTAD>'|| '<AWTR>'|| "AWTR"|| '</AWTR>'|| '<COMMENT_NOTIFICATION_DATE>'|| "COMMENT_NOTIFICATION_DATE"|| '</COMMENT_NOTIFICATION_DATE>'|| '<CONDITIONAL_RULE_ID>'|| "CONDITIONAL_RULE_ID"|| '</CONDITIONAL_RULE_ID>'|| '<CUSTOM_APPROVER>'|| "CUSTOM_APPROVER"|| '</CUSTOM_APPROVER>')|| ( '<DATE>'|| "DATE"|| '</DATE>'|| '<DA_DECISION>'|| "DA_DECISION"|| '</DA_DECISION>'|| '<DA_ELAPSED_TIME>'|| "DA_ELAPSED_TIME"|| '</DA_ELAPSED_TIME>'|| '<DA_SERVICE_NAME>'|| "DA_SERVICE_NAME"|| '</DA_SERVICE_NAME>'|| '<DA_USER_KEY>'|| "DA_USER_KEY"|| '</DA_USER_KEY>'|| '<DEFINE_CUSTOM_APPROVAL>'|| "DEFINE_CUSTOM_APPROVAL"|| '</DEFINE_CUSTOM_APPROVAL>'|| '<DELEGATOR_KEY>'|| "DELEGATOR_KEY"|| '</DELEGATOR_KEY>'|| '<ERROR_TRANSIT>'|| "ERROR_TRANSIT"|| '</ERROR_TRANSIT>'|| '<ERROR_TRANSIT_TYPE>'|| "ERROR_TRANSIT_TYPE"|| '</ERROR_TRANSIT_TYPE>'|| '<HAS_CONFIG_FOR_SINGLE_ISSUE>'|| "HAS_CONFIG_FOR_SINGLE_ISSUE"|| '</HAS_CONFIG_FOR_SINGLE_ISSUE>'|| '<ID>'|| "ID"|| '</ID>'|| '<ISSUE_ID>'|| "ISSUE_ID"|| '</ISSUE_ID>'|| '<ISSUE_STATUS>'|| "ISSUE_STATUS"|| '</ISSUE_STATUS>'|| '<IS_OPTIONAL_APPROVAL>'|| "IS_OPTIONAL_APPROVAL"|| '</IS_OPTIONAL_APPROVAL>'|| '<MAIL_TEMPLATE_REPLY_ID>'|| "MAIL_TEMPLATE_REPLY_ID"|| '</MAIL_TEMPLATE_REPLY_ID>' )|| ( '<MAIL_TEMPLATE_REQUEST_ID>'|| "MAIL_TEMPLATE_REQUEST_ID"|| '</MAIL_TEMPLATE_REQUEST_ID>'|| '<MRA>'|| "MRA"|| '</MRA>'|| '<MRR>'|| "MRR"|| '</MRR>'|| '<NAC>'|| "NAC"|| '</NAC>'|| '<NOTIFICATION_DATE>'|| "NOTIFICATION_DATE"|| '</NOTIFICATION_DATE>'|| '<RAC>'|| "RAC"|| '</RAC>'|| '<RACA>'|| "RACA"|| '</RACA>'|| '<REPLY_NOTIFICATION_SCHEMA_ID>'|| "REPLY_NOTIFICATION_SCHEMA_ID"|| '</REPLY_NOTIFICATION_SCHEMA_ID>'|| '<SA>'|| "SA"|| '</SA>'|| '<SAAD>'|| "SAAD"|| '</SAAD>'|| '<SHOW_APPROVAL_BUTTONS_JSD>'|| "SHOW_APPROVAL_BUTTONS_JSD"|| '</SHOW_APPROVAL_BUTTONS_JSD>'|| '<SHOW_APPROVAL_STATUS_JSD>'|| "SHOW_APPROVAL_STATUS_JSD"|| '</SHOW_APPROVAL_STATUS_JSD>'|| '<SORT_SA>'|| "SORT_SA"|| '</SORT_SA>'|| '<SOURCE_STATUS_ID>'|| "SOURCE_STATUS_ID"|| '</SOURCE_STATUS_ID>'|| '<SUBMITTED_DATE>'|| "SUBMITTED_DATE"|| '</SUBMITTED_DATE>'|| '<SUPER_APPROVERS_EXPR>'|| "SUPER_APPROVERS_EXPR"|| '</SUPER_APPROVERS_EXPR>'|| '<TRANSITION_ID>'|| "TRANSITION_ID"|| '</TRANSITION_ID>'|| '<TRANSITION_NAME>'|| "TRANSITION_NAME"|| '</TRANSITION_NAME>'|| '<TRANSITION_ON_REJECTING>'|| "TRANSITION_ON_REJECTING"|| '</TRANSITION_ON_REJECTING>'|| '<TYPE>'|| "TYPE"|| '</TYPE>'|| '</row>' ) data_xml FROM "AO_D195E9_ISSUE_APPROVAL" WHERE "TYPE" = 'SINGLE_ISSUE';
/*Place each result of this query between <AO_D195E9_APPROVAL_MRA></AO_D195E9_APPROVAL_MRA> tags*/
SELECT
'<row>'||
'<APPROVAL_MAPPING_ID>'|| "APPROVAL_MAPPING_ID"|| '</APPROVAL_MAPPING_ID>'||
'<CONDITIONAL_RULE_ID>'|| "CONDITIONAL_RULE_ID"|| '</CONDITIONAL_RULE_ID>'||
'<ID>'|| "ID"|| '</ID>'||
'<ISSUE_ID>'|| "ISSUE_ID"|| '</ISSUE_ID>'||
'<MRA>'|| "MRA"|| '</MRA>'||
'<ORDER>'|| "ORDER"|| '</ORDER>'||
'<SOURCE_STATUS_ID>'|| "SOURCE_STATUS_ID"|| '</SOURCE_STATUS_ID>'||
'<TRANSITION_ID>'|| "TRANSITION_ID"|| '</TRANSITION_ID>'||
'<TYPE>'|| "TYPE"|| '</TYPE>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_MRA";
/*Place each result of this query between <AO_D195E9_APPROVAL_HISTORY></AO_D195E9_APPROVAL_HISTORY> tags*/
SELECT
'<row>'||
'<ACTION>'|| "ACTION"|| '</ACTION>'||
'<APPROVAL_COMMENT>'|| "APPROVAL_COMMENT"|| '</APPROVAL_COMMENT>'||
'<APPROVAL_DETAIL>'|| "APPROVAL_DETAIL"|| '</APPROVAL_DETAIL>'||
'<APPROVAL_NAME>'|| "APPROVAL_NAME"|| '</APPROVAL_NAME>'||
'<COMMENT>'|| "COMMENT"|| '</COMMENT>'||
'<DATE>'|| "DATE"|| '</DATE>'||
'<DELEGATOR_KEY>'|| "DELEGATOR_KEY"|| '</DELEGATOR_KEY>'||
'<DESTINATION_STATUS>'|| "DESTINATION_STATUS"|| '</DESTINATION_STATUS>'||
'<EXECUTOR>'|| "EXECUTOR"|| '</EXECUTOR>'||
'<EXECUTOR_KEY>'|| "EXECUTOR_KEY"|| '</EXECUTOR_KEY>'||
'<ID>'|| "ID"|| '</ID>'||
'<ISSUE_ID>'|| "ISSUE_ID"|| '</ISSUE_ID>'||
'<NOTIFICATION_DATE>'|| "NOTIFICATION_DATE"|| '</NOTIFICATION_DATE>'||
'<SOURCE_STATUS>'|| "SOURCE_STATUS"|| '</SOURCE_STATUS>'||
'<SUBMITTED_DATE>'|| "SUBMITTED_DATE"|| '</SUBMITTED_DATE>'||
'<TRANSITION_NAME>'|| "TRANSITION_NAME"|| '</TRANSITION_NAME>'||
'</row>' data_xml
FROM "AO_D195E9_APPROVAL_HISTORY";
/*Replace <?xml version="1.0"?><ROWSET> tags with <AO_D195E9_APPROVAL_DELEGATED> and end </ROWSET> tag with </AO_D195E9_APPROVAL_DELEGATED>*/
SELECT dbms_xmlgen.getXML(
'SELECT *
FROM AO_D195E9_APPROVAL_DELEGATED')query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <AO_D195E9_LANGUAGE_PACK> and end </ROWSET> tag with </AO_D195E9_LANGUAGE_PACK>*/
SELECT dbms_xmlgen.getXML(
'SELECT *
FROM AO_D195E9_LANGUAGE_PACK where "LOCALE" is not null') query_xml from dual
/*Replace <?xml version="1.0"?><ROWSET> tags with <AO_D195E9_LANG_PACK_KEY_VAL> and end </ROWSET> tag with </AO_D195E9_LANG_PACK_KEY_VAL>*/
SELECT query_to_xml(
'SELECT "ID", "LANGUAGE_PACK_ID", "PROPERTY_KEY", "VALUE"
FROM public."AO_D195E9_LANG_PACK_KEY_VAL" WHERE "LANGUAGE_PACK_ID" IN
(SELECT "ID"
FROM public."AO_D195E9_LANGUAGE_PACK" where "LOCALE" is not null);', true , false, 'AO_D195E9_LANGUAGE_PACK')
Please click on the following box to display the queries you need to run for SQL Server
Please change [jiradb] to the name of the database you use, and [jiraschema] to the name of the schema within your database.
Queries for SQL Server
SELECT [id]
,[user_name]
,[email_address]
FROM [jiradb].[jiraschema].[cwd_user] for xml path('row'), root ('CWD_USER')
SELECT [id]
,[pname]
FROM [jiradb].[jiraschema].[ISSUETYPE] for xml path('row'), root ('ISSUETYPE')
SELECT [project_id]
,[project_key]
FROM [jiradb].[jiraschema].[project_key] for xml path('row'), root ('PROJECT_KEY')
SELECT [id]
,[issuenum]
,[project]
FROM [jiradb].[jiraschema].[jiraissue] for xml path('row'), root ('JIRAISSUE')
SELECT [id]
,[pname]
FROM [jiradb].[jiraschema].[issuestatus] for xml path('row'), root ('ISSUESTATUS')
SELECT [id]
,[cfname]
FROM [jiradb].[jiraschema].[customfield]
WHERE [jiradb].[jiraschema].[customfield].[CUSTOMFIELDTYPEKEY] = 'com.atlassian.jira.plugin.system.customfieldtypes:userpicker'
OR [jiradb].[jiraschema].[customfield].[CUSTOMFIELDTYPEKEY] = 'com.atlassian.jira.plugin.system.customfieldtypes:multigrouppicker'
OR [jiradb].[jiraschema].[customfield].[CUSTOMFIELDTYPEKEY] = 'com.atlassian.jira.plugin.system.customfieldtypes:multiuserpicker'
OR [jiradb].[jiraschema].[customfield].[CUSTOMFIELDTYPEKEY] = 'com.atlassian.jira.plugin.system.customfieldtypes:grouppicker'
for xml path('row'), root ('CUSTOMFIELD')
/*Place each result of this query between <WORKFLOWS></WORKFLOWS> tags*/
SELECT
*
FROM (
SELECT CONCAT('<action ', SUBSTRING(value,1, CHARINDEX('>',value)),'</action>') AS result
FROM [jiradb].[jiraschema].[jiraworkflows]
CROSS APPLY
STRING_SPLIT(REPLACE(CAST([DESCRIPTOR] AS nvarchar(max)),' <action ','$'), '$') AS removeText) AS result
WHERE CHARINDEX('name',result.result)>0
SELECT [ASSIGNEE_ENABLED]
,[CONDITIONAL_RULE_ID]
,[CONFIG_ID]
,[DESCRIPTION]
,[GROUPS]
,[GROUP_PICKER]
,[ID]
,[NAME]
,[NOT_ASSIGNEE]
,[NOT_GROUPS]
,[NOT_GROUP_PICKER]
,[NOT_LEAD]
,[NOT_REPORTER]
,[NOT_ROLES]
,[NOT_USERS]
,[NOT_USER_PICKER]
,[NOT_USER_PICKER_ANY]
,[OPERATOR]
,[PROJECT_LEAD_ENABLED]
,[REPORTER_ENABLED]
,[ROLES]
,[SA]
,[SHOW_TYPE]
,[USERS]
,[USER_PICKER]
,[USER_PICKER_ALL_EXPR]
,[USER_PICKER_ANY]
,[USER_PICKER_ANY_EXPR]
,[EXPR_IN_DETAIL]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL')
SELECT [DESCRIPTION]
,[ID]
,[PROPERTY]
,[VALUE]
FROM [jiradb].[jiraschema].[AO_D195E9_CONFIG_PROPERTIES]
FOR XML PATH('row'), ROOT ('AO_D195E9_CONFIG_PROPERTIES')
SELECT [ABSTAIN_ACTION_ENABLED]
,[APPROVAL_TAG]
,[APP_COND_WF_UPDATABLE]
,[APP_PANEL_FILTER]
,[AUTO_GRANT_PERM]
,[AWT_CMRA]
,[CHECK_INFO]
,[CUSTOM_COMMENT]
,[CUSTOM_DEFINE_APPROVAL]
,[CUSTOM_REQUESTER_APPROVAL]
,[DELEGATION_ENABLED]
,[ENABLED_NAC]
,[EXPANED_APP_PANEL]
,[FROM_EMAIL]
,[HIDE_HACTION_ABSTAINED]
,[HIDE_HACTION_APPROVED]
,[HIDE_HACTION_APP_NOTIFY]
,[HIDE_HACTION_AUNOTIFY]
,[HIDE_HACTION_AUTRANS]
,[HIDE_HACTION_COMMENT]
,[HIDE_HACTION_NPENDING]
,[HIDE_HACTION_PENDING]
,[HIDE_HACTION_REJECTED]
,[HIDE_HACTION_REPLY_NOTIFY]
,[HIDE_HACTION_SING_NOTIFY]
,[HIDE_HISTORY_ACTION]
,[HIDE_HISTORY_APPROVAL]
,[HIDE_HISTORY_APPROVER_C]
,[HIDE_HISTORY_DESTINATION_S]
,[HIDE_HISTORY_SOURCE_S]
,[HIDE_HISTORY_TRANS]
,[HIDE_MENU]
,[HIDE_PACOMMENT]
,[HIDE_PACTION]
,[HIDE_PAPP_NAME]
,[HIDE_PDETAIL]
,[HIDE_PREQUEST_NOTIF]
,[HISTORY_COLUMN_TITLES]
,[HISTORY_EXPAND_ROWS]
,[HISTORY_FILTER]
,[HISTORY_GROUP_BY]
,[ID]
,[LABEL_ABSTAIN_BUTTON]
,[LABEL_ACTION_APPROVAL]
,[LABEL_APPROVAL_BUTTON]
,[LABEL_APPROVAL_NAME]
,[LABEL_APP_COMMENT]
,[LABEL_DETAIL]
,[LABEL_HISTORY_ACTION]
,[LABEL_HISTORY_APPROVAL]
,[LABEL_HISTORY_APPROVER_C]
,[LABEL_HISTORY_DESTINATION_S]
,[LABEL_HISTORY_SOURCE_S]
,[LABEL_HISTORY_TRANS]
,[LABEL_REJECT_BUTTON]
,[LABEL_REQUEST_APPROVAL]
,[LABEL_REQUEST_APPROVALS]
,[LABEL_REQUEST_NOTIFY]
,[LABEL_RESET_BUTTON]
,[LARGE_BUTTONS]
,[LOCK_ACTION_ENABLED]
,[NOTIFICATION_RECIPIENT_CUSTOM]
,[RESPONSIVE_AWT]
,[TAB_COMM_DISABLED]
,[TAB_HISTORY_ENABLED]
,[USER_APPROVER_BULK]
,[USER_AWT]
,[USER_COND_RULE]
,[USER_LARGE_BUTTONS]
,[USER_NOTIFY_NAC]
,[VIEW_WORKFLOW]
FROM [jiradb].[jiraschema].[AO_D195E9_CONFIG]
FOR XML PATH('row'), ROOT ('AO_D195E9_CONFIG')
SELECT [CONDITIONAL_NAME]
,[CONDITIONAL_RULE]
,[ID]
,[USER_EVALUATOR]
FROM [jiradb].[jiraschema].[AO_D195E9_CONDITIONAL_RULE]
FOR XML PATH('row'), ROOT ('AO_D195E9_CONDITIONAL_RULE')
SELECT [BODY_SECTION]
,[BUTTON_LINKS_TYPE]
,[BUTTON_TEXTS]
,[COMMENT_ENABLED]
,[COMMENT_ENABLED_IF_REQUIRED]
,[CONDITIONAL_RULE_ID]
,[CONDITION_ENABLING_TEMPLATE_ID]
,[CUSTOM_APPROVAL_INSTRUCT]
,[CUSTOM_TEMPLATE_NAME]
,[FOOTER]
,[HEADER]
,[HIDE_APPROVAL_BUTTON]
,[HIDE_APPROVAL_COMMENT]
,[HIDE_APPROVAL_INSTRUCT]
,[HIDE_ASSIGNEE]
,[HIDE_COMMENT]
,[HIDE_CREATED]
,[HIDE_DESCRIPTION]
,[HIDE_ISSUE_TYPE]
,[HIDE_LOGO]
,[HIDE_PRIORITY]
,[HIDE_PROJECT]
,[HIDE_REPORTER]
,[HIDE_WORKFLOW_TRANS]
,[ID]
,[IS_BOTTOM_BODY_SECTION]
,[IS_BOTTOM_BUTTON]
,[IS_EMAIL_TEMPLATE_DEFAULT]
,[IS_EMAIL_TEMPLATE_REPLY]
,[PROJECT_ID]
,[SHOW_LINKED_ISSUES]
,[SHOW_SUBTASKS]
,[SUBJECT]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_CUSTOM_MAIL_TEMPLATE]
FOR XML PATH('row'), ROOT ('AO_D195E9_CUSTOM_MAIL_TEMPLATE')
SELECT [ID]
,[RECIPIENT]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_NOT_NOTIFY]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_NOT_NOTIFY')
SELECT [DESCRIPTION]
,[ID]
,[NAME]
FROM [jiradb].[jiraschema].[AO_D195E9_NTF_SCHEME]
FOR XML PATH('row'), ROOT ('AO_D195E9_NTF_SCHEME')
SELECT [ID]
,[CUSTOM_MAIL_TEMPLATE_ID]
,[EVENT_TYPE_ID]
,[NOTIFY_EXPRESSION]
,[NTF_SCHEME_ID]
FROM [jiradb].[jiraschema].[AO_D195E9_NTF_SCHEME_DETAIL]
FOR XML PATH('row'), ROOT ('AO_D195E9_NTF_SCHEME_DETAIL')
SELECT [ID]
,[EVENTS]
,[RECIPIENT]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_RECIPIENTS]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_RECIPIENTS')
SELECT [ID]
,[PROJECT_ID]
,[REQUESTER_TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_PROJECTS]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_PROJECTS')
SELECT [ID]
,[ISSUE_TYPE_ID]
,[PROJECT_ID]
,[REQUESTER]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_REQUESTERS]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_REQUESTERS')
SELECT [ID]
,[ISSUE_TYPE_ID]
,[PROJECT_ID]
,[DEFINER]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_DEFINERS]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_DEFINERS')
SELECT [ID]
,[ITEM]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_MENU_PERM]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_MENU_PERM')
SELECT [ABSTAIN_ACTION_STATUS]
,[AREA_COND_RULE_ID]
,[AREA_DATE_PICKER]
,[AREA_ELAPSED_TIME]
,[AREA_SERVICE_NAME]
,[ARN]
,[AWT]
,[AWTAD]
,[AWTR]
,[CONDITIONAL_RULE_ID]
,[CONFIG_ID]
,[DA_DECISION]
,[DA_ELAPSED_TIME]
,[DA_SERVICE_NAME]
,[DA_USER_KEY]
,[DESTINATION_STATUS_ID]
,[ID]
,[ISSUE_TYPE_ID]
,[IS_DELETE]
,[IS_DRAFT]
,[IS_LOCKED]
,[IS_NOT_SINGLE]
,[LOCKED_DATE]
,[LOCKED_INFO]
,[MAIL_TEMPLATE_REPLY_ID]
,[MAIL_TEMPLATE_REQUEST_ID]
,[MRA]
,[MRR]
,[NAC]
,[ORDER_MAP]
,[PROJECT_ID]
,[RAC]
,[RACA]
,[REPLY_NOTIFICATION_SCHEMA_ID]
,[SA]
,[SAAD]
,[SHOW_APPROVAL_BUTTONS_JSD]
,[SHOW_APPROVAL_STATUS_JSD]
,[SOURCE_STATUS_ID]
,[SUPER_APPROVERS_EXPR]
,[TRANSITION_ID]
,[TRANSITION_ON_REJECTING]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_MAPPING]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_MAPPING')
SELECT [APPROVAL_ID]
,[APPROVAL_MAPPING_ID]
,[ID]
,[IS_OPTIONAL_APPROVAL]
,[SORT_SA]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_MAPPING_REL]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_MAPPING_REL')
SELECT [ABSTAIN_ACTION_STATUS]
,[APPROVAL_ID]
,[APPROVAL_STATUS]
,[APPROVER_USER]
,[AREA_COND_RULE_ID]
,[AREA_DATE_PICKER]
,[AREA_ELAPSED_TIME]
,[AREA_SERVICE_NAME]
,[ARN]
,[AWT]
,[AWTAD]
,[AWTR]
,[COMMENT_NOTIFICATION_DATE]
,[CONDITIONAL_RULE_ID]
,[CUSTOM_APPROVER]
,[DATE]
,[DA_DECISION]
,[DA_ELAPSED_TIME]
,[DA_SERVICE_NAME]
,[DA_USER_KEY]
,[DEFINE_CUSTOM_APPROVAL]
,[DELEGATOR_KEY]
,[ERROR_TRANSIT]
,[ERROR_TRANSIT_TYPE]
,[HAS_CONFIG_FOR_SINGLE_ISSUE]
,[ID]
,[ISSUE_ID]
,[ISSUE_STATUS]
,[IS_OPTIONAL_APPROVAL]
,[MAIL_TEMPLATE_REPLY_ID]
,[MAIL_TEMPLATE_REQUEST_ID]
,[MRA]
,[MRR]
,[NAC]
,[NOTIFICATION_DATE]
,[RAC]
,[RACA]
,[REPLY_NOTIFICATION_SCHEMA_ID]
,[SA]
,[SAAD]
,[SHOW_APPROVAL_BUTTONS_JSD]
,[SHOW_APPROVAL_STATUS_JSD]
,[SORT_SA]
,[SOURCE_STATUS_ID]
,[SUBMITTED_DATE]
,[SUPER_APPROVERS_EXPR]
,[TRANSITION_ID]
,[TRANSITION_NAME]
,[TRANSITION_ON_REJECTING]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_ISSUE_APPROVAL]
WHERE [jiradb].[jiraschema].[AO_D195E9_ISSUE_APPROVAL].[TYPE] = 'SINGLE_ISSUE'
FOR XML PATH('row'), ROOT ('AO_D195E9_ISSUE_APPROVAL')
SELECT [APPROVAL_MAPPING_ID]
,[CONDITIONAL_RULE_ID]
,[ID]
,[ISSUE_ID]
,[MRA]
,[ORDER]
,[SOURCE_STATUS_ID]
,[TRANSITION_ID]
,[TYPE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_MRA]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_MRA')
SELECT [ACTION]
,[APPROVAL_COMMENT]
,[APPROVAL_CONFIG]
,[APPROVAL_DETAIL]
,[APPROVAL_NAME]
,[COMMENT]
,[DATE]
,[DELEGATOR_KEY]
,[DESTINATION_STATUS]
,[EXECUTOR]
,[EXECUTOR_KEY]
,[ID]
,[ISSUE_ID]
,[NOTIFICATION_DATE]
,[SOURCE_STATUS]
,[SUBMITTED_DATE]
,[TRANSITION_NAME]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_HISTORY]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_HISTORY')
SELECT [DELEGATED_KEY]
,[DELEGATOR_KEY]
,[END_DATE]
,[ID]
,[ISSUE_TYPE_ID]
,[PROJECT_ID]
,[SEND_APPROVAL_REQUESTS]
,[START_DATE]
FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_DELEGATED]
FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_DELEGATED')
SELECT [DESCRIPTION]
,[ENABLED]
,[ID]
,[LOCALE]
,[MODIFIED_DATE]
,[MODIFIED_USER]
,[NAME]
FROM [jiradb].[jiraschema].[AO_D195E9_LANGUAGE_PACK]
FOR XML PATH('row'), ROOT ('AO_D195E9_LANGUAGE_PACK')
SELECT [ID]
,[LANGUAGE_PACK_ID]
,[PROPERTY_KEY]
,[VALUE]
FROM [jiradb].[jiraschema].[AO_D195E9_LANG_PACK_KEY_VAL]
WHERE [jiradb].[jiraschema].[AO_D195E9_LANG_PACK_KEY_VAL].[LANGUAGE_PACK_ID]
IN (SELECT [ID]
FROM [jiradb].[jiraschema].[AO_D195E9_LANGUAGE_PACK] where [jiradb].[jiraschema].[AO_D195E9_LANGUAGE_PACK].[LOCALE] is not null)
FOR XML PATH('row'), ROOT ('AO_D195E9_LANG_PACK_KEY_VAL')
Once you have your XML file ready, you should do the following
In the Migration Tool section, you will be able to access the Migration Tool.
This screen shows two buttons:
Select XML file: this button will allow you to load the previously created XML file.
Start migration: this button will allow you to start the migration
Once you have clicked on the "Start Migration" button, the migration process will start running.
In the migration process the first thing it does is a data validation, it checks that the records such as users, projects, issue types, workflows among others are in the instance to continue with the process.
If you get error messages in the migration process, please review all errors and warnings that are presented, fix the errors in your file and instance and perform the migration again.
Once all this is correct and without errors, it continues with the process of importing the data into the Herzum Approval for Cloud configuration.
Once the process is completed, you will be shown a message that the migration was successful.
- No labels