declare variable $pageSize := 250;

let $table := collection("xAce.dbo.singles")/singles
let $groupCount := xs:integer(fn:ceiling(count($table) div $pageSize))
for $g in 1 to $groupCount
let $group := $table[fn:position() gt ($g - 1) * $pageSize and fn:position() le $g * $pageSize]
return (ddtek:serialize-to-url(
<Papers>
	{
	for $singles1 in $group
	return
	<AcademicPaper>
		{
		for $Titles in collection("xAce.dbo.Title")/Title 
		where $Titles/autoID = $singles1/autoID 
		return 
		<Titles>
			{
				if( $Titles/TI ) then
					<Title>
						{
						$Titles/TI/text()
						}
					</Title>
				else ()
			}
			{
				if( $Titles/FT ) then
					<ForeignTitle>
						{
						$Titles/FT/text()
						}
					</ForeignTitle>
				else ()
			}
			{
				if( $Titles/Orig ) then
					<Original>
						{
						$Titles/Orig/text()
						}
					</Original>
				else ()
			}
			{
				if( $Titles/Gister ) then
					<Gister>
						{
						$Titles/Gister/text()
						}
					</Gister>
				else ()
			}
			{
				if( $Titles/Lambda ) then
					<Lambda>
						{
						$Titles/Lambda/text()
						}
					</Lambda>
				else ()
			}
			{
				if( $Titles/Systran5 ) then
					<Systran5>
						{
						$Titles/Systran5/text()
						}
					</Systran5>
				else ()
			}
			{
				if( $Titles/Sigma ) then
					<Sigma>
						{
						$Titles/Sigma/text()
						}
					</Sigma>
				else ()
			}
		</Titles>
		}
		{
			if( $singles1/ThesisType ) then <ThesisType>{$singles1/ThesisType/text()}</ThesisType>else ()
		}
		{
			if( $singles1/PNS ) then <PersonalNameSubject>{$singles1/PNS/text()}</PersonalNameSubject>else ()
		}
		{
			if( $singles1/SO ) then <Source>{$singles1/SO/text()}</Source>else ()
		}
		{
			if( $singles1/SE ) then <Series>{$singles1/SE/text()}</Series>else ()
		}
		{
			if( $singles1/PD ) then <PublicationDate>{$singles1/PD/text()}</PublicationDate>else ()
		}
		{
			if( $singles1/PY ) then <YearPublished>{$singles1/PY/text()}</YearPublished>else ()
		}
		{
			if( $singles1/PUBM ) then <PublishingModel>{$singles1/PUBM/text()}</PublishingModel>else ()
		}
		{
			if( $singles1/DA ) then <DateCreated>{$singles1/DA/text()}</DateCreated>else ()
		}
		{
			if( $singles1/DEP ) then <DateElectronicPublication>{$singles1/DEP/text()}</DateElectronicPublication>else ()
		}
		{
			if( $singles1/EDAT ) then <EntrezDate>{$singles1/EDAT/text()}</EntrezDate>else ()
		}
		{
			if( $singles1/MHDA ) then <MeSHDate>{$singles1/MHDA/text()}</MeSHDate>else ()
		}
		{
			let $PHSTs := collection("xAce.dbo.PHST")/PHST[$singles1/autoID=autoID]return
			if ($PHSTs) then <PublicationHistory>{for $PHST in $PHSTs return <PublicationHistoryStatusDate>{$PHST/PHST/text()}</PublicationHistoryStatusDate>}</PublicationHistory>else ()
		}
		{
			if( $singles1/LR ) then <LastRevisionDate>{$singles1/LR/text()}</LastRevisionDate>else ()
		}
		{
			if( $singles1/PST ) then <PublicationStatus>{$singles1/PST/text()}</PublicationStatus>else ()
		}
		{
			if( $singles1/STAT ) then <StatusTag>{$singles1/STAT/text()}</StatusTag>else ()
		}
		{
			if( $singles1/VL ) then <Volume>{$singles1/VL/text()}</Volume>else ()
		}
		{
			if( $singles1/IS ) then <Issue>{$singles1/IS/text()}</Issue>else ()
		}
		{
			if( $singles1/SU ) then <Supplement>{$singles1/SU/text()}</Supplement>else ()
		}
		{
			if( $singles1/SI ) then <SpecialIssue>{$singles1/SI/text()}</SpecialIssue>else ()
		}
		{
			if( $singles1/BP ) then <BeginningPage>{$singles1/BP/text()}</BeginningPage>else ()
		}
		{
			if( $singles1/EP ) then <EndingPage>{$singles1/EP/text()}</EndingPage>else ()
		}
		{
			if( $singles1/PS ) then <PageSpan>{$singles1/PS/text()}</PageSpan>else ()
		}
		{
			let $Authors := collection("xAce.dbo.Authors")/Authors[$singles1/autoID = autoID] return
			if($Authors) then
			<Authors>
			{
				for $Author in $Authors return
					if($Author/AU or $Author/AF or $Author/BAU or $Author/Orig) then
						<Author> 
				{
					if( $Author/AU ) then <AuthorShortName>{$Author/AU/text()}</AuthorShortName>else ()
				}
				{
					if( $Author/AF ) then <AuthorFullName>{$Author/AF/text()}</AuthorFullName>else ()
				}
				{
					if( $Author/BAU ) then <AuthorNameBiomed>{$Author/BAU/text()}</AuthorNameBiomed>else ()
				}
				{
					if( $Author/C1 ) then <AuthorAddress>{$Author/C1/text()}</AuthorAddress>else ()
				}
				{
					if( $Author/EM ) then <AuthorEmail>{$Author/EM/text()}</AuthorEmail>else ()
				}
				{
					if( $Author/Orig ) then <Original>{$Author/Orig/text()}</Original>else ()
				}
				{
					if( $Author/Gister ) then <Gister>{$Author/Gister/text()}</Gister>else ()
				}
				{
					if( $Author/Lambda ) then <Lambda>{$Author/Lambda/text()}</Lambda>else ()
				}
				{
					if( $Author/Systran5 ) then <Systran5>{$Author/Systran5/text()}</Systran5>else ()
				}
				{
					if( $Author/Sigma ) then <Sigma>{$Author/Sigma/text()}</Sigma>else ()
				}
			</Author> else ()
			}
		</Authors> else ()
		}
		{
		for $Advisor in collection("xAce.dbo.Advisor")/Advisor 
		where $Advisor/autoID = $singles1/autoID 
		return 
		<Advisor>
			{
				if( $Advisor/Orig ) then
					<Original>
						{
						$Advisor/Orig/text()
						}
					</Original>
				else ()
			}
			{
				if( $Advisor/Gister ) then
					<Gister>
						{
						$Advisor/Gister/text()
						}
					</Gister>
				else ()
			}
			{
				if( $Advisor/Lambda ) then
					<Lambda>
						{
						$Advisor/Lambda/text()
						}
					</Lambda>
				else ()
			}
			{
				if( $Advisor/Systran5 ) then
					<Systran5>
						{
						$Advisor/Systran5/text()
						}
					</Systran5>
				else ()
			}
			{
				if( $Advisor/Sigma ) then
					<Sigma>
						{
						$Advisor/Sigma/text()
						}
					</Sigma>
				else ()
			}
		</Advisor>
		}
		{
			let $BAs := collection("xAce.dbo.BA")/BA[$singles1/autoID=autoID]return
			if ($BAs) then <BookAuthors>{for $BA in $BAs return <BookAuthor>{$BA/BA/text()}</BookAuthor>}</BookAuthors>else ()
		}
		{
			let $BEs := collection("xAce.dbo.BE")/BE[$singles1/autoID=autoID]return
			if ($BEs) then <Editors>{for $BE in $BEs return <Editor>{$BE/BE/text()}</Editor>}</Editors>else ()
		}
		{
			if( $singles1/AD ) then <Affiliation>{$singles1/AD/text()}</Affiliation>else ()
		}
		{
			if( $singles1/University ) then <University>{$singles1/University/text()}</University>else ()
		}
		{
			if( $singles1/UniversityAddress ) then <UniversityAddress>{$singles1/UniversityAddress/text()}</UniversityAddress>else ()
		}
		{
			let $CAs := collection("xAce.dbo.CA")/CA[$singles1/autoID=autoID]return
			if ($CAs) then <CorporateAuthors>{for $CA in $CAs return <CorporateAuthor>{$CA/CA/text()}</CorporateAuthor>}</CorporateAuthors>else ()
		}
		{
			if( $singles1/RP ) then <ReprintAddress>{$singles1/RP/text()}</ReprintAddress>else ()
		}
		{
			if( $singles1/OWN ) then <Owner>{$singles1/OWN/text()}</Owner>else ()
		}
		{
			let $CCs := collection("xAce.dbo.CC")/CC[$singles1/autoID=autoID]return
			if ($CCs) then <ConceptCodes>{for $CC in $CCs return <ConceptCode>{$CC/CC/text()}</ConceptCode>}</ConceptCodes>else ()
		}
		{
			if( $singles1/SB ) then <Subset>{$singles1/SB/text()}</Subset>else ()
		}
		{
			let $CHs := collection("xAce.dbo.CH")/CH[$singles1/autoID=autoID]return
			if ($CHs) then <ChemicalBioChemicals>{for $CH in $CHs return <ChemicalBioChemical>{$CH/CH/text()}</ChemicalBioChemical>}</ChemicalBioChemicals>else ()
		}
		{
			let $DSs := collection("xAce.dbo.DS")/DS[$singles1/autoID=autoID]return
			if ($DSs) then <Diseases>{for $DS in $DSs return <Disease>{$DS/DS/text()}</Disease>}</Diseases>else ()
		}
		{
			let $GEs := collection("xAce.dbo.GE")/GE[$singles1/autoID=autoID]return
			if ($GEs) then <GeographicData>{for $GE in $GEs return <Geography>{$GE/GE/text()}</Geography>}</GeographicData>else ()
		}
		{
			let $MQs := collection("xAce.dbo.MQ")/MQ[$singles1/autoID=autoID]return
			if ($MQs) then <MethodsEquipment>{for $MQ in $MQs return <MethodEquipment>{$MQ/MQ/text()}</MethodEquipment>}</MethodsEquipment>else ()
		}
		{
			let $GNs := collection("xAce.dbo.GN")/GN[$singles1/autoID = autoID]return
			if ($GNs) then <GeneNameData>{for $GN in $GNs return <GeneName>{$GN/GN/text()}</GeneName>}</GeneNameData>else ()
		}
		{
			let $TAs := collection("xAce.dbo.TA")/TA[$singles1/autoID = autoID]return
			if ($TAs) then <TaxonomicData>{for $TA in $TAs return <Taxonomic>{$TA/TA/text()}</Taxonomic>}</TaxonomicData>else ()
		}
		{
			let $TMs := collection("xAce.dbo.TM")/TM[$singles1/autoID = autoID]return
			if ($TMs) then <GeologicTimeData>{for $TM in $TMs return <GeologicTime>{$TM/TM/text()}</GeologicTime>}</GeologicTimeData>else ()
		}
		{
			let $MCs := collection("xAce.dbo.MC")/MC[$singles1/autoID = autoID]return
			if ($MCs) then <MajorConcepts>{for $MC in $MCs return <MajorConcept>{$MC/MC/text()}</MajorConcept>}</MajorConcepts>else ()
		}
		{
			let $PRs := collection("xAce.dbo.PR")/PR[$singles1/autoID = autoID]return
			if ($PRs) then <PartsStructuresSystems>{for $PR in $PRs return <PartsStructuresSystem>{$PR/PR/text()}</PartsStructuresSystem>}</PartsStructuresSystems>else ()
		}
		{
			let $SDs := collection("xAce.dbo.SD")/SD[$singles1/autoID = autoID]return
			if ($SDs) then <Sequence>{for $SD in $SDs return <SequenceData>{$SD/SD/text()}</SequenceData>}</Sequence>else ()
		}
		{
			let $MHs := collection("xAce.dbo.MH")/MH[$singles1/autoID = autoID]return
			if ($MHs) then <MeSHTerms>{for $MH in $MHs return <MeSHTerm>{$MH/MH/text()}</MeSHTerm>}</MeSHTerms>else ()
		}
		{
			let $Keywords := collection("xAce.dbo.Keyword")/Keyword[$singles1/autoID = autoID]return
			if($Keywords) then
			<Keywords>
			{
				for $Keyword in $Keywords return
					if($Keyword/DE or $Keyword/ID or $Keyword/Orig) then
						<Keyword>
							{
								if($Keyword/DE) then
									<AuthorKeyword>{$Keyword/DE/text()}</AuthorKeyword> else()
							}
							{
								if($Keyword/ID) then
									<IndexKeyword>{$Keyword/ID/text()}</IndexKeyword> else()
							}
							{
								if($Keyword/Orig) then
									<Original>{$Keyword/Orig/text()}</Original> else()
							}
							{
								if($Keyword/Gister) then
									<Gister>{$Keyword/Gister/text()}</Gister> else()
							}
							{
								if($Keyword/Lambda) then
									<Lambda>{$Keyword/Lambda/text()}</Lambda> else()
							}
							{
								if($Keyword/Systran5) then
									<Systran5>{$Keyword/Systran5/text()}</Systran5> else()
							}
							{
								if($Keyword/Sigma) then
									<Sigma>{$Keyword/Sigma/text()}</Sigma> else()
							}
						</Keyword> else ()
					}
					</Keywords> else ()
				}
		{
			let $SubjectCategories := collection("xAce.dbo.SubjectCategory")/SubjectCategory[$singles1/autoID = autoID]return
			if($SubjectCategories) then 
			<SubjectCatagories>
			{
				for $SubjectCategory in $SubjectCategories return
					if($SubjectCategory/Orig or $SubjectCategory/SC) then
						<SubjectCategory>
							{
								if($SubjectCategory/SC) then
									<SC>{$SubjectCategory/SC/text()}</SC> else()
							}
							{
								if($SubjectCategory/Orig) then
									<Original>{$SubjectCategory/Orig/text()}</Original> else()
							}
							{
								if($SubjectCategory/Gister) then
									<Gister>{$SubjectCategory/Gister/text()}</Gister> else()
							}
							{
								if($SubjectCategory/Lambda) then
									<Lambda>{$SubjectCategory/Lambda/text()}</Lambda> else()
							}
							{
								if($SubjectCategory/Systran5) then
									<Systran5>{$SubjectCategory/Systran5/text()}</Systran5> else()
							}
							{
								if($SubjectCategory/Sigma) then
									<Sigma>{$SubjectCategory/Sigma/text()}</Sigma> else()
							}
						</SubjectCategory>
					else()
			}
			</SubjectCatagories>
			else()
			}
		{
			if( $singles1/PN ) then <PatentNumber>{$singles1/PN/text()}</PatentNumber>else ()
		}
		{
		for $Abstract in collection("xAce.dbo.Abstract")/Abstract 
		where $Abstract/autoID = $singles1/autoID 
		return 
		<Abstract>
			{
				if( $Abstract/AB ) then <AB>{$Abstract/AB/text()}</AB>else ()
			}
			{
				if( $Abstract/Orig ) then <Original>{$Abstract/Orig/text()}</Original>else ()
			}
			{
				if( $Abstract/Gister ) then <Gister>{$Abstract/Gister/text()}</Gister>else ()
			}
			{
				if( $Abstract/Lambda ) then <Lambda>{$Abstract/Lambda/text()}</Lambda>else ()
			}
			{
				if( $Abstract/Systran5 ) then <Systran5>{$Abstract/Systran5/text()}</Systran5>else ()
			}
			{
				if( $Abstract/Sigma ) then <Sigma>{$Abstract/Sigma/text()}</Sigma>else ()
			}
		</Abstract>
		}
		{
			let $AEs := collection("xAce.dbo.AE")/AE[$singles1/autoID = autoID]return
			if ($AEs) then <PatentAssignees>{for $AE in $AEs return <PatentAssignee>{$AE/AE/text()}</PatentAssignee>}</PatentAssignees>else ()
		}
		{
			if( $singles1/DG ) then <DatePatentGranted>{$singles1/DG/text()}</DatePatentGranted>else ()
		}
		{
			if( $singles1/PC ) then <PatentCountry>{$singles1/PC/text()}</PatentCountry>else ()
		}
		{
			if( $singles1/PL ) then <PatentClass>{$singles1/PL/text()}</PatentClass>else ()
		}
		{
			let $CRs := collection("xAce.dbo.CR")/CR[$singles1/autoID = autoID]return
			if ($CRs) then <CitedReferences>{for $CR in $CRs return <CitedReference>{$CR/CR/text()}</CitedReference>}</CitedReferences>else ()
		}
		{
			if( $singles1/NR ) then <CitedReferenceCount>{$singles1/NR/text()}</CitedReferenceCount>else ()
		}
		{
			if( $singles1/TC ) then	<TimesCited>{$singles1/TC/text()}</TimesCited>else ()
		}
		{
			if( $singles1/LA ) then <LanguageOriginal>{$singles1/LA/text()}</LanguageOriginal>else ()
		}
		{
			let $DTs := collection("xAce.dbo.DT")/DT[$singles1/autoID = autoID]return
			if ($DTs) then <DocumentTypes>{for $DT in $DTs return <DocumentType>{$DT/DT/text()}</DocumentType>}</DocumentTypes>else ()
		}
		{
			if( $singles1/LT ) then <LituratureType>{$singles1/LT/text()}</LituratureType>else ()
		}
		{
			if( $singles1/ME ) then <Medium>{$singles1/ME/text()}</Medium>else ()
		}
		{
			if( $singles1/PT ) then <PubType>{$singles1/PT/text()}</PubType>else ()
		}
		{
			if( $singles1/PU ) then <PublisherNameAddress>{$singles1/PU/text()}</PublisherNameAddress>else ()
		}
		{
			if( $singles1/PI ) then <PublisherCity>{$singles1/PI/text()}</PublisherCity>else ()
		}
		{
			if( $singles1/PA ) then <PublisherAddress>{$singles1/PA/text()}</PublisherAddress>else ()
		}
		{
			if( $singles1/CT ) then <MeetingTitle>{$singles1/CT/text()}</MeetingTitle>else ()
		}
		{
			if( $singles1/CL ) then <MeetingLocation>{$singles1/CL/text()}</MeetingLocation>else ()
		}
		{
			if( $singles1/CY ) then <MeetingDate>{$singles1/CY/text()}</MeetingDate>else ()
		}
		{
			let $SPs := collection("xAce.dbo.SP")/SP[$singles1/autoID = autoID]return
			if ($SPs) then <MeetingSponsors>{for $SP in $SPs return <MeetingSponsor>{$SP/SP/text()}</MeetingSponsor>}</MeetingSponsors>else ()
		}
		{
			if( $singles1/J9 ) then <CharacterSourceAbbreviation>{$singles1/J9/text()}</CharacterSourceAbbreviation>else ()
		}
		{
			if( $singles1/JI ) then <ISOSourceAbbreviation>{$singles1/JI/text()}</ISOSourceAbbreviation>else ()
		}
		{
			if( $singles1/JT ) then <FullJournalTitle>{$singles1/JT/text()}</FullJournalTitle>else ()
		}
		{
			if( $singles1/AR ) then <ArticleNumber>{$singles1/AR/text()}</ArticleNumber>else ()
		}
		{
			if( $singles1/DI ) then <DigitalObjectID>{$singles1/DI/text()}</DigitalObjectID>else ()
		}
		{
			if( $singles1/PG ) then <PageCount>{$singles1/PG/text()}</PageCount>else ()
		}
		{
			if( $singles1/FullTextHyper ) then <FullTextHyperlink>{$singles1/FullTextHyper/text()}</FullTextHyperlink>else ()
		}
		{
			if( $singles1/GA ) then <ThomsonDocumentDeliverNumber>{$singles1/GA/text()}</ThomsonDocumentDeliverNumber>else ()
		}
		{
			if( $singles1/UT ) then <ThomsonUniqueArticleID>{$singles1/UT/text()}</ThomsonUniqueArticleID>else ()
		}
		{
			if( $singles1/AN ) then <BiosisArticleNumber>{$singles1/AN/text()}</BiosisArticleNumber>else ()
		}
		{
			let $AIDs := collection("xAce.dbo.AID")/AID[$singles1/autoID = autoID]return
			if ($AIDs) then <ArticleIdentifiers>{for $AID in $AIDs return <ArticleIdentifier>{$AID/AID/text()}</ArticleIdentifier>}</ArticleIdentifiers>else ()
		}
		{
			if( $singles1/SN ) then <ISSN>{$singles1/SN/text()}</ISSN>else ()
		}
		{
			if( $singles1/BN ) then <ISBN>{$singles1/BN/text()}</ISBN>else ()
		}
		{
			if( $singles1/JID ) then <NLMUniqueID>{$singles1/JID/text()}</NLMUniqueID>else ()
		}
		{
			if( $singles1/RN ) then <EcRnNumber>{$singles1/RN/text()}</EcRnNumber>else ()
		}
		{
			if( $singles1/IDOCID ) then <IDOCID>{$singles1/IDOCID/text()}</IDOCID>else ()
		}
		{
			if( $singles1/sourcePath ) then <SourcePath>{$singles1/sourcePath/text()}</SourcePath>else ()
		}
		{
			if( $singles1/sourceFile ) then <SourceFile>{$singles1/sourceFile/text()}</SourceFile>else ()
		}
		{
			if( $singles1/sourceType ) then <SourceType>{$singles1/sourceType/text()}</SourceType>else ()
		}
		{
			if( $singles1/classification ) then <Classification>{$singles1/classification/text()}</Classification>else ()
		}
	</AcademicPaper>
	}
</Papers>,
concat("file:///G:/x/xml/ace/ace",$g,".xml"),"indent=yes"))
(: Stylus Studio meta-information - (c) 2004-2008. Progress Software Corporation. All rights reserved.

<metaInformation>
	<scenarios>
		<scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" useresolver="yes" url="" outputurl="" processortype="datadirect" tcpport="0" profilemode="0" profiledepth="" profilelength="" urlprofilexml="" commandline=""
		          additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" host="" port="0" user="" password="" validateoutput="no" validator="internal"
		          customvalidator="">
			<collection name="sqlserver_localhost_1433" url="jdbc:xquery:sqlserver://localhost:1433;schema=dbo;user=excite;password=472A67295837;xmlforest=true;DatabaseName=xAce;urltype=.xml"/>
		</scenario>
	</scenarios>
	<MapperMetaTag>
		<MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/>
		<MapperBlockPosition>
			<template name="xquery_body">
				<block path="flwr" x="291" y="0"/>
				<block path='( ddtek:serialize-to-url(&lt;Papers&gt;&#xD;&#xA;&#x9;{ for $singles1 in $group return &lt;AcademicPaper&gt; { for $Titles in collection("xAce.dbo.Title")~Title where $Titles~autoID = $singles1~autoID return &lt;Titles&gt; { if( $Titles~TI ) then&lt;Title&gt; { $Titles~TI~text() }&lt;~Title&gt; else () } { if( $Titles~FT ) then&lt;ForeignTitle&gt; { $Titles~FT~text() }&lt;~ForeignTitle&gt; else () } { if( $Titles~Orig ) then&lt;Original&gt; { $Titles~Orig~text() }&lt;~Original&gt; else () } { if( $Titles~Gister ) then&lt;Gister&gt; { $Titles~Gister~text() }&lt;~Gister&gt; else () } { if( $Titles~Lambda ) then&lt;Lambda&gt; { $Titles~Lambda~text() }&lt;~Lambda&gt; else () } { if( $Titles~Systran5 ) then&lt;Systran5&gt; { $Titles~Systran5~text() }&lt;~Systran5&gt; else () } { if( $Titles~Sigma ) then&lt;Sigma&gt; { $Titles~Sigma~text() }&lt;~Sigma&gt; else () }&lt;~Titles&gt; }&lt;ThesisType&gt; { $singles1~ThesisType~text() }&lt;~ThesisType&gt;&lt;PersonalNameSubject&gt; { $singles1~PNS~text() }&lt;~PersonalNameSubject&gt;&lt;Source&gt; { $singles1~SO~text() }&lt;~Source&gt;&lt;Series&gt; { $singles1~SE~text() }&lt;~Series&gt;&lt;PublicationDate&gt; { $singles1~PD~text() }&lt;~PublicationDate&gt;&lt;YearPublished&gt; { $singles1~PY~text() }&lt;~YearPublished&gt;&lt;PublishingModel&gt; { $singles1~PUBM~text() }&lt;~PublishingModel&gt;&lt;DateCreated&gt; { $singles1~DA~text() }&lt;~DateCreated&gt;&lt;DateElectronicPublication&gt; { $singles1~DEP~text() }&lt;~DateElectronicPublication&gt;&lt;EntrezDate&gt; { $singles1~EDAT~text() }&lt;~EntrezDate&gt;&lt;MeSHDate&gt; { $singles1~MHDA~text() }&lt;~MeSHDate&gt; { for $PHST in collection("xAce.dbo.PHST")~PHST where $PHST~autoID = $singles1~autoID return &lt;PublicationHistory&gt;&lt;PublicationHistoryStatusDate&gt; { $PHST~PHST~text() }&lt;~PublicationHistoryStatusDate&gt;&lt;~PublicationHistory&gt; }&lt;LastRevisionDate&gt; { $singles1~LR~text() }&lt;~LastRevisionDate&gt;&lt;PublicationStatus&gt; { $singles1~PST~text() }&lt;~PublicationStatus&gt;&lt;StatusTag&gt; { $singles1~STAT~text() }&lt;~StatusTag&gt;&lt;Volume&gt; { $singles1~VL~text() }&lt;~Volume&gt;&lt;Issue&gt; { $singles1~IS~text() }&lt;~Issue&gt;&lt;Supplement&gt; { $singles1~SU~text() }&lt;~Supplement&gt;&lt;SpecialIssue&gt; { $singles1~SI~text() }&lt;~SpecialIssue&gt;&lt;BeginningPage&gt; { $singles1~BP~text() }&lt;~BeginningPage&gt;&lt;EndingPage&gt; { $singles1~EP~text() }&lt;~EndingPage&gt;&lt;PageSpan&gt; { $singles1~PS~text() }&lt;~PageSpan&gt;&lt;Authors&gt; { for $Authors in collection("xAce.dbo.Authors")~Authors where $singles1~autoID = $Authors~autoID return &lt;Author&gt; { if( $Authors~AU ) then&lt;AuthorShortName&gt; { $Authors~AU~text() }&lt;~AuthorShortName&gt; else () } { if( $Authors~AF ) then&lt;AuthorFullName&gt; { $Authors~AF~text() }&lt;~AuthorFullName&gt; else () } { if( $Authors~BAU ) then&lt;AuthorNameBiomed&gt; { $Authors~BAU~text() }&lt;~AuthorNameBiomed&gt; else () } { if( $Authors~C1 ) then&lt;AuthorAddress&gt; { $Authors~C1~text() }&lt;~AuthorAddress&gt; else () } { if( $Authors~EM ) then&lt;AuthorEmail&gt; { $Authors~EM~text() }&lt;~AuthorEmail&gt; else () }&lt;~Author&gt; }&lt;~Authors&gt; { for $IDOCAuthor in collection("xAce.dbo.IDOCAuthor")~IDOCAuthor where $IDOCAuthor~autoID = $singles1~autoID return &lt;IDOCAuthor&gt;&lt;Original&gt; { $IDOCAuthor~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAuthor~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAuthor~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAuthor~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAuthor~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAuthor&gt; } { for $IDOCAdvisor in collection("xAce.dbo.IDOCAdvisor")~IDOCAdvisor where $IDOCAdvisor~autoID = $singles1~autoID return &lt;IDOCAdvisor&gt;&lt;Original&gt; { $IDOCAdvisor~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAdvisor~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAdvisor~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAdvisor~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAdvisor~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAdvisor&gt; } { for $BA in collection("xAce.dbo.BA")~BA where $BA~autoID = $singles1~autoID return &lt;BookAuthors&gt;&lt;BookAuthor&gt; { $BA~BA~text() }&lt;~BookAuthor&gt;&lt;~BookAuthors&gt; } { for $BE in collection("xAce.dbo.BE")~BE where $BE~autoID = $singles1~autoID return &lt;Editors&gt;&lt;Editor&gt; { $BE~BE~text() }&lt;~Editor&gt;&lt;~Editors&gt; }&lt;Affiliation&gt; { $singles1~AD~text() }&lt;~Affiliation&gt;&lt;University&gt; { $singles1~University~text() }&lt;~University&gt;&lt;UniversityAddress&gt; { $singles1~UniversityAddress~text() }&lt;~UniversityAddress&gt; { for $CA in collection("xAce.dbo.CA")~CA where $CA~autoID = $singles1~autoID return &lt;CorporateAuthors&gt;&lt;CorporateAuthor&gt; { $CA~CA~text() }&lt;~CorporateAuthor&gt;&lt;~CorporateAuthors&gt; }&lt;ReprintAddress&gt; { $singles1~RP~text() }&lt;~ReprintAddress&gt;&lt;Owner&gt; { $singles1~OWN~text() }&lt;~Owner&gt; { for $SC in collection("xAce.dbo.SC")~SC where $SC~autoID = $singles1~autoID return &lt;SubjectCategories&gt;&lt;SubjectCategory&gt; { $SC~SC~text() }&lt;~SubjectCategory&gt;&lt;~SubjectCategories&gt; } { for $CC in collection("xAce.dbo.CC")~CC where $CC~autoID = $singles1~autoID return &lt;ConceptCodes&gt;&lt;ConceptCode&gt; { $CC~CC~text() }&lt;~ConceptCode&gt;&lt;~ConceptCodes&gt; }&lt;Subset&gt; { $singles1~SB~text() }&lt;~Subset&gt; { for $CH in collection("xAce.dbo.CH")~CH where $CH~autoID = $singles1~autoID return &lt;ChemicalBioChemicals&gt;&lt;ChemicalBioChemical&gt; { $CH~CH~text() }&lt;~ChemicalBioChemical&gt;&lt;~ChemicalBioChemicals&gt; } { for $DS in collection("xAce.dbo.DS")~DS where $DS~autoID = $singles1~autoID return &lt;Diseases&gt;&lt;Disease&gt; { $DS~DS~text() }&lt;~Disease&gt;&lt;~Diseases&gt; } { for $GE in collection("xAce.dbo.GE")~GE where $GE~autoID = $singles1~autoID return &lt;GeographicData&gt;&lt;Geography&gt; { $GE~GE~text() }&lt;~Geography&gt;&lt;~GeographicData&gt; } { for $MQ in collection("xAce.dbo.MQ")~MQ where $MQ~autoID = $singles1~autoID return &lt;MethodsEquipment&gt;&lt;MethodEquipment&gt; { $MQ~MQ~text() }&lt;~MethodEquipment&gt;&lt;~MethodsEquipment&gt; } { for $GN in collection("xAce.dbo.GN")~GN where $GN~autoID = $singles1~autoID return &lt;GeneNameData&gt;&lt;GeneName&gt; { $GN~GN~text() }&lt;~GeneName&gt;&lt;~GeneNameData&gt; } { for $TA in collection("xAce.dbo.TA")~TA where $singles1~autoID = $TA~autoID return &lt;TaxonomicData&gt;&lt;Taxonomic&gt; { $TA~TA~text() }&lt;~Taxonomic&gt;&lt;~TaxonomicData&gt; } { for $TM in collection("xAce.dbo.TM")~TM where $singles1~autoID = $TM~autoID return &lt;GeologicTimeData&gt;&lt;GeologicTime&gt; { $TM~TM~text() }&lt;~GeologicTime&gt;&lt;~GeologicTimeData&gt; } { for $MC in collection("xAce.dbo.MC")~MC where $singles1~autoID = $MC~autoID return &lt;MajorConcepts&gt;&lt;MajorConcept&gt; { $MC~MC~text() }&lt;~MajorConcept&gt;&lt;~MajorConcepts&gt; } { for $PR in collection("xAce.dbo.PR")~PR where $PR~autoID = $singles1~autoID return &lt;PartsStructuresSystems&gt;&lt;PartStructureSystem&gt; { $PR~PR~text() }&lt;~PartStructureSystem&gt;&lt;~PartsStructuresSystems&gt; } { for $SD in collection("xAce.dbo.SD")~SD where $singles1~autoID = $SD~autoID return &lt;Sequence&gt;&lt;SequenceData&gt; { $SD~SD~text() }&lt;~SequenceData&gt;&lt;~Sequence&gt; } { for $MH in collection("xAce.dbo.MH")~MH where $MH~autoID = $singles1~autoID return &lt;MeSHTerms&gt;&lt;MeSHTerm&gt; { $MH~MH~text() }&lt;~MeSHTerm&gt;&lt;~MeSHTerms&gt; } { for $DE in collection("xAce.dbo.DE")~DE where $DE~autoID = $singles1~autoID return &lt;AuthorKeywords&gt;&lt;AuthorKeyword&gt; { $DE~DE~text() }&lt;~AuthorKeyword&gt;&lt;~AuthorKeywords&gt; } { for $ID in collection("xAce.dbo.ID")~ID where $ID~autoID = $singles1~autoID return &lt;IndexKeywords&gt;&lt;IndexKeyword&gt; { $ID~ID~text() }&lt;~IndexKeyword&gt;&lt;~IndexKeywords&gt; }&lt;IDOCKeywords&gt; { for $IDOCKeyword in collection("xAce.dbo.IDOCKeyword")~IDOCKeyword where $IDOCKeyword~autoID = $singles1~autoID return &lt;IDOCKeyword&gt;&lt;Original&gt; { $IDOCKeyword~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCKeyword~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCKeyword~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCKeyword~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCKeyword~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCKeyword&gt; }&lt;~IDOCKeywords&gt;&lt;IDOCSubjectCategories&gt; { for $IDOCSubjectCategory in collection("xAce.dbo.IDOCSubjectCategory")~IDOCSubjectCategory where $IDOCSubjectCategory~autoID = $singles1~autoID return &lt;IDOCSubjectCategory&gt;&lt;Original&gt; { $IDOCSubjectCategory~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCSubjectCategory~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCSubjectCategory~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCSubjectCategory~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCSubjectCategory~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCSubjectCategory&gt; }&lt;~IDOCSubjectCategories&gt;&lt;PatentNumber&gt; { $singles1~PN~text() }&lt;~PatentNumber&gt; { for $Abstract in collection("xAce.dbo.Abstract")~Abstract where $Abstract~autoID = $singles1~autoID return &lt;Abstract&gt; { if( $Abstract~AB ) then&lt;Abstract&gt; { $Abstract~AB~text() }&lt;~Abstract&gt; else () } { if( $Abstract~Orig ) then&lt;Original&gt; { $Abstract~Orig~text() }&lt;~Original&gt; else () } { if( $Abstract~Gister ) then&lt;Gister&gt; { $Abstract~Gister~text() }&lt;~Gister&gt; else () } { if( $Abstract~Lambda ) then&lt;Lambda&gt; { $Abstract~Lambda~text() }&lt;~Lambda&gt; else () } { if( $Abstract~Systran5 ) then&lt;Systran5&gt; { $Abstract~Systran5~text() }&lt;~Systran5&gt; else () } { if( $Abstract~Sigma ) then&lt;Sigma&gt; { $Abstract~Sigma~text() }&lt;~Sigma&gt; else () }&lt;~Abstract&gt; } { for $IDOCAbstract in collection("xAce.dbo.IDOCAbstract")~IDOCAbstract where $IDOCAbstract~autoID = $singles1~autoID return &lt;IDOCAbstract&gt;&lt;Original&gt; { $IDOCAbstract~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAbstract~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAbstract~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAbstract~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAbstract~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAbstract&gt; } { for $AE in collection("xAce.dbo.AE")~AE where $AE~autoID = $singles1~autoID return &lt;PatentAssignees&gt;&lt;PatentAssignee&gt; { $AE~AE~text() }&lt;~PatentAssignee&gt;&lt;~PatentAssignees&gt; }&lt;DatePatentGranted&gt; { $singles1~DG~text() }&lt;~DatePatentGranted&gt;&lt;PatentCountry&gt; { $singles1~PC~text() }&lt;~PatentCountry&gt;&lt;PatentClass&gt; { $singles1~PL~text() }&lt;~PatentClass&gt; { for $CR in collection("xAce.dbo.CR")~CR where $CR~autoID = $singles1~autoID return &lt;CitedReferences&gt;&lt;CitedReference&gt; { $CR~CR~text() }&lt;~CitedReference&gt;&lt;~CitedReferences&gt; }&lt;CitedReferenceCount&gt; { $singles1~NR~text() }&lt;~CitedReferenceCount&gt;&lt;TimesCited&gt; { $singles1~TC~text() }&lt;~TimesCited&gt;&lt;LanguageOriginal&gt; { $singles1~LA~text() }&lt;~LanguageOriginal&gt; { for $DT in collection("xAce.dbo.DT")~DT where $DT~autoID = $singles1~autoID return &lt;DocumentTypes&gt;&lt;DocumentType&gt; { $DT~DT~text() }&lt;~DocumentType&gt;&lt;~DocumentTypes&gt; }&lt;LituratureType&gt; { $singles1~LT~text() }&lt;~LituratureType&gt;&lt;Medium&gt; { $singles1~ME~text() }&lt;~Medium&gt;&lt;PubType&gt; { $singles1~PT~text() }&lt;~PubType&gt;&lt;PublisherNameAddress&gt; { $singles1~PU~text() }&lt;~PublisherNameAddress&gt;&lt;PublisherCity&gt; { $singles1~PI~text() }&lt;~PublisherCity&gt;&lt;PublisherAddress&gt; { $singles1~PA~text() }&lt;~PublisherAddress&gt;&lt;MeetingTitle&gt; { $singles1~CT~text() }&lt;~MeetingTitle&gt;&lt;MeetingLocation&gt; { $singles1~CL~text() }&lt;~MeetingLocation&gt;&lt;MeetingDate&gt; { $singles1~CY~text() }&lt;~MeetingDate&gt; { for $SP in collection("xAce.dbo.SP")~SP where $singles1~autoID = $SP~autoID return &lt;MeetingSponsors&gt;&lt;MeetingSponsor&gt; { $SP~SP~text() }&lt;~MeetingSponsor&gt;&lt;~MeetingSponsors&gt; }&lt;CharacterSourceAbbreviation&gt; { $singles1~J9~text() }&lt;~CharacterSourceAbbreviation&gt;&lt;ISOSourceAbbreviation&gt; { $singles1~JI~text() }&lt;~ISOSourceAbbreviation&gt;&lt;FullJournalTitle&gt; { $singles1~JT~text() }&lt;~FullJournalTitle&gt;&lt;ArticleNumber&gt; { $singles1~AR~text() }&lt;~ArticleNumber&gt;&lt;DigitalObjectID&gt; { $singles1~DI~text() }&lt;~DigitalObjectID&gt;&lt;PageCount&gt; { $singles1~PG~text() }&lt;~PageCount&gt;&lt;FullTextHyperlink&gt; { $singles1~FullTextHyper~text() }&lt;~FullTextHyperlink&gt;&lt;ThomsonDocumentDeliverNumber&gt; { $singles1~GA~text() }&lt;~ThomsonDocumentDeliverNumber&gt;&lt;ThomsonUniqueArticleID&gt; { $singles1~UT~text() }&lt;~ThomsonUniqueArticleID&gt;&lt;BiosisArticleNumber&gt; { $singles1~AN~text() }&lt;~BiosisArticleNumber&gt; { for $AID in collection("xAce.dbo.AID")~AID where $AID~autoID = $singles1~autoID return &lt;ArticleIdentifiers&gt;&lt;ArticleIdentifier&gt; { $AID~AID~text() }&lt;~ArticleIdentifier&gt;&lt;~ArticleIdentifiers&gt; }&lt;ISSN&gt; { $singles1~SN~text() }&lt;~ISSN&gt;&lt;ISBN&gt; { $singles1~BN~text() }&lt;~ISBN&gt;&lt;NLMUniqueID&gt; { $singles1~JID~text() }&lt;~NLMUniqueID&gt;&lt;EcRnNumber&gt; { $singles1~RN~text() }&lt;~EcRnNumber&gt;&lt;IDOCID&gt; { $singles1~IDOCID~text() }&lt;~IDOCID&gt;&lt;SourcePath&gt; { $singles1~sourcePath~text() }&lt;~SourcePath&gt;&lt;SourceFile&gt; { $singles1~sourceFile~text() }&lt;~SourceFile&gt;&lt;SourceType&gt; { $singles1~sourceType~text() }&lt;~SourceType&gt;&lt;Classification&gt; { $singles1~classification~text() }&lt;~Classification&gt;&lt;~AcademicPaper&gt; }&#xD;&#xA;&lt;~Papers&gt;,concat("file:~~~G:~x~xml~ace~ace",$g,".xml"),"indent=yes"))'
				       x="223" y="0"/>
				<block path='( ddtek:serialize-to-url(&lt;Papers&gt;&#xD;&#xA;&#x9;{ for $singles1 in $group return &lt;AcademicPaper&gt; { for $Titles in collection("xAce.dbo.Title")~Title where $Titles~autoID = $singles1~autoID return &lt;Titles&gt; { if( $Titles~TI ) then&lt;Title&gt; { $Titles~TI~text() }&lt;~Title&gt; else () } { if( $Titles~FT ) then&lt;ForeignTitle&gt; { $Titles~FT~text() }&lt;~ForeignTitle&gt; else () } { if( $Titles~Orig ) then&lt;Original&gt; { $Titles~Orig~text() }&lt;~Original&gt; else () } { if( $Titles~Gister ) then&lt;Gister&gt; { $Titles~Gister~text() }&lt;~Gister&gt; else () } { if( $Titles~Lambda ) then&lt;Lambda&gt; { $Titles~Lambda~text() }&lt;~Lambda&gt; else () } { if( $Titles~Systran5 ) then&lt;Systran5&gt; { $Titles~Systran5~text() }&lt;~Systran5&gt; else () } { if( $Titles~Sigma ) then&lt;Sigma&gt; { $Titles~Sigma~text() }&lt;~Sigma&gt; else () }&lt;~Titles&gt; }&lt;ThesisType&gt; { $singles1~ThesisType~text() }&lt;~ThesisType&gt;&lt;PersonalNameSubject&gt; { $singles1~PNS~text() }&lt;~PersonalNameSubject&gt;&lt;Source&gt; { $singles1~SO~text() }&lt;~Source&gt;&lt;Series&gt; { $singles1~SE~text() }&lt;~Series&gt;&lt;PublicationDate&gt; { $singles1~PD~text() }&lt;~PublicationDate&gt;&lt;YearPublished&gt; { $singles1~PY~text() }&lt;~YearPublished&gt;&lt;PublishingModel&gt; { $singles1~PUBM~text() }&lt;~PublishingModel&gt;&lt;DateCreated&gt; { $singles1~DA~text() }&lt;~DateCreated&gt;&lt;DateElectronicPublication&gt; { $singles1~DEP~text() }&lt;~DateElectronicPublication&gt;&lt;EntrezDate&gt; { $singles1~EDAT~text() }&lt;~EntrezDate&gt;&lt;MeSHDate&gt; { $singles1~MHDA~text() }&lt;~MeSHDate&gt; { for $PHST in collection("xAce.dbo.PHST")~PHST where $PHST~autoID = $singles1~autoID return &lt;PublicationHistory&gt;&lt;PublicationHistoryStatusDate&gt; { $PHST~PHST~text() }&lt;~PublicationHistoryStatusDate&gt;&lt;~PublicationHistory&gt; }&lt;LastRevisionDate&gt; { $singles1~LR~text() }&lt;~LastRevisionDate&gt;&lt;PublicationStatus&gt; { $singles1~PST~text() }&lt;~PublicationStatus&gt;&lt;StatusTag&gt; { $singles1~STAT~text() }&lt;~StatusTag&gt;&lt;Volume&gt; { $singles1~VL~text() }&lt;~Volume&gt;&lt;Issue&gt; { $singles1~IS~text() }&lt;~Issue&gt;&lt;Supplement&gt; { $singles1~SU~text() }&lt;~Supplement&gt;&lt;SpecialIssue&gt; { $singles1~SI~text() }&lt;~SpecialIssue&gt;&lt;BeginningPage&gt; { $singles1~BP~text() }&lt;~BeginningPage&gt;&lt;EndingPage&gt; { $singles1~EP~text() }&lt;~EndingPage&gt;&lt;PageSpan&gt; { $singles1~PS~text() }&lt;~PageSpan&gt;&lt;Authors&gt; { for $Authors in collection("xAce.dbo.Authors")~Authors where $singles1~autoID = $Authors~autoID return &lt;Author&gt; { if( $Authors~AU ) then&lt;AuthorShortName&gt; { $Authors~AU~text() }&lt;~AuthorShortName&gt; else () } { if( $Authors~AF ) then&lt;AuthorFullName&gt; { $Authors~AF~text() }&lt;~AuthorFullName&gt; else () } { if( $Authors~BAU ) then&lt;AuthorNameBiomed&gt; { $Authors~BAU~text() }&lt;~AuthorNameBiomed&gt; else () } { if( $Authors~C1 ) then&lt;AuthorAddress&gt; { $Authors~C1~text() }&lt;~AuthorAddress&gt; else () } { if( $Authors~EM ) then&lt;AuthorEmail&gt; { $Authors~EM~text() }&lt;~AuthorEmail&gt; else () }&lt;~Author&gt; }&lt;~Authors&gt; { for $IDOCAuthor in collection("xAce.dbo.IDOCAuthor")~IDOCAuthor where $IDOCAuthor~autoID = $singles1~autoID return &lt;IDOCAuthor&gt;&lt;Original&gt; { $IDOCAuthor~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAuthor~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAuthor~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAuthor~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAuthor~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAuthor&gt; } { for $IDOCAdvisor in collection("xAce.dbo.IDOCAdvisor")~IDOCAdvisor where $IDOCAdvisor~autoID = $singles1~autoID return &lt;IDOCAdvisor&gt;&lt;Original&gt; { $IDOCAdvisor~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAdvisor~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAdvisor~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAdvisor~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAdvisor~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAdvisor&gt; } { for $BA in collection("xAce.dbo.BA")~BA where $BA~autoID = $singles1~autoID return &lt;BookAuthors&gt;&lt;BookAuthor&gt; { $BA~BA~text() }&lt;~BookAuthor&gt;&lt;~BookAuthors&gt; } { for $BE in collection("xAce.dbo.BE")~BE where $BE~autoID = $singles1~autoID return &lt;Editors&gt;&lt;Editor&gt; { $BE~BE~text() }&lt;~Editor&gt;&lt;~Editors&gt; }&lt;Affiliation&gt; { $singles1~AD~text() }&lt;~Affiliation&gt;&lt;University&gt; { $singles1~University~text() }&lt;~University&gt;&lt;UniversityAddress&gt; { $singles1~UniversityAddress~text() }&lt;~UniversityAddress&gt; { for $CA in collection("xAce.dbo.CA")~CA where $CA~autoID = $singles1~autoID return &lt;CorporateAuthors&gt;&lt;CorporateAuthor&gt; { $CA~CA~text() }&lt;~CorporateAuthor&gt;&lt;~CorporateAuthors&gt; }&lt;ReprintAddress&gt; { $singles1~RP~text() }&lt;~ReprintAddress&gt;&lt;Owner&gt; { $singles1~OWN~text() }&lt;~Owner&gt; { for $SC in collection("xAce.dbo.SC")~SC where $SC~autoID = $singles1~autoID return &lt;SubjectCategories&gt;&lt;SubjectCategory&gt; { $SC~SC~text() }&lt;~SubjectCategory&gt;&lt;~SubjectCategories&gt; } { for $CC in collection("xAce.dbo.CC")~CC where $CC~autoID = $singles1~autoID return &lt;ConceptCodes&gt;&lt;ConceptCode&gt; { $CC~CC~text() }&lt;~ConceptCode&gt;&lt;~ConceptCodes&gt; }&lt;Subset&gt; { $singles1~SB~text() }&lt;~Subset&gt; { for $CH in collection("xAce.dbo.CH")~CH where $CH~autoID = $singles1~autoID return &lt;ChemicalBioChemicals&gt;&lt;ChemicalBioChemical&gt; { $CH~CH~text() }&lt;~ChemicalBioChemical&gt;&lt;~ChemicalBioChemicals&gt; } { for $DS in collection("xAce.dbo.DS")~DS where $DS~autoID = $singles1~autoID return &lt;Diseases&gt;&lt;Disease&gt; { $DS~DS~text() }&lt;~Disease&gt;&lt;~Diseases&gt; } { for $GE in collection("xAce.dbo.GE")~GE where $GE~autoID = $singles1~autoID return &lt;GeographicData&gt;&lt;Geography&gt; { $GE~GE~text() }&lt;~Geography&gt;&lt;~GeographicData&gt; } { for $MQ in collection("xAce.dbo.MQ")~MQ where $MQ~autoID = $singles1~autoID return &lt;MethodsEquipment&gt;&lt;MethodEquipment&gt; { $MQ~MQ~text() }&lt;~MethodEquipment&gt;&lt;~MethodsEquipment&gt; } { for $GN in collection("xAce.dbo.GN")~GN where $GN~autoID = $singles1~autoID return &lt;GeneNameData&gt;&lt;GeneName&gt; { $GN~GN~text() }&lt;~GeneName&gt;&lt;~GeneNameData&gt; } { for $TA in collection("xAce.dbo.TA")~TA where $singles1~autoID = $TA~autoID return &lt;TaxonomicData&gt;&lt;Taxonomic&gt; { $TA~TA~text() }&lt;~Taxonomic&gt;&lt;~TaxonomicData&gt; } { for $TM in collection("xAce.dbo.TM")~TM where $singles1~autoID = $TM~autoID return &lt;GeologicTimeData&gt;&lt;GeologicTime&gt; { $TM~TM~text() }&lt;~GeologicTime&gt;&lt;~GeologicTimeData&gt; } { for $MC in collection("xAce.dbo.MC")~MC where $singles1~autoID = $MC~autoID return &lt;MajorConcepts&gt;&lt;MajorConcept&gt; { $MC~MC~text() }&lt;~MajorConcept&gt;&lt;~MajorConcepts&gt; } { for $PR in collection("xAce.dbo.PR")~PR where $PR~autoID = $singles1~autoID return &lt;PartsStructuresSystems&gt;&lt;PartStructureSystem&gt; { $PR~PR~text() }&lt;~PartStructureSystem&gt;&lt;~PartsStructuresSystems&gt; } { for $SD in collection("xAce.dbo.SD")~SD where $singles1~autoID = $SD~autoID return &lt;Sequence&gt;&lt;SequenceData&gt; { $SD~SD~text() }&lt;~SequenceData&gt;&lt;~Sequence&gt; } { for $MH in collection("xAce.dbo.MH")~MH where $MH~autoID = $singles1~autoID return &lt;MeSHTerms&gt;&lt;MeSHTerm&gt; { $MH~MH~text() }&lt;~MeSHTerm&gt;&lt;~MeSHTerms&gt; } { for $DE in collection("xAce.dbo.DE")~DE where $DE~autoID = $singles1~autoID return &lt;AuthorKeywords&gt;&lt;AuthorKeyword&gt; { $DE~DE~text() }&lt;~AuthorKeyword&gt;&lt;~AuthorKeywords&gt; } { for $ID in collection("xAce.dbo.ID")~ID where $ID~autoID = $singles1~autoID return &lt;IndexKeywords&gt;&lt;IndexKeyword&gt; { $ID~ID~text() }&lt;~IndexKeyword&gt;&lt;~IndexKeywords&gt; }&lt;IDOCKeywords&gt; { for $IDOCKeyword in collection("xAce.dbo.IDOCKeyword")~IDOCKeyword where $IDOCKeyword~autoID = $singles1~autoID return &lt;IDOCKeyword&gt;&lt;Original&gt; { $IDOCKeyword~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCKeyword~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCKeyword~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCKeyword~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCKeyword~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCKeyword&gt; }&lt;~IDOCKeywords&gt;&lt;IDOCSubjectCategories&gt; { for $IDOCSubjectCategory in collection("xAce.dbo.IDOCSubjectCategory")~IDOCSubjectCategory where $IDOCSubjectCategory~autoID = $singles1~autoID return &lt;IDOCSubjectCategory&gt;&lt;Original&gt; { $IDOCSubjectCategory~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCSubjectCategory~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCSubjectCategory~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCSubjectCategory~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCSubjectCategory~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCSubjectCategory&gt; }&lt;~IDOCSubjectCategories&gt;&lt;PatentNumber&gt; { $singles1~PN~text() }&lt;~PatentNumber&gt; { for $Abstract in collection("xAce.dbo.Abstract")~Abstract where $Abstract~autoID = $singles1~autoID return &lt;Abstract&gt; { if( $Abstract~AB ) then&lt;Abstract&gt; { $Abstract~AB~text() }&lt;~Abstract&gt; else () } { if( $Abstract~Orig ) then&lt;Original&gt; { $Abstract~Orig~text() }&lt;~Original&gt; else () } { if( $Abstract~Gister ) then&lt;Gister&gt; { $Abstract~Gister~text() }&lt;~Gister&gt; else () } { if( $Abstract~Lambda ) then&lt;Lambda&gt; { $Abstract~Lambda~text() }&lt;~Lambda&gt; else () } { if( $Abstract~Systran5 ) then&lt;Systran5&gt; { $Abstract~Systran5~text() }&lt;~Systran5&gt; else () } { if( $Abstract~Sigma ) then&lt;Sigma&gt; { $Abstract~Sigma~text() }&lt;~Sigma&gt; else () }&lt;~Abstract&gt; } { for $IDOCAbstract in collection("xAce.dbo.IDOCAbstract")~IDOCAbstract where $IDOCAbstract~autoID = $singles1~autoID return &lt;IDOCAbstract&gt;&lt;Original&gt; { $IDOCAbstract~Orig~text() }&lt;~Original&gt;&lt;Gister&gt; { $IDOCAbstract~Gister~text() }&lt;~Gister&gt;&lt;Lambda&gt; { $IDOCAbstract~Lambda~text() }&lt;~Lambda&gt;&lt;Systran5&gt; { $IDOCAbstract~Systran5~text() }&lt;~Systran5&gt;&lt;Sigma&gt; { $IDOCAbstract~Sigma~text() }&lt;~Sigma&gt;&lt;~IDOCAbstract&gt; } { for $AE in collection("xAce.dbo.AE")~AE where $AE~autoID = $singles1~autoID return &lt;PatentAssignees&gt;&lt;PatentAssignee&gt; { $AE~AE~text() }&lt;~PatentAssignee&gt;&lt;~PatentAssignees&gt; }&lt;DatePatentGranted&gt; { $singles1~DG~text() }&lt;~DatePatentGranted&gt;&lt;PatentCountry&gt; { $singles1~PC~text() }&lt;~PatentCountry&gt;&lt;PatentClass&gt; { $singles1~PL~text() }&lt;~PatentClass&gt; { for $CR in collection("xAce.dbo.CR")~CR where $CR~autoID = $singles1~autoID return &lt;CitedReferences&gt;&lt;CitedReference&gt; { $CR~CR~text() }&lt;~CitedReference&gt;&lt;~CitedReferences&gt; }&lt;CitedReferenceCount&gt; { $singles1~NR~text() }&lt;~CitedReferenceCount&gt;&lt;TimesCited&gt; { $singles1~TC~text() }&lt;~TimesCited&gt;&lt;LanguageOriginal&gt; { $singles1~LA~text() }&lt;~LanguageOriginal&gt; { for $DT in collection("xAce.dbo.DT")~DT where $DT~autoID = $singles1~autoID return &lt;DocumentTypes&gt;&lt;DocumentType&gt; { $DT~DT~text() }&lt;~DocumentType&gt;&lt;~DocumentTypes&gt; }&lt;LituratureType&gt; { $singles1~LT~text() }&lt;~LituratureType&gt;&lt;Medium&gt; { $singles1~ME~text() }&lt;~Medium&gt;&lt;PubType&gt; { $singles1~PT~text() }&lt;~PubType&gt;&lt;PublisherNameAddress&gt; { $singles1~PU~text() }&lt;~PublisherNameAddress&gt;&lt;PublisherCity&gt; { $singles1~PI~text() }&lt;~PublisherCity&gt;&lt;PublisherAddress&gt; { $singles1~PA~text() }&lt;~PublisherAddress&gt;&lt;MeetingTitle&gt; { $singles1~CT~text() }&lt;~MeetingTitle&gt;&lt;MeetingLocation&gt; { $singles1~CL~text() }&lt;~MeetingLocation&gt;&lt;MeetingDate&gt; { $singles1~CY~text() }&lt;~MeetingDate&gt; { for $SP in collection("xAce.dbo.SP")~SP where $singles1~autoID = $SP~autoID return &lt;MeetingSponsors&gt;&lt;MeetingSponsor&gt; { $SP~SP~text() }&lt;~MeetingSponsor&gt;&lt;~MeetingSponsors&gt; }&lt;CharacterSourceAbbreviation&gt; { $singles1~J9~text() }&lt;~CharacterSourceAbbreviation&gt;&lt;ISOSourceAbbreviation&gt; { $singles1~JI~text() }&lt;~ISOSourceAbbreviation&gt;&lt;FullJournalTitle&gt; { $singles1~JT~text() }&lt;~FullJournalTitle&gt;&lt;ArticleNumber&gt; { $singles1~AR~text() }&lt;~ArticleNumber&gt;&lt;DigitalObjectID&gt; { $singles1~DI~text() }&lt;~DigitalObjectID&gt;&lt;PageCount&gt; { $singles1~PG~text() }&lt;~PageCount&gt;&lt;FullTextHyperlink&gt; { $singles1~FullTextHyper~text() }&lt;~FullTextHyperlink&gt;&lt;ThomsonDocumentDeliverNumber&gt; { $singles1~GA~text() }&lt;~ThomsonDocumentDeliverNumber&gt;&lt;ThomsonUniqueArticleID&gt; { $singles1~UT~text() }&lt;~ThomsonUniqueArticleID&gt;&lt;BiosisArticleNumber&gt; { $singles1~AN~text() }&lt;~BiosisArticleNumber&gt; { for $AID in collection("xAce.dbo.AID")~AID where $AID~autoID = $singles1~autoID return &lt;ArticleIdentifiers&gt;&lt;ArticleIdentifier&gt; { $AID~AID~text() }&lt;~ArticleIdentifier&gt;&lt;~ArticleIdentifiers&gt; }&lt;ISSN&gt; { $singles1~SN~text() }&lt;~ISSN&gt;&lt;ISBN&gt; { $singles1~BN~text() }&lt;~ISBN&gt;&lt;NLMUniqueID&gt; { $singles1~JID~text() }&lt;~NLMUniqueID&gt;&lt;EcRnNumber&gt; { $singles1~RN~text() }&lt;~EcRnNumber&gt;&lt;IDOCID&gt; { $singles1~IDOCID~text() }&lt;~IDOCID&gt;&lt;SourcePath&gt; { $singles1~sourcePath~text() }&lt;~SourcePath&gt;&lt;SourceFile&gt; { $singles1~sourceFile~text() }&lt;~SourceFile&gt;&lt;SourceType&gt; { $singles1~sourceType~text() }&lt;~SourceType&gt;&lt;Classification&gt; { $singles1~classification~text() }&lt;~Classification&gt;&lt;~AcademicPaper&gt; }&#xD;&#xA;&lt;~Papers&gt;,concat("file:~~~G:~x~xml~ace~ace",$g,".xml"),"indent=yes"))/concat[1]'
				       x="177" y="22"/>
			</template>
		</MapperBlockPosition>
		<TemplateContext></TemplateContext>
		<MapperFilter side="source"></MapperFilter>
	</MapperMetaTag>
</metaInformation>
:)