Panel

bgColor	#F4F5F7

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.

Info
Remember: the backup file must be an XML file.

Execute the following queries:

Panel

panelIconId	atlassian-warning
panelIcon	:warning:
bgColor	#FFF0B3

Please click on the following box to display the queries you need to run for PostgresSQL

Info
Select only the results shown in the concat column, and save it in an XML file.

Expand

title	Queries for PostgresSQL

Code Block

language	sql

SELECT
	concat ( '<CWD_USER>', STRING_AGG ( RESULT.data_xml, '' ), '</CWD_USER>' ),
	1 AS FILTER 
FROM
	(
	SELECT
		concat ( '<row>', '<id>', ID, '</id>', '<user_name>', user_name, '</user_name>', '<email_address>', email_address, '</email_address>', '</row>' ) data_xml 
	FROM
		PUBLIC.cwd_user 
	) AS RESULT UNION
SELECT
	concat ( '<ISSUETYPE>', STRING_AGG ( RESULT.data_xml, '' ), '</ISSUETYPE>' ),
	2 AS FILTER 
FROM
	( SELECT concat ( '<row>', '<id>', ID, '</id>', '<pname>', pname, '</pname>', '</row>' ) data_xml FROM PUBLIC.issuetype ) AS RESULT UNION
SELECT
	concat ( '<PROJECT_KEY>', STRING_AGG ( RESULT.data_xml, '' ), '</PROJECT_KEY>' ),
	3 AS FILTER 
FROM
	( SELECT concat ( '<row>', '<project_id>', project_id, '</project_id>', '<project_key>', project_key, '</project_key>', '</row>' ) data_xml FROM PUBLIC.project_key ) AS RESULT UNION
SELECT
	concat ( '<JIRAISSUE>', STRING_AGG ( RESULT.data_xml, '' ), '</JIRAISSUE>' ),
	4 AS FILTER 
FROM
	(
	SELECT
		concat ( '<row>', '<id>', ID, '</id>', '<issuenum>', issuenum, '</issuenum>', '<project>', project, '</project>', '</row>' ) data_xml 
	FROM
		PUBLIC.jiraissue 
	) AS RESULT UNION
SELECT
	concat ( '<ISSUESTATUS>', STRING_AGG ( RESULT.data_xml, '' ), '</ISSUESTATUS>' ),
	5 AS FILTER 
FROM
	( SELECT concat ( '<row>', '<id>', ID, '</id>', '<pname>', pname, '</pname>', '</row>' ) data_xml FROM PUBLIC.issuestatus ) AS RESULT UNION
SELECT
	concat ( '<CUSTOMFIELD>', STRING_AGG ( RESULT.data_xml, '' ), '</CUSTOMFIELD>' ),
	6 AS FILTER 
FROM
	(
	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' 
	) AS RESULT UNION
SELECT
	concat ( '<WORKFLOWS>', STRING_AGG ( RESULT.data_xml, '' ), '</WORKFLOWS>' ),
	7 AS FILTER 
FROM
	(
	SELECT
		CONCAT ( '<action ', removeText.RESULT, '</action>' ) AS data_xml 
	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 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL>' ),
	8 AS FILTER 
FROM
	(
	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", '&', '&amp;' ),
		'</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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_CONFIG_PROPERTIES>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_CONFIG_PROPERTIES>' ),
	9 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			'<row>',
			'<DESCRIPTION>',
			"DESCRIPTION",
			'</DESCRIPTION>',
			'<ID>',
			"ID",
			'</ID>',
			'<PROPERTY>',
			"PROPERTY",
			'</PROPERTY>',
			'<VALUE>',
			"VALUE",
			'</VALUE>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_CONFIG_PROPERTIES" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_CONFIG>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_CONFIG>' ),
	10 AS FILTER 
FROM
	(
	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_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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_CONDITIONAL_RULE>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_CONDITIONAL_RULE>' ),
	11 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_CUSTOM_MAIL_TEMPLATE>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_CUSTOM_MAIL_TEMPLATE>' ),
	12 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			CONCAT (
				'<row>',
				'<BODY_SECTION>',
				REPLACE ( "BODY_SECTION", '&', '&amp;' ),
			'</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", '&', '&amp;' ),
			'</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", '&', '&amp;' ),
			'</SUBJECT>',
			'<TYPE>',
			"TYPE",
			'</TYPE>',
			'</row>' 
		) 
	) data_xml 
	FROM
		PUBLIC."AO_D195E9_CUSTOM_MAIL_TEMPLATE" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_NOT_NOTIFY>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_NOT_NOTIFY>' ),
	13 AS FILTER 
FROM
	(
	SELECT
		CONCAT ( '<row>', '<ID>', "ID", '</ID>', '<RECIPIENT>', "RECIPIENT", '</RECIPIENT>', '<TYPE>', "TYPE", '</TYPE>', '</row>' ) data_xml 
	FROM
		PUBLIC."AO_D195E9_APPROVAL_NOT_NOTIFY" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_NTF_SCHEME>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_NTF_SCHEME>' ),
	14 AS FILTER 
FROM
	(
	SELECT
		CONCAT ( '<row>', '<ID>', "ID", '</ID>', '<DESCRIPTION>', "DESCRIPTION", '</DESCRIPTION>', '<NAME>', "NAME", '</NAME>', '</row>' ) data_xml 
	FROM
		PUBLIC."AO_D195E9_NTF_SCHEME" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_NTF_SCHEME_DETAIL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_NTF_SCHEME_DETAIL>' ),
	15 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_RECIPIENTS>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_RECIPIENTS>' ),
	16 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			'<row>',
			'<ID>',
			"ID",
			'</ID>',
			'<EVENTS>',
			"EVENTS",
			'</EVENTS>',
			'<RECIPIENT>',
			"RECIPIENT",
			'</RECIPIENT>',
			'<TYPE>',
			"TYPE",
			'</TYPE>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_APPROVAL_RECIPIENTS" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_PROJECTS>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_PROJECTS>' ),
	17 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_REQUESTERS>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_REQUESTERS>' ),
	18 AS FILTER 
FROM
	(
	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" 
	WHERE
		"TYPE" != 'NOTYPE' 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_DEFINERS>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_DEFINERS>' ),
	19 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_MENU_PERM>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MENU_PERM>' ),
	20 AS FILTER 
FROM
	(
	SELECT
		CONCAT ( '<row>', '<ID>', "ID", '</ID>', '<ITEM>', "ITEM", '</ITEM>', '<TYPE>', "TYPE", '</TYPE>', '</row>' ) data_xml 
	FROM
		PUBLIC."AO_D195E9_APPROVAL_MENU_PERM" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_MAPPING>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MAPPING>' ),
	21 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_MAPPING_REL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MAPPING_REL>' ),
	22 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_ISSUE_APPROVAL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_ISSUE_APPROVAL>' ),
	23 AS FILTER 
FROM
	(
	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' 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_MRA>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MRA>' ),
	24 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_HISTORY>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_HISTORY>' ),
	25 AS FILTER 
FROM
	(
	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" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_APPROVAL_DELEGATED>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_DELEGATED>' ),
	26 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			'<row>',
			'<DELEGATED_KEY>',
			"DELEGATED_KEY",
			'</DELEGATED_KEY>',
			'<DELEGATOR_KEY>',
			"DELEGATOR_KEY",
			'</DELEGATOR_KEY>',
			'<END_DATE>',
			"END_DATE",
			'</END_DATE>',
			'<ID>',
			"ID",
			'</ID>',
			'<ISSUE_TYPE_ID>',
			"ISSUE_TYPE_ID",
			'</ISSUE_TYPE_ID>',
			'<PROJECT_ID>',
			"PROJECT_ID",
			'</PROJECT_ID>',
			'<SEND_APPROVAL_REQUESTS>',
			"SEND_APPROVAL_REQUESTS",
			'</SEND_APPROVAL_REQUESTS>',
			'<START_DATE>',
			"START_DATE",
			'</START_DATE>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_APPROVAL_DELEGATED" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_LANGUAGE_PACK>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_LANGUAGE_PACK>' ),
	27 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			'<row>',
			'<DESCRIPTION>',
			"DESCRIPTION",
			'</DESCRIPTION>',
			'<ENABLED>',
			"ENABLED",
			'</ENABLED>',
			'<ID>',
			"ID",
			'</ID>',
			'<LOCALE>',
			"LOCALE",
			'</LOCALE>',
			'<MODIFIED_DATE>',
			"MODIFIED_DATE",
			'</MODIFIED_DATE>',
			'<MODIFIED_USER>',
			"MODIFIED_USER",
			'</MODIFIED_USER>',
			'<NAME>',
			"NAME",
			'</NAME>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_LANGUAGE_PACK" 
	) AS RESULT UNION
SELECT
	concat ( '<AO_D195E9_LANG_PACK_KEY_VAL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_LANG_PACK_KEY_VAL>' ),
	28 AS FILTER 
FROM
	(
	SELECT
		CONCAT (
			'<row>',
			'<ID>',
			"ID",
			'</ID>',
			'<LANGUAGE_PACK_ID>',
			"LANGUAGE_PACK_ID",
			'</LANGUAGE_PACK_ID>',
			'<PROPERTY_KEY>',
			"PROPERTY_KEY",
			'</PROPERTY_KEY>',
			'<VALUE>',
			regexp_replace( "VALUE", E'<.*?>', '', 'g' ),
			'</VALUE>',
			'</row>' 
		) data_xml 
	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 ) 
	) AS RESULT 
ORDER BY
FILTER

Note
Please click on the following box to display the queries you need to run for Oracle

Expand

title	Queries for Oracle

Code Block

language	sql

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

Code Block

language	sql

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

Code Block

language	sql

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

Code Block
/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

Code Block

language	sql

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

Code Block

language	sql

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

Code Block

language	sql

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

Code Block

language	sql

/*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", '&', '&amp;')|| '</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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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", '&', '&amp;')|| '</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", '&', '&amp;')|| '</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", '&','&amp;')|| '</SUBJECT>'||
		'<TYPE>'|| "TYPE"|| '</TYPE>'||
   '</row>') data_xml
	FROM "AO_D195E9_CUSTOM_MAIL_TEMPLATE";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

/*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';

Code Block

language	sql

/*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";

Code Block

language	sql

/*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";

Code Block

language	sql

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

Code Block

language	sql

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

Code Block

language	sql

/*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')

Note
Please click on the following box to display the queries you need to run for SQL Server

Panel

panelIconId	atlassian-info
panelIcon	:info:
bgColor	#B3D4FF

Please change [jiradb] to the name of the database you use, and [jiraschema] to the name of the schema within your database.

Expand

title	Queries for SQL Server

Code Block

language	sql

SELECT [id]
      ,[user_name]
      ,[email_address]
  FROM [jiradb].[jiraschema].[cwd_user] for xml path('row'), root ('CWD_USER')

Code Block

language	sql

SELECT [id]
      ,[pname]
  FROM [jiradb].[jiraschema].[ISSUETYPE] for xml path('row'), root ('ISSUETYPE')

Code Block

language	sql

SELECT [project_id]
      ,[project_key]
  FROM [jiradb].[jiraschema].[project_key] for xml path('row'), root ('PROJECT_KEY')

Code Block
SELECT [id] ,[issuenum] ,[project] FROM [jiradb].[jiraschema].[jiraissue] for xml path('row'), root ('JIRAISSUE')

Code Block

language	sql

SELECT [id]
      ,[pname]
  FROM [jiradb].[jiraschema].[issuestatus] for xml path('row'), root ('ISSUESTATUS')

Code Block

language	sql

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')

Code Block

language	sql

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

Code Block

language	sql

SELECT CASE WHEN [ASSIGNEE_ENABLED] = 1 then 't' else 'f' end as ASSIGNEE_ENABLED
      ,COALESCE(CAST([CONDITIONAL_RULE_ID] as nvarchar(100)), '') as CONDITIONAL_RULE_ID
      ,[CONFIG_ID]
      ,[DESCRIPTION]
      ,[GROUPS]
      ,ISNULL([GROUP_PICKER],'') as GROUP_PICKER
      ,[ID]
      ,[NAME]
      ,CASE when [NOT_ASSIGNEE] = 1 then 't' else 'f' end as NOT_ASSIGNEE
      ,CASE when [NOT_GROUPS] = 1 then 't' else 'f' end as NOT_GROUPS
      ,CASE when [NOT_GROUP_PICKER] = 1 then 't' else 'f' end as NOT_GROUP_PICKER
      ,CASE when [NOT_LEAD] = 1 then 't' else 'f' end as NOT_LEAD
      ,CASE when [NOT_REPORTER] = 1 then 't' else 'f' end as NOT_REPORTER
      ,CASE when [NOT_ROLES] = 1 then 't' else 'f' end as NOT_ROLES
      ,CASE when [NOT_USERS] = 1 then 't' else 'f' end as NOT_USERS
      ,CASE when [NOT_USER_PICKER] = 1 then 't' else 'f' end as NOT_USER_PICKER
      ,CASE when [NOT_USER_PICKER_ANY] = 1 then 't' else 'f' end as NOT_USER_PICKER_ANY
      ,ISNULL([OPERATOR],'') as OPERATOR
      ,CASE when [PROJECT_LEAD_ENABLED] =1 then 't' else 'f' end as PROJECT_LEAD_ENABLED
      ,CASE when [REPORTER_ENABLED] =1 then 't' else 'f' end as REPORTER_ENABLED
      ,[ROLES]
      ,CASE when [SA] =1 then 't' else 'f' end as SA
      ,[SHOW_TYPE]
      ,[USERS]
      ,ISNULL([USER_PICKER],'') as USER_PICKER
      ,ISNULL ([USER_PICKER_ALL_EXPR],'') as  USER_PICKER_ALL_EXPR
      ,ISNULL ([USER_PICKER_ANY],'') as USER_PICKER_ANY
      ,ISNULL ([USER_PICKER_ANY_EXPR],'') as USER_PICKER_ANY_EXPR
	  ,CASE when [EXPR_IN_DETAIL] = 1 then 't' else 'f' end as EXPR_IN_DETAIL
  FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL]
  FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL')

Code Block

language	sql

SELECT [DESCRIPTION]
      ,[ID]
      ,[PROPERTY]
      ,[VALUE]
  FROM [jiradb].[jiraschema].[AO_D195E9_CONFIG_PROPERTIES]
  FOR XML PATH('row'), ROOT ('AO_D195E9_CONFIG_PROPERTIES')

Code Block

language	sql

SELECT CASE when [ABSTAIN_ACTION_ENABLED] = 1 then 't' else 'f' end as ABSTAIN_ACTION_ENABLED
      ,ISNULL([APPROVAL_TAG],'') as APPROVAL_TAG
      ,CASE when [APP_COND_WF_UPDATABLE] = 1 then 't' else 'f' end as APP_COND_WF_UPDATABLE
      ,ISNULL([APP_PANEL_FILTER],'') as APP_PANEL_FILTER
      ,CASE when [AUTO_GRANT_PERM] = 1 then 't' else 'f' end as AUTO_GRANT_PERM
      ,CASE when [AWT_CMRA] = 1 then 't' else 'f' end as AWT_CMRA
      ,ISNULL([CHECK_INFO],'') as CHECK_INFO
      ,ISNULL([CUSTOM_COMMENT],'') as CUSTOM_COMMENT
      ,CASE when [CUSTOM_DEFINE_APPROVAL]=1 then 't' else 'f' end as CUSTOM_DEFINE_APPROVAL
      ,CASE when [CUSTOM_REQUESTER_APPROVAL]=1 then 't' else 'f' end as CUSTOM_REQUESTER_APPROVAL
      ,CASE when [DELEGATION_ENABLED]=1 then 't' else 'f' end as DELEGATION_ENABLED
      ,CASE when [ENABLED_NAC]=1 then 't' else 'f' end as ENABLED_NAC
      ,CASE when [EXPANED_APP_PANEL] =1 then 't' else 'f' end as EXPANED_APP_PANEL
      ,ISNULL([FROM_EMAIL],'') as FROM_EMAIL
      ,CASE when [HIDE_HACTION_ABSTAINED] =1 then 't' else 'f' end as HIDE_HACTION_ABSTAINED
      ,CASE when [HIDE_HACTION_APPROVED] =1 then 't' else 'f' end as HIDE_HACTION_APPROVED
      ,CASE when [HIDE_HACTION_APP_NOTIFY] =1 then 't' else 'f' end as HIDE_HACTION_APP_NOTIFY
      ,CASE when [HIDE_HACTION_AUNOTIFY] = 1 then 't' else 'f' end as HIDE_HACTION_AUNOTIFY
      ,CASE when [HIDE_HACTION_AUTRANS] = 1 then 't' else 'f' end as HIDE_HACTION_AUTRANS
      ,CASE when [HIDE_HACTION_COMMENT] = 1 then 't' else 'f' end as HIDE_HACTION_COMMENT
      ,CASE when [HIDE_HACTION_NPENDING] = 1 then 't' else 'f' end as HIDE_HACTION_NPENDING
      ,CASE when [HIDE_HACTION_PENDING] = 1 then 't' else 'f' end as HIDE_HACTION_PENDING
      ,CASE when [HIDE_HACTION_REJECTED] = 1 then 't' else 'f' end as HIDE_HACTION_REJECTED
      ,CASE when [HIDE_HACTION_REPLY_NOTIFY] =1 then 't' else 'f' end as HIDE_HACTION_REPLY_NOTIFY
      ,CASE when [HIDE_HACTION_SING_NOTIFY] =1 then 't' else 'f' end as HIDE_HACTION_SING_NOTIFY
      ,CASE when [HIDE_HISTORY_ACTION] =1 then 't' else 'f' end as HIDE_HISTORY_ACTION
      ,CASE when [HIDE_HISTORY_APPROVAL] =1 then 't' else 'f' end as HIDE_HISTORY_APPROVAL
      ,CASE when [HIDE_HISTORY_APPROVER_C] =1 then 't' else 'f' end as HIDE_HISTORY_APPROVER_C
      ,CASE when [HIDE_HISTORY_DESTINATION_S] =1 then 't' else 'f' end as HIDE_HISTORY_DESTINATION_S
      ,CASE when [HIDE_HISTORY_SOURCE_S] =1 then 't' else 'f' end as HIDE_HISTORY_SOURCE_S
      ,CASE when [HIDE_HISTORY_TRANS] =1 then 't' else 'f' end as HIDE_HISTORY_TRANS
      ,CASE when [HIDE_MENU] =1 then 't' else 'f' end as HIDE_MENU
      ,CASE when [HIDE_PACOMMENT] =1 then 't' else 'f' end as HIDE_PACOMMENT
      ,CASE when [HIDE_PACTION] =1 then 't' else 'f' end as HIDE_PACTION
      ,CASE when [HIDE_PAPP_NAME] =1 then 't' else 'f' end as HIDE_PAPP_NAME
      ,CASE when [HIDE_PDETAIL] =1 then 't' else 'f' end as HIDE_PDETAIL
      ,CASE when [HIDE_PREQUEST_NOTIF] =1 then 't' else 'f' end as HIDE_PREQUEST_NOTIF
      ,ISNULL([HISTORY_COLUMN_TITLES],'') as HISTORY_COLUMN_TITLES
      ,CASE when [HISTORY_EXPAND_ROWS] =1 then 't' else 'f' end as HISTORY_EXPAND_ROWS
      ,ISNULL([HISTORY_FILTER],'') as HISTORY_FILTER
      ,ISNULL([HISTORY_GROUP_BY],'') as HISTORY_GROUP_BY
      ,[ID]
      ,ISNULL([LABEL_ABSTAIN_BUTTON],'') as LABEL_ABSTAIN_BUTTON
      ,ISNULL([LABEL_ACTION_APPROVAL],'') as LABEL_ACTION_APPROVAL
      ,ISNULL([LABEL_APPROVAL_BUTTON],'') as LABEL_APPROVAL_BUTTON
      ,ISNULL([LABEL_APPROVAL_NAME],'') as LABEL_APPROVAL_NAME
      ,ISNULL([LABEL_APP_COMMENT],'') as LABEL_APP_COMMENT
      ,ISNULL([LABEL_DETAIL],'') as LABEL_DETAIL
      ,ISNULL([LABEL_HISTORY_ACTION],'') as LABEL_HISTORY_ACTION
      ,ISNULL([LABEL_HISTORY_APPROVAL],'') as LABEL_HISTORY_APPROVAL
      ,ISNULL([LABEL_HISTORY_APPROVER_C],'') as LABEL_HISTORY_APPROVER_C
      ,ISNULL([LABEL_HISTORY_DESTINATION_S],'') as LABEL_HISTORY_DESTINATION_S
      ,ISNULL([LABEL_HISTORY_SOURCE_S],'') as LABEL_HISTORY_SOURCE_S
      ,ISNULL([LABEL_HISTORY_TRANS],'') as LABEL_HISTORY_TRANS
      ,ISNULL([LABEL_REJECT_BUTTON],'') as LABEL_REJECT_BUTTON
      ,ISNULL([LABEL_REQUEST_APPROVAL],'') as LABEL_REQUEST_APPROVAL
      ,ISNULL([LABEL_REQUEST_APPROVALS],'') as LABEL_REQUEST_APPROVALS
      ,ISNULL([LABEL_REQUEST_NOTIFY],'')as LABEL_REQUEST_NOTIFY
      ,ISNULL([LABEL_RESET_BUTTON],'') as LABEL_RESET_BUTTON
      ,ISNULL([LARGE_BUTTONS],'') as LARGE_BUTTON
      ,CASE when [LOCK_ACTION_ENABLED] =1 then 't' else 'f' end as LOCK_ACTION_ENABLED
      ,CASE when [NOTIFICATION_RECIPIENT_CUSTOM] =1 then 't' else 'f' end as NOTIFICATION_RECIPIENT_CUSTOM
      ,CASE when [RESPONSIVE_AWT] =1 then 't' else 'f' end as RESPONSIVE_AWT
      ,CASE when [TAB_COMM_DISABLED] =1 then 't' else 'f' end as TAB_COMM_DISABLED
      ,CASE when [TAB_HISTORY_ENABLED] =1 then 't' else 'f' end as TAB_HISTORY_ENABLED
      ,ISNULL([USER_APPROVER_BULK],'') as USER_APPROVER_BULK
      ,ISNULL([USER_AWT],'') as USER_AWT
      ,ISNULL([USER_COND_RULE],'') as USER_COND_RULE
      ,ISNULL([USER_LARGE_BUTTONS],'') as USER_LARGE_BUTTONS
      ,ISNULL([USER_NOTIFY_NAC],'') as USER_NOTIFY_NAC
      ,CASE when [VIEW_WORKFLOW] =1 then 't' else 'f' end as VIEW_WORKFLOW
  FROM [jiradb].[jiraschema].[AO_D195E9_CONFIG]
  FOR XML PATH('row'), ROOT ('AO_D195E9_CONFIG')

Code Block

language	sql

SELECT [CONDITIONAL_NAME]
      ,[CONDITIONAL_RULE]
      ,[ID]
      ,[USER_EVALUATOR]
  FROM [jiradb].[jiraschema].[AO_D195E9_CONDITIONAL_RULE]
  FOR XML PATH('row'), ROOT ('AO_D195E9_CONDITIONAL_RULE')

Code Block

language	sql

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')

Code Block

language	sql

SELECT [ID]
      ,[RECIPIENT]
      ,[TYPE]
  FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_NOT_NOTIFY]
  FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_NOT_NOTIFY')

Code Block

language	sql

SELECT [DESCRIPTION]
      ,[ID]
      ,[NAME]
  FROM [jiradb].[jiraschema].[AO_D195E9_NTF_SCHEME]
  FOR XML PATH('row'), ROOT ('AO_D195E9_NTF_SCHEME')

Code Block

language	sql

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')

Code Block

language	sql

SELECT [ID]
	  ,[EVENTS]
      ,[RECIPIENT]
      ,[TYPE]
  FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_RECIPIENTS]
  FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_RECIPIENTS')

Code Block

language	sql

SELECT [ID]
      ,[PROJECT_ID]
      ,[REQUESTER_TYPE]
  FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_PROJECTS]
  FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_PROJECTS')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

SELECT [ID]
      ,[ITEM]
      ,[TYPE]
  FROM [jiradb].[jiraschema].[AO_D195E9_APPROVAL_MENU_PERM]
  FOR XML PATH('row'), ROOT ('AO_D195E9_APPROVAL_MENU_PERM')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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')

Code Block

language	sql

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.

In this section

Table of Contents

Need support?

We would love to help.

✉ Submit a support request

Versions Compared

Old Version 11

New Version 12

Key

Overview

Backup File

Page Comparison

Versions Compared

Old Version 11

New Version 12

Key

Overview

Backup File