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, MySQL 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

/*Attached is the file with the queries for PostgreSQL
Please check each of the comments to make sure the query works.
Run each of the queries shown below and save them in a single XML file.*/

/*Place all the result of this query between <CWD_USER></CWD_USER> tags*/

SELECT
	concat ( '<row>', '<id>', ID, '</id>', '<user_name>', user_name, '</user_name>', '

<pname>

<email_address>',

pname

email_address, '</

pname>

email_address>', '</row>' )

data_xml

FROM
	PUBLIC.

issuetype

cwd_user

)

AS

/*Place

RESULT

all

UNION

the result of this query between <ISSUETYPE></ISSUETYPE> tags*/

SELECT
	concat (

'<PROJECT_KEY>', STRING_AGG ( RESULT.data_xml, '

'<row>','<id>',ID,'</id>','<pname>',REPLACE ( REPLACE ( REPLACE ( pname, '&', '&amp;' ), '<

/PROJECT_KEY>

', '&lt;' ),

3 AS FILTER

'>', '&lt;' ),'</pname>','</row>') 
FROM

(

PUBLIC.issuetype

/*Place all the result of this query between <PROJECT_KEY></PROJECT_KEY> tags*/

SELECT concat ( '<row>', '<project_id>', project_id, '</project_id>', '<project_key>', project_key, '</project_key>', '</row>' )

data_xml

 FROM PUBLIC.project_key

)

AS

/*Place

RESULT

all

UNION

the

SELECT

result

concat

of

( '<JIRAISSUE>', STRING_AGG ( RESULT.data_xml, '' ), '</JIRAISSUE>' ), 4 AS FILTER FROM ( SELECT

this query between <JIRAISSUE></JIRAISSUE> tags*/

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

/*Place all the result of this query between <ISSUESTATUS></ISSUESTATUS> tags*/

SELECT
	concat ( '<row>', '<id>', ID, '</id>', '<pname>', REPLACE(REPLACE (REPLACE ( pname, '

</pname>

&', '

</row>

&amp;' )

data_xml FROM PUBLIC.issuestatus ) AS RESULT UNION SELECT concat ( '<CUSTOMFIELD>', STRING_AGG ( RESULT.data_xml, '' )

, '<', '&lt;'),'>','&lt;') , '</pname>', '</

CUSTOMFIELD>

row>' )

, 6 AS FILTER FROM ( SELECT

 
FROM
	PUBLIC.issuestatus

/*Place all the result of this query between <CUSTOMFIELD></CUSTOMFIELD> tags*/

SELECT
	CONCAT ( '<row>', '<id>', ID, '</id>', '<cfname>',

"cfname"

REPLACE(REPLACE (REPLACE ( cfname, '&', '&amp;' ), '<', '&lt;'),'>','&lt;') , '</cfname>', '</row>' )

data_xml

FROM

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 all the results

) AS RESULT UNION

of this query between <WORKFLOWS></WORKFLOWS> tags*/

SELECT
	concat ( '<WORKFLOWS>', STRING_AGG ( RESULT.data_xml, '' ), '</WORKFLOWS>' ),
	7 AS FILTER 
FROM
	(
	SELECT
		CONCAT ( '<action ', REPLACE ( removeText.RESULT, '&', '&amp;' ), '</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, '' ), '<

/*Place all the result of this query between <AO_D195E9_APPROVAL></AO_D195E9_APPROVAL>

' ), 8 AS FILTER FROM (

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

REPLACE ( REPLACE ( REPLACE ( "DESCRIPTION",

'&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
	'</DESCRIPTION>',

'<GROUPS>',

"GROUPS",

'</GROUPS>',

'<GROUP_PICKER>',

"GROUP_PICKER",

'</GROUP_PICKER>',

'<ID>',

"ID",

'</ID>',

'<NAME>',

"NAME",

REPLACE ( REPLACE ( REPLACE ( "NAME", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
	'</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>',

REPLACE ( REPLACE ( REPLACE ( "USER_PICKER_ALL_EXPR", '&', '&amp;' ), '<', '&lt;' ), '>',

'&lt;' ),
	'</USER_PICKER_ALL_EXPR>',

'<USER_PICKER_ANY>',

	"USER_PICKER_ANY",

	'</USER_PICKER_ANY>',

'<USER_PICKER_ANY_EXPR>',

REPLACE ( REPLACE ( REPLACE ( "USER_PICKER_ANY_EXPR",

'<

'&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
	'</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 ( '

/*Place all the result of this query between <AO_D195E9_CONFIG_

PROPERTIES>', STRING_AGG ( RESULT.data_xml, '' ), '<

PROPERTIES></AO_D195E9_CONFIG_PROPERTIES>

' ), 9 AS FILTER FROM ( SELECT CONCAT ( '<row>',

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

) AS RESULT UNION SELECT concat ( '<AO_D195E9_CONFIG>', STRING_AGG ( RESULT.data_xml, '' ), '<

/*Place all the result of this query between <AO_D195E9_CONFIG></AO_D195E9_CONFIG>

' ), 10 AS FILTER FROM (

 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_

DEFINE_APPROVAL>

COMMENT>',

"CUSTOM_DEFINE_

COALESCE ( REPLACE ( REPLACE ( REPLACE ( "CUSTOM_COMMENT", '&', '&amp;' ), '<', '&lt;' ), '>', '&gt;' ), '' ),
		'</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"

) AS RESULT UNION SELECT concat ( '

/*Place all the result of this query between <AO_D195E9_CONDITIONAL_

RULE>', STRING_AGG ( RESULT.data_xml, '' ), '<

RULE></AO_D195E9_CONDITIONAL_RULE>

'

), 11 AS FILTER FROM (

tags*/

SELECT
		CONCAT (
			'<row>',
			'<CONDITIONAL_NAME>',
			REPLACE ( REPLACE ( REPLACE ( "CONDITIONAL_NAME",

'</CONDITIONAL_NAME>

'&',

'<CONDITIONAL_RULE>', "CONDITIONAL_RULE",

'&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</CONDITIONAL_NAME>',
			'<CONDITIONAL_RULE>',
			REPLACE ( REPLACE ( REPLACE ( "CONDITIONAL_RULE", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</CONDITIONAL_RULE>',
			'<ID>',
			"ID",
			'</ID>',
			'<USER_EVALUATOR>',
			"USER_EVALUATOR",
			'</USER_EVALUATOR>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_CONDITIONAL_RULE" 


/*Place

)

all

AS

the

RESULT

result

UNION

of

SELECT

this

concat

query

(

between

'

<AO_D195E9_CUSTOM_MAIL_TEMPLATE></AO_D195E9_CUSTOM_MAIL_TEMPLATE>

', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_CUSTOM_MAIL_TEMPLATE>' ), 12 AS FILTER FROM (

 tags*/

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



	/*Place all the result of this query between <AO_D195E9_APPROVAL_NOT_

NOTIFY>', STRING_AGG ( RESULT.data_xml, '' ), '<

NOTIFY></AO_D195E9_APPROVAL_NOT_NOTIFY>

' ), 13 AS FILTER FROM (

 tags*/

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_

/*Place all the result of this query between <AO_D195E9_NTF_SCHEME></AO_D195E9_NTF_SCHEME>

', STRING_AGG

 tags*/

SELECT
		CONCAT (

RESULT.data_xml

'<row>', '<ID>',

)

"ID", '</

AO_D195E9_NTF_SCHEME>' ), 14 AS FILTER FROM ( SELECT CONCAT ( '<row>', '<ID>', "ID"

ID>', '<DESCRIPTION>', REPLACE ( REPLACE ( REPLACE ( "DESCRIPTION", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ), '</

ID>

DESCRIPTION>', '

<NAME>', REPLACE ( REPLACE

"DESCRIPTION"

( REPLACE ( "NAME", '&', '

</DESCRIPTION>'

&amp;' ), '<', '&lt;' ), '

<NAME>

>',

"NAME"

 '&lt;' ), '</NAME>', '</row>' ) data_xml 
	FROM
		PUBLIC."AO_D195E9_NTF_SCHEME"

) AS RESULT UNION SELECT concat ( '

/*Place all the result of this query between <AO_D195E9_NTF_SCHEME_

DETAIL>', STRING_AGG ( RESULT.data_xml, '' ), '<

DETAIL></AO_D195E9_NTF_SCHEME_DETAIL>

'

), 15 AS FILTER FROM (

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>',
			REPLACE ( REPLACE ( REPLACE ( "NOTIFY_EXPRESSION", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</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 ( '

/*Place all the result of this query between <AO_D195E9_APPROVAL_

RECIPIENTS>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_RECIPIENTS>' ), 16 AS FILTER FROM (

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"

) AS RESULT UNION SELECT concat ( '


/*Place all the result of this query between <AO_D195E9_APPROVAL_

PROJECTS>', STRING_AGG ( RESULT.data_xml, '' ), '<

PROJECTS></AO_D195E9_APPROVAL_PROJECTS>

' ), 17 AS FILTER FROM (

 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"

) AS RESULT UNION SELECT concat ( '<AO_

/*Place all the result of this query between <AO_D195E9_APPROVAL_REQUESTERS></AO_D195E9_APPROVAL_REQUESTERS>

', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_REQUESTERS>' ), 18 AS FILTER FROM (

 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" 
	WHERE
		"TYPE" != 'NOTYPE'

) AS RESULT UNION SELECT concat ( '


/*Place all the result of this query between <AO_D195E9_APPROVAL_

DEFINERS>', STRING_AGG ( RESULT.data_xml, '' ), '<

DEFINERS></AO_D195E9_APPROVAL_DEFINERS>

' ), 19 AS FILTER FROM (

 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"

) AS RESULT UNION SELECT concat ( '<AO_



/*Place all the result of this query between <AO_D195E9_APPROVAL_MENU_PERM></AO_D195E9_APPROVAL_MENU_PERM>

', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MENU_PERM>' ), 20 AS FILTER FROM (

 tags*/

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


/*Place all the result of this query between <AO_D195E9_APPROVAL_

MAPPING>', STRING_AGG ( RESULT.data_xml, '' ), '<

MAPPING></AO_D195E9_APPROVAL_MAPPING>

' ), 21 AS FILTER FROM (

 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"

) AS RESULT UNION SELECT concat ( '

/*Place all the result of this query between <AO_D195E9_APPROVAL_MAPPING

_REL>', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_

_REL></AO_D195E9_APPROVAL_MAPPING_REL>

'

), 22 AS FILTER FROM (

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"

) AS RESULT UNION SELECT concat ( '

/*Place all the result of this query between <AO_D195E9_ISSUE_

APPROVAL>', STRING_AGG ( RESULT.data_xml, '' ), '<

APPROVAL></AO_D195E9_ISSUE_APPROVAL>

' ), 23 AS FILTER FROM (

 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'

) AS RESULT UNION SELECT concat ( '<AO

/*Place all the result of this query between <AO_D195E9_APPROVAL_MRA></AO_D195E9_APPROVAL_MRA>

', STRING_AGG ( RESULT.data_xml, '' ), '</AO_D195E9_APPROVAL_MRA>' ), 24 AS FILTER FROM (

 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"

) AS RESULT UNION SELECT concat ( '

/*Place all the result of this query between <AO_D195E9_APPROVAL_

HISTORY>', STRING_AGG ( RESULT.data_xml, '' ), '<

HISTORY></AO_D195E9_APPROVAL_HISTORY>

' ), 25 AS FILTER FROM (

 tags*/

SELECT
		CONCAT (
			'<row>',
			'<ACTION>',
			"ACTION",
			'</ACTION>',
			'<APPROVAL_COMMENT>',
			REPLACE ( REPLACE ( REPLACE ( "APPROVAL_COMMENT",

'</APPROVAL_COMMENT>

'&',

'<APPROVAL_DETAIL>', "APPROVAL_DETAIL"

'&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</APPROVAL_

DETAIL>

COMMENT>',
			'<APPROVAL_

NAME>

DETAIL>',
			REPLACE ( REPLACE ( REPLACE ( "APPROVAL_

NAME

DETAIL",

'</APPROVAL_NAME>

'&',

'<COMMENT>', "COMMENT", '</COMMENT>', '<DATE>', "DATE", '</DATE>', '<DELEGATOR_KEY>', "DELEGATOR_KEY"

'&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

DELEGATOR

APPROVAL_

KEY>

DETAIL>',
			'

<DESTINATION

<APPROVAL_

STATUS>

NAME>',

"DESTINATION_STATUS

REPLACE ( REPLACE ( REPLACE ( "APPROVAL_NAME",

'</DESTINATION_STATUS>

'&',

'<EXECUTOR>', "EXECUTOR", '</EXECUTOR>', '<EXECUTOR_KEY>', "EXECUTOR_KEY"

'&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

EXECUTOR

APPROVAL_

KEY>

NAME>',
			'

<ID>

<COMMENT>',

"ID", '</ID>', '<ISSUE_ID>', "ISSUE_ID"

REPLACE ( REPLACE ( REPLACE ( "COMMENT", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

ISSUE_ID>

COMMENT>',
			'

<NOTIFICATION_DATE>

<DATE>',
			"

NOTIFICATION_

DATE",
			'</

NOTIFICATION_

DATE>',
			'

<SOURCE

<DELEGATOR_

STATUS>

KEY>',
			"

SOURCE

DELEGATOR_

STATUS

KEY",
			'</

SOURCE

DELEGATOR_

STATUS>

KEY>',
			'

<SUBMITTED

<DESTINATION_

DATE>

STATUS>',

"SUBMITTED_DATE",

REPLACE ( REPLACE ( REPLACE ( "DESTINATION_STATUS", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

SUBMITTED

DESTINATION_

DATE>

STATUS>',
			'

<TRANSITION_NAME>

<EXECUTOR>',
			"

TRANSITION_NAME

EXECUTOR",
			'</

TRANSITION_NAME>

EXECUTOR>',
			'<EXECUTOR_KEY>',
			"EXECUTOR_KEY",
			'</

row>

EXECUTOR_KEY>',

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

'<ID>',
			"ID",
			'</ID>',
			'<ISSUE_ID>',
			"ISSUE_ID",
			'</ISSUE_ID>',
			'

<DELEGATED

<NOTIFICATION_

KEY>

DATE>',
			"

DELEGATED

NOTIFICATION_

KEY

DATE",
			'</

DELEGATED

NOTIFICATION_

KEY>

DATE>',
			'

<DELEGATOR

<SOURCE_

KEY>

STATUS>',

"DELEGATOR_KEY",

REPLACE ( REPLACE ( REPLACE ( "SOURCE_STATUS", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

DELEGATOR

SOURCE_

KEY>

STATUS>',
			'

<END

<SUBMITTED_DATE>',
			"

END

SUBMITTED_DATE",
			'</

END

SUBMITTED_DATE>',
			'

<ID>

<TRANSITION_NAME>',

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

REPLACE ( REPLACE ( REPLACE ( "TRANSITION_NAME", '&', '&amp;' ), '<', '&lt;' ), '>', '&lt;' ),
			'</

START

TRANSITION_

DATE>

NAME>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_APPROVAL_

DELEGATED

HISTORY"

)

/*Place

AS

all

RESULT

the result

UNION

of

SELECT

this

concat

query

(

between

'

<AO_D195E9_

LANGUAGE_PACK>', STRING_AGG ( RESULT.data_xml, '' ), '<

APPROVAL_DELEGATED></AO_D195E9_

LANGUAGE_PACK>' ), 27 AS FILTER FROM (

APPROVAL_DELEGATED>*/

SELECT
		CONCAT (
			'<row>',
			'

<DELEGATED_KEY>',
			"

DESCRIPTION

DELEGATED_KEY",
			'</

DESCRIPTION>

DELEGATED_KEY>',
			'

<DELEGATOR_KEY>',
			"

ENABLED

DELEGATOR_KEY",
			'</

ENABLED>

DELEGATOR_KEY>',
			'

<ID>

<END_DATE>',
			"

ID

END_DATE",
			'</

ID>

END_DATE>',
			'

<ID>',
			"

LOCALE

ID",
			'</

LOCALE>

ID>',
			'

<MODIFIED

<ISSUE_TYPE_

DATE>

ID>',
			"

MODIFIED

ISSUE_TYPE_

DATE

ID",
			'</

MODIFIED

ISSUE_TYPE_

DATE>

ID>',
			'

<MODIFIED

<PROJECT_

USER>

ID>',
			"

MODIFIED

PROJECT_

USER

ID",
			'</

MODIFIED

PROJECT_

USER>

ID>',
			'

<NAME>

<SEND_APPROVAL_REQUESTS>',
			"

NAME

SEND_APPROVAL_REQUESTS",
			'</

NAME>

SEND_APPROVAL_REQUESTS>',
			'<START_DATE>',
			"START_DATE",
			'</START_DATE>',
			'</row>' 
		) data_xml 
	FROM
		PUBLIC."AO_D195E9_

LANGUAGE

APPROVAL_

PACK

DELEGATED"

) 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

Expand

title	Queries for MySQL

Code Block

/*Attached is the file with the queries for SQL Server
Please check each of the comments to make sure the query works.
Run each of the queries shown below and save them in a single XML file.*/

/*Place all the result of this query between <CWD_USER></CWD_USER> tags*/

SELECT
	concat ( '<row>', '<id>', ID, '</id>', '<user_name>', user_name, '</user_name>', '<email_address>', email_address, '</email_address>', '</row>' )
FROM
	cwd_user



/*Place all the result of this query between <ISSUETYPE></ISSUETYPE> tags*/

SELECT concat ( '<row>', '<id>', ID, '</id>', '<pname>', pname, '</pname>', '</row>' ) FROM issuetype 

/*Place all the result of this query between <PROJECT_KEY></PROJECT_KEY> tags*/

SELECT concat ( '<row>', '<project_id>', project_id, '</project_id>', '<project_key>', project_key, '</project_key>', '</row>' )  FROM project_key 

/*Place all the result of this query between <JIRAISSUE></JIRAISSUE> tags*/

SELECT
	concat ( '<row>', '<id>', ID, '</id>', '<issuenum>', issuenum, '</issuenum>', '<project>', project, '</project>', '</row>' ) 
FROM
	jiraissue

/*Place all the result of this query between <ISSUESTATUS></ISSUESTATUS> tags*/

SELECT
	concat ( '<row>', '<id>', ID, '</id>', '<pname>', REPLACE(REPLACE (REPLACE ( pname, '&', '&amp;' ), '<', '&lt;'),'>','&lt;') , '</pname>', '</row>' ) 
FROM
	issuestatus 

/*Place all the result of this query between <CUSTOMFIELD></CUSTOMFIELD> tags*/

SELECT
	CONCAT ( '<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 all the results of this query between <WORKFLOWS></WORKFLOWS> tags*/
/*<WORKFLOWS>
<action...></action>
.
..
.
<action...></action>
</WORKFLOWS>*/
/*Omit null results*/

WITH RECURSIVE cte ( text, spos, epos ) AS (
	SELECT
		DESCRIPTOR,
		1,
		INSTR( DESCRIPTOR, ' <action ' ) 
	FROM
		JIRAWORKFLOWS UNION ALL
	SELECT
		text,
		epos + 9,
		LOCATE (' <action ', text, epos +9 ) 
	FROM
		cte 
	WHERE
		epos > 0 
	
	) SELECT CASE epos
       WHEN 0
       THEN 
				CASE
					WHEN INSTR(SUBSTR(SUBSTR(text, spos),1, INSTR(SUBSTR(text, spos),'>')),'name')>0
					THEN CONCAT('<action ',SUBSTR(SUBSTR(text, spos),1, INSTR(SUBSTR(text, spos),'>')),'</action>')
				END 
       ELSE
				CASE
					WHEN INSTR(SUBSTR(SUBSTR(text, spos, epos - spos),1, INSTR(SUBSTR(text, spos),'>')),'name')>0
					THEN  CONCAT('<action ',SUBSTR(SUBSTR(text, spos, epos - spos),1, INSTR(SUBSTR(text, spos),'>')),'</action>')
				END
       END AS action
FROM   cte	


/*Place all the result of this query between <AO_D195E9_APPROVAL></AO_D195E9_APPROVAL> tags*/

SELECT
	CONCAT('<row>' , '<ASSIGNEE_ENABLED>' , CASE WHEN ASSIGNEE_ENABLED = 0 THEN 'f' ELSE 't' END , '</ASSIGNEE_ENABLED>' ,
	'<CONDITIONAL_RULE_ID>' , COALESCE(CONDITIONAL_RULE_ID,'') , '</CONDITIONAL_RULE_ID>' ,
	'<CONFIG_ID>' ,  COALESCE(CONFIG_ID,'') , '</CONFIG_ID>' ,
	'<DESCRIPTION>' , COALESCE(DESCRIPTION,'') , '</DESCRIPTION>' ,
	'<GROUPS>' , COALESCE(AO_D195E9_APPROVAL.GROUPS,'') , '</GROUPS>' ,
	'<GROUP_PICKER>' , COALESCE(GROUP_PICKER,'') , '</GROUP_PICKER>' ,
	'<ID>' , ID , '</ID>' , '<NAME>' , NAME , '</NAME>' ,
	'<NOT_ASSIGNEE>' , CASE WHEN NOT_ASSIGNEE = 0 THEN 'f' ELSE 't' END , '</NOT_ASSIGNEE>' ,
	'<NOT_GROUPS>' , CASE WHEN NOT_GROUPS = 0 THEN 'f' ELSE 't' END , '</NOT_GROUPS>' ,
	'<NOT_GROUP_PICKER>' , CASE WHEN NOT_GROUP_PICKER = 0 THEN 'f' ELSE 't' END , '</NOT_GROUP_PICKER>' ,
	'<NOT_LEAD>' , CASE WHEN NOT_LEAD = 0 THEN 'f' ELSE 't' END , '</NOT_LEAD>' ,
	'<NOT_REPORTER>' , CASE WHEN NOT_REPORTER = 0 THEN 'f' ELSE 't' END , '</NOT_REPORTER>' ,
	'<NOT_ROLES>' , CASE WHEN NOT_ROLES = 0 THEN 'f' ELSE 't' END , '</NOT_ROLES>' ,
	'<NOT_USERS>' , CASE WHEN NOT_USERS = 0 THEN 'f' ELSE 't' END , '</NOT_USERS>' ,
	'<NOT_USER_PICKER>' , CASE WHEN NOT_USER_PICKER = 0 THEN 'f' ELSE 't' END , '</NOT_USER_PICKER>' ,
	'<NOT_USER_PICKER_ANY>' , CASE WHEN NOT_USER_PICKER_ANY = 0 THEN 'f' ELSE 't' END , '</NOT_USER_PICKER_ANY>' ,
	'<OPERATOR>' , COALESCE(OPERATOR,'') , '</OPERATOR>' ,
	'<PROJECT_LEAD_ENABLED>' , CASE WHEN PROJECT_LEAD_ENABLED = 0 THEN 'f' ELSE 't' END , '</PROJECT_LEAD_ENABLED>' ,
	'<REPORTER_ENABLED>' , CASE WHEN REPORTER_ENABLED = 0 THEN 'f' ELSE 't' END , '</REPORTER_ENABLED>' ,
	'<ROLES>' , COALESCE(ROLES,'') , '</ROLES>' ,
	'<SA>' , CASE WHEN SA = 0 THEN 'f' ELSE 't' END , '</SA>' ,
	'<SHOW_TYPE>' , CASE WHEN COALESCE(SHOW_TYPE,'') = 0 THEN 'f' else 't'END , '</SHOW_TYPE>' ,
	'<USERS>' , REPLACE ( USERS, '&', '&amp;' ) , '</USERS>' ,
	'<USER_PICKER>' , COALESCE(USER_PICKER,'') , '</USER_PICKER>' ,
	'<USER_PICKER_ALL_EXPR>' , COALESCE(USER_PICKER_ALL_EXPR,'')  , '</USER_PICKER_ALL_EXPR>' ,
	'<USER_PICKER_ANY>' , COALESCE(USER_PICKER_ANY,'') , '</USER_PICKER_ANY>' ,
	'<USER_PICKER_ANY_EXPR>' , COALESCE(USER_PICKER_ANY_EXPR,'') , '</USER_PICKER_ANY_EXPR>' ,
	'<EXPR_IN_DETAIL>' , CASE WHEN EXPR_IN_DETAIL = 0 THEN 'f' ELSE 't'  END , '</EXPR_IN_DETAIL>' ,
	'</row>' )
FROM
	AO_D195E9_APPROVAL

/*Place all the 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 AO_D195E9_CONFIG_PROPERTIES;

/*Place all the result of this query between <AO_D195E9_CONFIG></AO_D195E9_CONFIG> tags*/


	SELECT 
   (
   CONCAT( '<row>',
      '<ABSTAIN_ACTION_ENABLED>', CASE WHEN ABSTAIN_ACTION_ENABLED = 0 THEN 'f' ELSE 't' END , '</ABSTAIN_ACTION_ENABLED>',
        '<APPROVAL_TAG>', COALESCE(APPROVAL_TAG,''), '</APPROVAL_TAG>',
        '<APP_COND_WF_UPDATABLE>', CASE WHEN APP_COND_WF_UPDATABLE = 0 THEN 'f' ELSE 't' END , '</APP_COND_WF_UPDATABLE>',
        '<APP_PANEL_FILTER>', COALESCE(APP_PANEL_FILTER,''), '</APP_PANEL_FILTER>',
        '<AUTO_GRANT_PERM>', CASE WHEN AUTO_GRANT_PERM = 0 THEN 'f' ELSE 't' END , '</AUTO_GRANT_PERM>',
        '<AWT_CMRA>', CASE WHEN AWT_CMRA = 0 THEN 'f' ELSE 't' END , '</AWT_CMRA>',
        '<CHECK_INFO>', COALESCE(CHECK_INFO,''), '</CHECK_INFO>',
        '<CUSTOM_COMMENT>', COALESCE(REPLACE(REPLACE (REPLACE ( CUSTOM_COMMENT, '&', '&amp;' ), '<', '&lt;'),'>','&gt;'),''), '</CUSTOM_COMMENT>',
        '<CUSTOM_DEFINE_APPROVAL>', CASE WHEN CUSTOM_DEFINE_APPROVAL = 0 THEN 'f' ELSE 't' END, '</CUSTOM_DEFINE_APPROVAL>',
        '<CUSTOM_REQUESTER_APPROVAL>', CASE WHEN CUSTOM_REQUESTER_APPROVAL = 0 THEN 'f' ELSE 't' END , '</CUSTOM_REQUESTER_APPROVAL>',
        '<DELEGATION_ENABLED>', CASE WHEN DELEGATION_ENABLED = 0 THEN 'f' ELSE 't' END , '</DELEGATION_ENABLED>',
        '<ENABLED_NAC>', CASE WHEN ENABLED_NAC = 0 THEN 'f' ELSE 't' END , '</ENABLED_NAC>',
        '<EXPANED_APP_PANEL>', CASE WHEN EXPANED_APP_PANEL = 0 THEN 'f' ELSE 't' END , '</EXPANED_APP_PANEL>',
        '<FROM_EMAIL>', COALESCE(FROM_EMAIL,''), '</FROM_EMAIL>',
        '<HIDE_HACTION_ABSTAINED>', CASE WHEN HIDE_HACTION_ABSTAINED = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_ABSTAINED>',
        '<HIDE_HACTION_APPROVED>', CASE WHEN HIDE_HACTION_APPROVED = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_APPROVED>',
        '<HIDE_HACTION_APP_NOTIFY>', CASE WHEN HIDE_HACTION_APP_NOTIFY = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_APP_NOTIFY>',
        '<HIDE_HACTION_AUNOTIFY>', CASE WHEN HIDE_HACTION_AUNOTIFY = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_AUNOTIFY>',
        '<HIDE_HACTION_AUTRANS>', CASE WHEN HIDE_HACTION_AUTRANS = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_AUTRANS>',
        '<HIDE_HACTION_COMMENT>', CASE WHEN HIDE_HACTION_COMMENT = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_COMMENT>',
        '<HIDE_HACTION_NPENDING>', CASE WHEN HIDE_HACTION_NPENDING = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_NPENDING>',
        '<HIDE_HACTION_PENDING>', CASE WHEN HIDE_HACTION_PENDING = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_PENDING>',
        '<HIDE_HACTION_REJECTED>', CASE WHEN HIDE_HACTION_REJECTED = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_REJECTED>',
        '<HIDE_HACTION_REPLY_NOTIFY>', CASE WHEN HIDE_HACTION_REPLY_NOTIFY = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_REPLY_NOTIFY>',
        '<HIDE_HACTION_SING_NOTIFY>', CASE WHEN HIDE_HACTION_SING_NOTIFY = 0 THEN 'f' ELSE 't' END , '</HIDE_HACTION_SING_NOTIFY>',
        '<HIDE_HISTORY_ACTION>', CASE WHEN HIDE_HISTORY_ACTION = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_ACTION>',
        '<HIDE_HISTORY_APPROVAL>', CASE WHEN HIDE_HISTORY_APPROVAL = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_APPROVAL>',
        '<HIDE_HISTORY_APPROVER_C>', CASE WHEN HIDE_HISTORY_APPROVER_C = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_APPROVER_C>',
        '<HIDE_HISTORY_DESTINATION_S>', CASE WHEN HIDE_HISTORY_DESTINATION_S = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_DESTINATION_S>',
        '<HIDE_HISTORY_SOURCE_S>', CASE WHEN HIDE_HISTORY_SOURCE_S = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_SOURCE_S>',
        '<HIDE_HISTORY_TRANS>', CASE WHEN HIDE_HISTORY_TRANS = 0 THEN 'f' ELSE 't' END , '</HIDE_HISTORY_TRANS>',
        '<HIDE_MENU>', CASE WHEN HIDE_MENU = 0 THEN 'f' ELSE 't' END , '</HIDE_MENU>' , 
        '<HIDE_PACOMMENT>', CASE WHEN HIDE_PACOMMENT = 0 THEN 'f' ELSE 't' END , '</HIDE_PACOMMENT>',
        '<HIDE_PACTION>', CASE WHEN HIDE_PACTION = 0 THEN 'f' ELSE 't' END , '</HIDE_PACTION>',
        '<HIDE_PAPP_NAME>', CASE WHEN HIDE_PAPP_NAME = 0 THEN 'f' ELSE 't' END , '</HIDE_PAPP_NAME>',
        '<HIDE_PDETAIL>', CASE WHEN HIDE_PDETAIL = 0 THEN 'f' ELSE 't' END , '</HIDE_PDETAIL>',
        '<HIDE_PREQUEST_NOTIF>', CASE WHEN HIDE_PREQUEST_NOTIF = 0 THEN 'f' ELSE 't' END , '</HIDE_PREQUEST_NOTIF>',
        '<HISTORY_COLUMN_TITLES>', COALESCE(HISTORY_COLUMN_TITLES,''), '</HISTORY_COLUMN_TITLES>',
        '<HISTORY_EXPAND_ROWS>', CASE WHEN HISTORY_EXPAND_ROWS = 0 THEN 'f' ELSE 't' END , '</HISTORY_EXPAND_ROWS>',
        '<HISTORY_FILTER>', COALESCE(HISTORY_FILTER,''), '</HISTORY_FILTER>',
        '<HISTORY_GROUP_BY>', COALESCE(HISTORY_GROUP_BY,''), '</HISTORY_GROUP_BY>',
        '<ID>', ID, '</ID>',
        '<LABEL_ABSTAIN_BUTTON>', COALESCE(LABEL_ABSTAIN_BUTTON,''), '</LABEL_ABSTAIN_BUTTON>',
        '<LABEL_ACTION_APPROVAL>', COALESCE(LABEL_ACTION_APPROVAL,''), '</LABEL_ACTION_APPROVAL>',
        '<LABEL_APPROVAL_BUTTON>', COALESCE(LABEL_APPROVAL_BUTTON,''), '</LABEL_APPROVAL_BUTTON>',
        '<LABEL_APPROVAL_NAME>', COALESCE(LABEL_APPROVAL_NAME,''), '</LABEL_APPROVAL_NAME>',
        '<LABEL_APP_COMMENT>', COALESCE(LABEL_APP_COMMENT,''), '</LABEL_APP_COMMENT>',
        '<LABEL_DETAIL>', COALESCE(LABEL_DETAIL,''), '</LABEL_DETAIL>',
        '<LABEL_HISTORY_ACTION>', COALESCE(LABEL_HISTORY_ACTION,''), '</LABEL_HISTORY_ACTION>',
        '<LABEL_HISTORY_APPROVAL>', COALESCE(LABEL_HISTORY_APPROVAL,''), '</LABEL_HISTORY_APPROVAL>',
        '<LABEL_HISTORY_APPROVER_C>', COALESCE(LABEL_HISTORY_APPROVER_C,''), '</LABEL_HISTORY_APPROVER_C>',
        '<LABEL_HISTORY_DESTINATION_S>', COALESCE(LABEL_HISTORY_DESTINATION_S,''), '</LABEL_HISTORY_DESTINATION_S>',
        '<LABEL_HISTORY_SOURCE_S>', COALESCE(LABEL_HISTORY_SOURCE_S,''), '</LABEL_HISTORY_SOURCE_S>',
        '<LABEL_HISTORY_TRANS>', COALESCE(LABEL_HISTORY_TRANS,''), '</LABEL_HISTORY_TRANS>',
        '<LABEL_REJECT_BUTTON>', COALESCE(LABEL_REJECT_BUTTON,''), '</LABEL_REJECT_BUTTON>',
        '<LABEL_REQUEST_APPROVAL>', COALESCE(LABEL_REQUEST_APPROVAL,''), '</LABEL_REQUEST_APPROVAL>',
        '<LABEL_REQUEST_APPROVALS>', COALESCE(LABEL_REQUEST_APPROVALS,''), '</LABEL_REQUEST_APPROVALS>',
        '<LABEL_REQUEST_NOTIFY>', COALESCE(LABEL_REQUEST_NOTIFY,''), '</LABEL_REQUEST_NOTIFY>',
        '<LABEL_RESET_BUTTON>', COALESCE(LABEL_RESET_BUTTON,''), '</LABEL_RESET_BUTTON>',
        '<LARGE_BUTTONS>', COALESCE(LARGE_BUTTONS,''), '</LARGE_BUTTONS>',
        '<LOCK_ACTION_ENABLED>', CASE WHEN LOCK_ACTION_ENABLED = 0 THEN 'f' ELSE 't' END , '</LOCK_ACTION_ENABLED>',
        '<NOTIFICATION_RECIPIENT_CUSTOM>', CASE WHEN NOTIFICATION_RECIPIENT_CUSTOM = 0 THEN 'f' ELSE 't' END , '</NOTIFICATION_RECIPIENT_CUSTOM>',
        '<RESPONSIVE_AWT>', CASE WHEN RESPONSIVE_AWT = 0 THEN 'f' ELSE 't' END , '</RESPONSIVE_AWT>',
        '<TAB_COMM_DISABLED>', CASE WHEN TAB_COMM_DISABLED = 0 THEN 'f' ELSE 't' END , '</TAB_COMM_DISABLED>' ,
        '<TAB_HISTORY_ENABLED>', CASE WHEN TAB_HISTORY_ENABLED = 0 THEN 'f' ELSE 't' END , '</TAB_HISTORY_ENABLED>',
        '<USER_APPROVER_BULK>', COALESCE(USER_APPROVER_BULK,''), '</USER_APPROVER_BULK>',
        '<USER_AWT>',  COALESCE(USER_AWT,''), '</USER_AWT>',
        '<USER_COND_RULE>',  COALESCE(USER_COND_RULE,''), '</USER_COND_RULE>',
        '<USER_LARGE_BUTTONS>', COALESCE(USER_LARGE_BUTTONS,''), '</USER_LARGE_BUTTONS>',
        '<USER_NOTIFY_NAC>',  COALESCE(USER_NOTIFY_NAC,''), '</USER_NOTIFY_NAC>',
        '<VIEW_WORKFLOW>', CASE WHEN VIEW_WORKFLOW = 0 THEN 'f' ELSE 't' END , '</VIEW_WORKFLOW>',
   '</row>')) data_xml 
	FROM AO_D195E9_CONFIG


	/*Place all the 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 AO_D195E9_CONDITIONAL_RULE;


/*Place all the result of this query between <AO_D195E9_CUSTOM_MAIL_TEMPLATE></AO_D195E9_CUSTOM_MAIL_TEMPLATE> tags*/

SELECT (
   CONCAT ('<row>',
       '<BODY_SECTION>', REPLACE (COALESCE(BODY_SECTION,''), '&', '&amp;'), '</BODY_SECTION>',
       '<BUTTON_LINKS_TYPE>', COALESCE(BUTTON_LINKS_TYPE,''), '</BUTTON_LINKS_TYPE>',
       '<BUTTON_TEXTS>', COALESCE(BUTTON_TEXTS,''), '</BUTTON_TEXTS>',
       '<COMMENT_ENABLED>', CASE WHEN COMMENT_ENABLED = 0 THEN 'f' ELSE 't' END , '</COMMENT_ENABLED>',
		'<COMMENT_ENABLED_IF_REQUIRED>', CASE WHEN COMMENT_ENABLED_IF_REQUIRED = 0 THEN 'f' ELSE 't' END , '</COMMENT_ENABLED_IF_REQUIRED>',
		'<CONDITIONAL_RULE_ID>',  COALESCE(CONDITIONAL_RULE_ID,''), '</CONDITIONAL_RULE_ID>',
		'<CONDITION_ENABLING_TEMPLATE_ID>', COALESCE(CONDITION_ENABLING_TEMPLATE_ID,''), '</CONDITION_ENABLING_TEMPLATE_ID>',
		'<CUSTOM_APPROVAL_INSTRUCT>', REPLACE (COALESCE(CUSTOM_APPROVAL_INSTRUCT,''), '&', '&amp;'), '</CUSTOM_APPROVAL_INSTRUCT>',
		'<CUSTOM_TEMPLATE_NAME>', COALESCE(CUSTOM_TEMPLATE_NAME,''), '</CUSTOM_TEMPLATE_NAME>',
		'<FOOTER>', COALESCE(FOOTER,''), '</FOOTER>',
		'<HEADER>', COALESCE(HEADER,''), '</HEADER>',
		'<HIDE_APPROVAL_BUTTON>', CASE WHEN HIDE_APPROVAL_BUTTON = 0 THEN 'f' ELSE 't' END , '</HIDE_APPROVAL_BUTTON>',
		'<HIDE_APPROVAL_COMMENT>', CASE WHEN HIDE_APPROVAL_COMMENT = 0 THEN 'f' ELSE 't' END , '</HIDE_APPROVAL_COMMENT>',
		'<HIDE_APPROVAL_INSTRUCT>', CASE WHEN HIDE_APPROVAL_INSTRUCT = 0 THEN 'f' ELSE 't' END , '</HIDE_APPROVAL_INSTRUCT>',
		'<HIDE_ASSIGNEE>', CASE WHEN HIDE_ASSIGNEE = 0 THEN 'f' ELSE 't' END , '</HIDE_ASSIGNEE>',
		'<HIDE_COMMENT>', CASE WHEN HIDE_COMMENT = 0 THEN 'f' ELSE 't' END , '</HIDE_COMMENT>' , 
   		'<HIDE_CREATED>', CASE WHEN HIDE_CREATED = 0 THEN 'f' ELSE 't' END , '</HIDE_CREATED>',
		'<HIDE_DESCRIPTION>', CASE WHEN HIDE_DESCRIPTION = 0 THEN 'f' ELSE 't' END , '</HIDE_DESCRIPTION>',
		'<HIDE_ISSUE_TYPE>', CASE WHEN HIDE_ISSUE_TYPE = 0 THEN 'f' ELSE 't' END , '</HIDE_ISSUE_TYPE>',
		'<HIDE_LOGO>', CASE WHEN HIDE_LOGO = 0 THEN 'f' ELSE 't' END , '</HIDE_LOGO>',
		'<HIDE_PRIORITY>', CASE WHEN HIDE_PRIORITY = 0 THEN 'f' ELSE 't' END , '</HIDE_PRIORITY>',
		'<HIDE_PROJECT>', CASE WHEN HIDE_PROJECT = 0 THEN 'f' ELSE 't' END , '</HIDE_PROJECT>',
		'<HIDE_REPORTER>', CASE WHEN HIDE_REPORTER = 0 THEN 'f' ELSE 't' END , '</HIDE_REPORTER>',
		'<HIDE_WORKFLOW_TRANS>',  CASE WHEN HIDE_WORKFLOW_TRANS = 0 THEN 'f' ELSE 't' END , '</HIDE_WORKFLOW_TRANS>',
		'<ID>', ID, '</ID>',
		'<IS_BOTTOM_BODY_SECTION>', CASE WHEN IS_BOTTOM_BODY_SECTION = 0 THEN 'f' ELSE 't' END , '</IS_BOTTOM_BODY_SECTION>',
		'<IS_BOTTOM_BUTTON>', CASE WHEN IS_BOTTOM_BUTTON = 0 THEN 'f' ELSE 't' END , '</IS_BOTTOM_BUTTON>',
		'<IS_EMAIL_TEMPLATE_DEFAULT>', CASE WHEN IS_EMAIL_TEMPLATE_DEFAULT = 0 THEN 'f' ELSE 't' END , '</IS_EMAIL_TEMPLATE_DEFAULT>',
		'<IS_EMAIL_TEMPLATE_REPLY>', CASE WHEN IS_EMAIL_TEMPLATE_REPLY = 0 THEN 'f' ELSE 't' END , '</IS_EMAIL_TEMPLATE_REPLY>',
		'<PROJECT_ID>', COALESCE(PROJECT_ID,''), '</PROJECT_ID>',
		'<SHOW_LINKED_ISSUES>', CASE WHEN SHOW_LINKED_ISSUES = 0 THEN 'f' ELSE 't' END , '</SHOW_LINKED_ISSUES>',
		'<SHOW_SUBTASKS>', CASE WHEN SHOW_SUBTASKS = 0 THEN 'f' ELSE 't' END , '</SHOW_SUBTASKS>',
		'<SUBJECT>', REPLACE (COALESCE(SUBJECT,''), '&','&amp;'), '</SUBJECT>',
		'<TYPE>', COALESCE(TYPE,''), '</TYPE>',
   '</row>')) data_xml
	FROM AO_D195E9_CUSTOM_MAIL_TEMPLATE;


	/*Place all the 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 AO_D195E9_APPROVAL_NOT_NOTIFY;


	/*Place all the 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 AO_D195E9_NTF_SCHEME;

	/*Place all the 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>', COALESCE(CUSTOM_MAIL_TEMPLATE_ID,''), '</CUSTOM_MAIL_TEMPLATE_ID>',
        '<EVENT_TYPE_ID>', COALESCE(EVENT_TYPE_ID,''), '</EVENT_TYPE_ID>',
		'<NOTIFY_EXPRESSION>', COALESCE(NOTIFY_EXPRESSION,''), '</NOTIFY_EXPRESSION>',
		'<NTF_SCHEME_ID>', NTF_SCHEME_ID, '</NTF_SCHEME_ID>',
   '</row>') data_xml
	FROM AO_D195E9_NTF_SCHEME_DETAIL;

	/*Place all the 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 AO_D195E9_APPROVAL_RECIPIENTS;

/*Place all the result of this query between <AO_D195E9_APPROVAL_PROJECTS></AO_D195E9_APPROVAL_PROJECTS> tags*/

SELECT 
   CONCAT('<row>',
       '<ID>', ID, '</ID>',
       '<PROJECT_ID>', COALESCE(PROJECT_ID,''), '</PROJECT_ID>',
       '<REQUESTER_TYPE>', COALESCE(REQUESTER_TYPE,''), '</REQUESTER_TYPE>',
   '</row>') data_xml
	FROM AO_D195E9_APPROVAL_PROJECTS;


/*Place all the 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 AO_D195E9_APPROVAL_REQUESTERS;

/*Place all the 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 AO_D195E9_APPROVAL_DEFINERS;


/*Place all the 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 AO_D195E9_APPROVAL_MENU_PERM;

/*Place all the result of this query between <AO_D195E9_APPROVAL_MAPPING></AO_D195E9_APPROVAL_MAPPING> tags*/

SELECT 
	
   CONCAT('<row>',
       '<ABSTAIN_ACTION_STATUS>', COALESCE(ABSTAIN_ACTION_STATUS,''), '</ABSTAIN_ACTION_STATUS>',
       '<AREA_COND_RULE_ID>', COALESCE(AREA_COND_RULE_ID,''), '</AREA_COND_RULE_ID>',
       '<AREA_DATE_PICKER>', COALESCE(AREA_DATE_PICKER,''), '</AREA_DATE_PICKER>',
	'<AREA_ELAPSED_TIME>', COALESCE(AREA_ELAPSED_TIME,''), '</AREA_ELAPSED_TIME>',
	'<AREA_SERVICE_NAME>', COALESCE(AREA_SERVICE_NAME,''), '</AREA_SERVICE_NAME>',
	'<ARN>', CASE WHEN ARN = 0 THEN 'f' ELSE 't' END, '</ARN>',
	'<AWT>', CASE WHEN AWT = 0 THEN 'f' ELSE 't' END , '</AWT>',
	'<AWTAD>', CASE WHEN AWTAD = 0 THEN 'f' ELSE 't' END , '</AWTAD>',
	'<AWTR>', CASE WHEN AWTR = 0 THEN 'f' ELSE 't' END , '</AWTR>',
	'<CONDITIONAL_RULE_ID>', COALESCE(CONDITIONAL_RULE_ID,''), '</CONDITIONAL_RULE_ID>',
	'<CONFIG_ID>', COALESCE(CONFIG_ID,''), '</CONFIG_ID>',
		'<DA_DECISION>', COALESCE(DA_DECISION,''), '</DA_DECISION>',
		'<DA_ELAPSED_TIME>', COALESCE(DA_ELAPSED_TIME,''), '</DA_ELAPSED_TIME>',
		'<DA_SERVICE_NAME>', COALESCE(DA_SERVICE_NAME,''), '</DA_SERVICE_NAME>',
		'<DA_USER_KEY>', COALESCE(DA_USER_KEY,''), '</DA_USER_KEY>',
		'<DESTINATION_STATUS_ID>', COALESCE(DESTINATION_STATUS_ID,''), '</DESTINATION_STATUS_ID>',
		'<ID>', ID, '</ID>',
		'<ISSUE_TYPE_ID>', COALESCE(ISSUE_TYPE_ID,''), '</ISSUE_TYPE_ID>',
		'<IS_DELETE>', CASE WHEN IS_DELETE = 0 THEN 'f' ELSE 't' END , '</IS_DELETE>',
		'<IS_DRAFT>', CASE WHEN IS_DRAFT = 0 THEN 'f' ELSE 't' END , '</IS_DRAFT>',
		'<IS_LOCKED>', CASE WHEN IS_LOCKED = 0 THEN 'f' ELSE 't' END , '</IS_LOCKED>',
		'<IS_NOT_SINGLE>', CASE WHEN IS_NOT_SINGLE = 0 THEN 'f' ELSE 't' END , '</IS_NOT_SINGLE>',
		'<LOCKED_DATE>', COALESCE(LOCKED_DATE,''), '</LOCKED_DATE>',
		'<LOCKED_INFO>', COALESCE(LOCKED_INFO,''), '</LOCKED_INFO>',	
		'<MAIL_TEMPLATE_REPLY_ID>', COALESCE(MAIL_TEMPLATE_REPLY_ID,''), '</MAIL_TEMPLATE_REPLY_ID>',
		'<MAIL_TEMPLATE_REQUEST_ID>', COALESCE(MAIL_TEMPLATE_REQUEST_ID,''), '</MAIL_TEMPLATE_REQUEST_ID>',
		'<MRA>', COALESCE(MRA,''), '</MRA>',
		'<MRR>', COALESCE(MRR,''), '</MRR>',
		'<NAC>', CASE WHEN NAC = 0 THEN 'f' ELSE 't' END , '</NAC>',
		'<ORDER_MAP>', COALESCE(ORDER_MAP,''), '</ORDER_MAP>',
		'<PROJECT_ID>', COALESCE(PROJECT_ID,''), '</PROJECT_ID>',
		'<RAC>', CASE WHEN RAC = 0 THEN 'f' ELSE 't' END , '</RAC>',
		'<RACA>', COALESCE(RACA,''), '</RACA>',
		'<REPLY_NOTIFICATION_SCHEMA_ID>', COALESCE(REPLY_NOTIFICATION_SCHEMA_ID,''), '</REPLY_NOTIFICATION_SCHEMA_ID>',
		'<SA>', CASE WHEN SA = 0 THEN 'f' ELSE 't' END, '</SA>',
		'<SAAD>', CASE WHEN SAAD = 0 THEN 'f' ELSE 't' END , '</SAAD>',
		'<SHOW_APPROVAL_BUTTONS_JSD>', CASE WHEN SHOW_APPROVAL_BUTTONS_JSD = 0 THEN 'f' ELSE 't' END , '</SHOW_APPROVAL_BUTTONS_JSD>',
		'<SHOW_APPROVAL_STATUS_JSD>', CASE WHEN SHOW_APPROVAL_STATUS_JSD = 0 THEN 'f' ELSE 't' END , '</SHOW_APPROVAL_STATUS_JSD>',
		'<SOURCE_STATUS_ID>', COALESCE(SOURCE_STATUS_ID,''), '</SOURCE_STATUS_ID>',
		'<SUPER_APPROVERS_EXPR>', COALESCE(SUPER_APPROVERS_EXPR,''), '</SUPER_APPROVERS_EXPR>',
		'<TRANSITION_ID>', COALESCE(TRANSITION_ID,''), '</TRANSITION_ID>',
		'<TRANSITION_ON_REJECTING>', COALESCE(TRANSITION_ON_REJECTING,''), '</TRANSITION_ON_REJECTING>',
	'</row>'
) data_xml
	FROM AO_D195E9_APPROVAL_MAPPING;



/*Place all the 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>', CASE WHEN IS_OPTIONAL_APPROVAL = 0 THEN 'f' ELSE 't' END , '</IS_OPTIONAL_APPROVAL>',
		'<SORT_SA>', SORT_SA, '</SORT_SA>',
   '</row>') data_xml
	FROM AO_D195E9_APPROVAL_MAPPING_REL;

/*Place all the result of this query between <AO_D195E9_ISSUE_APPROVAL></AO_D195E9_ISSUE_APPROVAL> tags*/

SELECT 
	CONCAT(
   '<row>',
	'<ABSTAIN_ACTION_STATUS>', COALESCE(ABSTAIN_ACTION_STATUS,''), '</ABSTAIN_ACTION_STATUS>',
	'<APPROVAL_ID>', COALESCE(APPROVAL_ID,''), '</APPROVAL_ID>',
	'<APPROVAL_STATUS>', COALESCE(APPROVAL_STATUS,''), '</APPROVAL_STATUS>',
	'<APPROVER_USER>', COALESCE(APPROVER_USER,''), '</APPROVER_USER>',
	'<AREA_COND_RULE_ID>', COALESCE(AREA_COND_RULE_ID,''), '</AREA_COND_RULE_ID>',
	'<AREA_DATE_PICKER>', COALESCE(AREA_DATE_PICKER,''), '</AREA_DATE_PICKER>',
	'<AREA_ELAPSED_TIME>', COALESCE(AREA_ELAPSED_TIME,''), '</AREA_ELAPSED_TIME>',
	'<AREA_SERVICE_NAME>', COALESCE(AREA_SERVICE_NAME,''), '</AREA_SERVICE_NAME>',
	'<ARN>', CASE WHEN ARN = 0 THEN 'f' ELSE 't' END , '</ARN>',
	'<AWT>', CASE WHEN AWT = 0 THEN 'f' ELSE 't' END , '</AWT>',
	'<AWTAD>', CASE WHEN AWTAD = 0 THEN 'f' ELSE 't' END , '</AWTAD>',
	'<AWTR>', CASE WHEN AWTR = 0 THEN 'f' ELSE 't' END , '</AWTR>',
	'<COMMENT_NOTIFICATION_DATE>', COALESCE(COMMENT_NOTIFICATION_DATE,''), '</COMMENT_NOTIFICATION_DATE>',
	'<CONDITIONAL_RULE_ID>', COALESCE(CONDITIONAL_RULE_ID,''), '</CONDITIONAL_RULE_ID>',
	'<CUSTOM_APPROVER>', COALESCE(CUSTOM_APPROVER,''), '</CUSTOM_APPROVER>',	
		'<DATE>', COALESCE(DATE,''), '</DATE>',
		'<DA_DECISION>', COALESCE(DA_DECISION,''), '</DA_DECISION>',
		'<DA_ELAPSED_TIME>', COALESCE(DA_ELAPSED_TIME,''), '</DA_ELAPSED_TIME>',
		'<DA_SERVICE_NAME>', COALESCE(DA_SERVICE_NAME,''), '</DA_SERVICE_NAME>',
		'<DA_USER_KEY>', COALESCE(DA_USER_KEY,''), '</DA_USER_KEY>',
		'<DEFINE_CUSTOM_APPROVAL>', CASE WHEN DEFINE_CUSTOM_APPROVAL = 0 THEN 'f' ELSE 't' END , '</DEFINE_CUSTOM_APPROVAL>',
		'<DELEGATOR_KEY>', COALESCE(DELEGATOR_KEY,''), '</DELEGATOR_KEY>',
		'<ERROR_TRANSIT>', CASE WHEN ERROR_TRANSIT = 0 THEN 'f' ELSE 't' END , '</ERROR_TRANSIT>',
		'<ERROR_TRANSIT_TYPE>', COALESCE(ERROR_TRANSIT_TYPE,''), '</ERROR_TRANSIT_TYPE>',
		'<HAS_CONFIG_FOR_SINGLE_ISSUE>', COALESCE(HAS_CONFIG_FOR_SINGLE_ISSUE,''), '</HAS_CONFIG_FOR_SINGLE_ISSUE>',
		'<ID>', ID, '</ID>',
		'<ISSUE_ID>', COALESCE(ISSUE_ID,''), '</ISSUE_ID>',
		'<ISSUE_STATUS>',  COALESCE(ISSUE_STATUS,''), '</ISSUE_STATUS>',
		'<IS_OPTIONAL_APPROVAL>', CASE WHEN IS_OPTIONAL_APPROVAL = 0 THEN 'f' ELSE 't' END , '</IS_OPTIONAL_APPROVAL>',
		'<MAIL_TEMPLATE_REPLY_ID>', COALESCE(MAIL_TEMPLATE_REPLY_ID,''), '</MAIL_TEMPLATE_REPLY_ID>', 
		'<MAIL_TEMPLATE_REQUEST_ID>', COALESCE(MAIL_TEMPLATE_REQUEST_ID,''), '</MAIL_TEMPLATE_REQUEST_ID>',
		'<MRA>', COALESCE(MRA,''), '</MRA>',
		'<MRR>', COALESCE(MRR,''), '</MRR>',
		'<NAC>', CASE WHEN NAC = 0 THEN 'f' ELSE 't' END , '</NAC>',
		'<NOTIFICATION_DATE>', COALESCE(NOTIFICATION_DATE,''), '</NOTIFICATION_DATE>',
		'<RAC>', CASE WHEN RAC = 0 THEN 'f' ELSE 't' END , '</RAC>',
		'<RACA>', COALESCE(RACA,''), '</RACA>',
		'<REPLY_NOTIFICATION_SCHEMA_ID>', COALESCE(REPLY_NOTIFICATION_SCHEMA_ID,''), '</REPLY_NOTIFICATION_SCHEMA_ID>',
		'<SA>', CASE WHEN SA = 0 THEN 'f' ELSE 't' END , '</SA>',
		'<SAAD>', CASE WHEN SAAD = 0 THEN 'f' ELSE 't' END , '</SAAD>',
		'<SHOW_APPROVAL_BUTTONS_JSD>', CASE WHEN SHOW_APPROVAL_BUTTONS_JSD = 0 THEN 'f' ELSE 't' END , '</SHOW_APPROVAL_BUTTONS_JSD>',
		'<SHOW_APPROVAL_STATUS_JSD>', CASE WHEN SHOW_APPROVAL_STATUS_JSD = 0 THEN 'f' ELSE 't' END , '</SHOW_APPROVAL_STATUS_JSD>',
		'<SORT_SA>', COALESCE(SORT_SA,''), '</SORT_SA>',
		'<SOURCE_STATUS_ID>', COALESCE(SOURCE_STATUS_ID,''), '</SOURCE_STATUS_ID>',
		'<SUBMITTED_DATE>', COALESCE(SUBMITTED_DATE,''), '</SUBMITTED_DATE>',
		'<SUPER_APPROVERS_EXPR>', COALESCE(SUPER_APPROVERS_EXPR,''), '</SUPER_APPROVERS_EXPR>',
		'<TRANSITION_ID>', COALESCE(TRANSITION_ID,''), '</TRANSITION_ID>',
		'<TRANSITION_NAME>', COALESCE(TRANSITION_NAME,''), '</TRANSITION_NAME>',
		'<TRANSITION_ON_REJECTING>', COALESCE(TRANSITION_ON_REJECTING,''), '</TRANSITION_ON_REJECTING>',
		'<TYPE>', COALESCE(TYPE,''), '</TYPE>',
	'</row>'
) data_xml
	FROM  AO_D195E9_ISSUE_APPROVAL WHERE TYPE = 'SINGLE_ISSUE';


/*Place all the result of this query between <AO_D195E9_APPROVAL_MRA></AO_D195E9_APPROVAL_MRA> tags*/

SELECT 
   CONCAT('<row>',
       '<APPROVAL_MAPPING_ID>', COALESCE(APPROVAL_MAPPING_ID,''), '</APPROVAL_MAPPING_ID>',
       '<CONDITIONAL_RULE_ID>', COALESCE(CONDITIONAL_RULE_ID,''), '</CONDITIONAL_RULE_ID>',
       '<ID>', ID, '</ID>',
		'<ISSUE_ID>', COALESCE(ISSUE_ID,''), '</ISSUE_ID>',
		'<MRA>', COALESCE(MRA,''), '</MRA>',
		'<ORDER>', COALESCE(AO_D195E9_APPROVAL_MRA.ORDER,''), '</ORDER>',
		'<SOURCE_STATUS_ID>', COALESCE(SOURCE_STATUS_ID,''), '</SOURCE_STATUS_ID>',
		'<TRANSITION_ID>', COALESCE(TRANSITION_ID,''), '</TRANSITION_ID>',
		'<TYPE>', COALESCE(TYPE,''), '</TYPE>',
   '</row>') data_xml
	FROM AO_D195E9_APPROVAL_MRA;


/*Place all the result of this query between <AO_D195E9_APPROVAL_HISTORY></AO_D195E9_APPROVAL_HISTORY> tags*/

SELECT 
   CONCAT('<row>',
       '<ACTION>', COALESCE(ACTION,''), '</ACTION>',
       '<APPROVAL_COMMENT>', COALESCE(APPROVAL_COMMENT,''), '</APPROVAL_COMMENT>',
       '<APPROVAL_DETAIL>', COALESCE(APPROVAL_DETAIL,'') , '</APPROVAL_DETAIL>',
		'<APPROVAL_NAME>', COALESCE(APPROVAL_NAME,''), '</APPROVAL_NAME>',
		'<COMMENT>', COALESCE(REPLACE(REPLACE (REPLACE ( COMMENT, '&', '&amp;' ), '<', '&lt;'),'>','&gt;'),''), '</COMMENT>',
		'<DATE>', COALESCE(DATE,''), '</DATE>',
		'<DELEGATOR_KEY>', COALESCE(DELEGATOR_KEY,''), '</DELEGATOR_KEY>',
		'<DESTINATION_STATUS>', COALESCE(DESTINATION_STATUS,''), '</DESTINATION_STATUS>',
		'<EXECUTOR>', COALESCE(EXECUTOR,''), '</EXECUTOR>',
		'<EXECUTOR_KEY>', COALESCE(EXECUTOR_KEY,''), '</EXECUTOR_KEY>',
		'<ID>', ID, '</ID>',
		'<ISSUE_ID>', COALESCE(ISSUE_ID,''), '</ISSUE_ID>',
		'<NOTIFICATION_DATE>', COALESCE(NOTIFICATION_DATE,''), '</NOTIFICATION_DATE>',
		'<SOURCE_STATUS>', COALESCE(SOURCE_STATUS,''), '</SOURCE_STATUS>',
		'<SUBMITTED_DATE>', COALESCE(SUBMITTED_DATE,''), '</SUBMITTED_DATE>',
		'<TRANSITION_NAME>', COALESCE(TRANSITION_NAME,''), '</TRANSITION_NAME>',
   '</row>') data_xml
	FROM AO_D195E9_APPROVAL_HISTORY ORDER BY ID	DESC LIMIT 0,50000;

	/*Place all the result of this query between <AO_D195E9_APPROVAL_DELEGATED></AO_D195E9_APPROVAL_DELEGATED>*/

SELECT
		
		CONCAT(	'<row>', 
			'<DELEGATED_KEY>', COALESCE(DELEGATED_KEY,''), '</DELEGATED_KEY>',
			'<DELEGATOR_KEY>',	COALESCE(DELEGATOR_KEY,''), '</DELEGATOR_KEY>',
			'<END_DATE>', COALESCE(END_DATE,''), '</END_DATE>',
			'<ID>', ID,	'</ID>',
			'<ISSUE_TYPE_ID>', COALESCE(ISSUE_TYPE_ID,''), '</ISSUE_TYPE_ID>',
			'<PROJECT_ID>', COALESCE(PROJECT_ID,''), '</PROJECT_ID>',
			'<SEND_APPROVAL_REQUESTS>', CASE WHEN SEND_APPROVAL_REQUESTS = 0 THEN 'f' ELSE 't' END , '</SEND_APPROVAL_REQUESTS>',
			'<START_DATE>', COALESCE(START_DATE,''), '</START_DATE>',
			'</row>' )
		 data_xml 
	FROM
		AO_D195E9_APPROVAL_DELEGATED

Create the XML File

For each query, select the results returned, you should have a set of results for each query.
Organize the selected results in the following format for each query

Code Block
<QUERY_TAG> <!-- Paste the results here --> </QUERY_TAG>

Replace QUERY_TAG with the appropriate tag specified in the comments of the SQL file, such as <CWD_USER></CWD_USER>.

Ensure that each set of results is placed between the corresponding opening and closing XML tags.
Save the organized XML data into a file with a .xml extension.

Herzum Approval Migration

Info
Before the migration process review data consistency and ensure that users, projects, issue types, and workflows in the cloud instance match the source instance.

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 12

New Version 13

Key

Overview

Backup File

Create the XML File

Herzum Approval Migration

Page Comparison

Versions Compared

Old Version 12

New Version 13

Key

Overview

Backup File

Create the XML File

Herzum Approval Migration