When exporting either a filtered or custom query result include the query in the opening resultset tag that produced the result.

1 files changed, 8 insertions, 2 deletions

diff --git a/Source/SPExportFileUtilities.m b/Source/SPExportFileUtilities.m
index 86631495..5a9d16ee 100644
--- a/Source/SPExportFileUtilities.m
+++ b/Source/SPExportFileUtilities.m
@@ -88,11 +88,17 @@
 	[header appendString:@"-\n-->\n\n"];
 	
 	if ([exportXMLFormatPopUpButton indexOfSelectedItem] == SPXMLExportMySQLFormat) {
-		[header appendFormat:@"<%@ xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\n", (exportSource == SPTableExport) ? @"mysqldump" : @"resultset"];
+		
+		NSString *tag = @"";
 		
 		if (exportSource == SPTableExport) {
-			[header appendFormat:@"<database name=\"%@\">\n\n", [tableDocumentInstance database]];
+			tag = [NSString stringWithFormat:@"<mysqldump xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\n<database name=\"%@\">\n\n", [tableDocumentInstance database]];
+		}
+		else {
+			tag = [NSString stringWithFormat:@"<resultset statement=\"%@\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\n\n", (exportSource == SPFilteredExport) ? [tableContentInstance usedQuery] : [customQueryInstance usedQuery]];
 		}
+		
+		[header appendString:tag];
 	}
 	else {
 		[header appendFormat:@"<%@>\n\n", [[tableDocumentInstance database] HTMLEscapeString]];