Martin, you should declare namespace in your query. For example, try the
following query:
declare default element namespace "http://www.cdisc.org/ns/odm/v1.3";;
for $a in collection("MyCollection")
return $a//ODM/@ODMVersion
Ivan Shcheklein,
Sedna Team
On Wed, Sep 9, 2009 at 4:04 PM, Lewis, Martin <[email protected]>wrote:
> Hello Ivan,
> Thanks for the help.
> I can provide an example of namespaces used in our typical XML file (CDISC
> standard), the only thing that I have changed is the "but" reference for
> privacy:
>
> <?xml version="1.0" encoding="iso-8859-1"?>
> <ODM xmlns:ds="http://www.w3.org/2000/09/xmldsig#"; xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"; xmlns:but="
> http://www.but.com/ODM/XMLSchema";
> xmlns="http://www.cdisc.org/ns/odm/v1.3"; FileType="Transactional"
> FileOID="20090804T131629394" CreationDateTime="2009-08-17T09:44:12"
> ODMVersion="1.3" Originator="tests"
> PriorFileOID="Tests_V1.0" SourceSystem="ODMClinicalRelease"
> SourceSystemVersion="1.1.12.0">
> <ClinicalData StudyOID="100000084" MetaDataVersionOID="2000000165">....
>
> Many thanks in advance,
> Martin.
>
>
> ------------------------------
> *From:* Ivan Shcheklein [mailto:[email protected]]
> *Sent:* Wednesday, September 09, 2009 4:15 AM
> *To:* [email protected]
> *Cc:* Lewis, Martin
> *Subject:* Re: [Sedna-discussion] Collection problem
>
> Hi Martin,
>
> It's likely that you use namespaces in your data. Can you give us an
> example of your documents?
>
> Ivan Shcheklein,
> Sedna Team
>
> On Wed, Sep 9, 2009 at 12:22 AM, Lewis, Martin <[email protected]>wrote:
>
>> Hello,
>> First, not sure that I am at the right place to ask for my problem, sorry
>> if it is not the case.
>> I have try to find answers in archives but all posts are more complex and
>> not very at my level (I'm a beginner in XML Query).
>>
>> My problem:
>> I use Sedna (version 3.2.18) and SednaAdmin (version 1.0) and when I try
>> do retrieve information inside collections, I have problems.
>>
>> The following code gives me all documents and is working well:
>> *for $a in collection("MyCollection")*
>> *return $a*
>>
>> Based on my reading, I should be able to write the following code and
>> retrieve all ODM elements:
>> for $a in collection("MyCollection")
>> return $a//ODM
>>
>> Or attributes:
>> for $a in collection("MyCollection")
>> return $a//ODM/@ODMVersion
>>
>> But these two queries doesn't give me any results (blank pages but no
>> errors).
>> Maybe I'm doing something wrong.
>> If you have any hints or advice for me, it would be a pleasure for me to
>> test them,
>> Thanks in advance for your help,
>> Martin.
>>
>> Notice: This e-mail message, together with any attachments, contains
>> information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
>> New Jersey, USA 08889), and/or its affiliates (which may be known
>> outside the United States as Merck Frosst, Merck Sharp & Dohme or
>> MSD and in Japan, as Banyu - direct contact information for affiliates is
>> available at http://www.merck.com/contact/contacts.html) that may be
>> confidential, proprietary copyrighted and/or legally privileged. It is
>> intended solely for the use of the individual or entity named on this
>> message. If you are not the intended recipient, and have received this
>> message in error, please notify us immediately by reply e-mail and
>> then delete it from your system.
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> Sedna-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>>
> Notice: This e-mail message, together with any attachments, contains
> information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
> New Jersey, USA 08889), and/or its affiliates (which may be known
> outside the United States as Merck Frosst, Merck Sharp & Dohme or
> MSD and in Japan, as Banyu - direct contact information for affiliates is
> available at http://www.merck.com/contact/contacts.html) that may be
> confidential, proprietary copyrighted and/or legally privileged. It is
> intended solely for the use of the individual or entity named on this
> message. If you are not the intended recipient, and have received this
> message in error, please notify us immediately by reply e-mail and
> then delete it from your system.
>
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
