Changeset 673 for TI07-MOLES

Timestamp:

14/03/06 16:13:20 (15 years ago)

Author:

ko23

Message:

 

File:

• TI07-MOLES/trunk/StubB/XQuery/NDG-DEStubB.xquery (modified) (3 diffs)

TI07-MOLES/trunk/StubB/XQuery/NDG-DEStubB.xquery

@@ -1 @@
-for $DE in collection('/db/ndg_B_metadata')/dgMetadata/dgMetadataRecord[dgDataEntity!='' and dgMetadataID[schemeIdentifier='NDG-B0' and repositoryIdentifier='repositoryID' and localIdentifier='localID']]
+for $DE in collection('/db/ndg_B_metadata')/dgMetadata/dgMetadataRecord[exists('dgDataEntity') and dgMetadataID[schemeIdentifier='NDG-B0' and repositoryIdentifier='repositoryID' and localIdentifier='localID']]
 return
 <dgMetadataRecord>
@@ -78 +78 @@
                                 {for $DataOtherRolesRole in $DE/dgDataEntity/dgDataRoles/dgDataOtherRoles/dgRoleHolder 
                                         order by $DataOtherRolesRole/startDate empty least, $DataOtherRolesRole/endDate empty least
-                                        return 
+                                        return
                                                 <dgRoleHolder>
-                                                {for $DataOtherRolesRoleHolder in collection('/db/ndg_B_metadata')/dgMetadata/(dgOrganisation | dgPerson)[(dgMetadataID/schemeIdentifier='NDG-B0' and dgMetadataID/repositoryIdentifier=$DataOtherRolesRole/*/repositoryIdentifier and dgMetadataID/localIdentifier=$DataOtherRolesRole/*/localIdentifier)] return $DataOtherRolesRoleHolder}
+                                                        {if (exists($DataOtherRolesRole/dgOrganisationID)) then (
+                                                                for $DataOtherRolesRoleHolder in /dgMetadata/dgOrganisation[dgMetadataID[schemeIdentifier='NDG-B0' and repositoryIdentifier=$DataOtherRolesRole/dgOrganisationID/repositoryIdentifier and localIdentifier=$DataOtherRolesRole/dgOrganisationID/localIdentifier]]
+                                                                return $DataOtherRolesRoleHolder)
+                                                         else ()
+                                                        }
+                                                        {if (exists($DataOtherRolesRole/dgPersonID)) then (
+                                                                for $DataOtherRolesRoleHolder in /dgMetadata/dgPerson[dgMetadataID[schemeIdentifier='NDG-B0' and repositoryIdentifier=$DataOtherRolesRole/dgPersonID/repositoryIdentifier and localIdentifier=$DataOtherRolesRole/dgPersonID/localIdentifier]]
+                                                                return $DataOtherRolesRoleHolder)
+                                                         else ()
+                                                        }
                                                         {$DataOtherRolesRole/startDate}
                                                         {$DataOtherRolesRole/endDate}
@@ -166 +175 @@
         {$DE/MetadataSecurity}
 </dgMetadataRecord>
+(: Stylus Studio meta-information - (c) 2004-2005. Progress Software Corporation. All rights reserved.
+<metaInformation>
+<scenarios ><scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="..\..\..\..\..\..\..\My Documents\ndgBXML\ndgB.xml" outputurl="" processortype="internal" tcpport="2233" profilemode="0" profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" host="" port="8000" user="" password=""/></scenarios><MapperMetaTag><MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/><MapperBlockPosition></MapperBlockPosition></MapperMetaTag>
+</metaInformation>
+:)