Hello,

I have some XML data that looks like this:

<SAMPLE>
<TEST>
<NAME>T1</NAME>
<DATA>data1</DATA>
<ALLOW>A</ALLOW>
<ALLOW>B</ALLOW>
</TEST>
<TEST>
<NAME>T2</NAME>
<DATA>data2</DATA>
<DENY>A</DENY>
<DENY>C</DENY>
</TEST>
<TEST>
<NAME>T3</NAME>
<DATA>data3</DATA>
</TEST>
</SAMPLE>

What Query would I use to select all TEST elements where

a) There is no "DENY" of "A".
This should select the TEST elements with NAMEs T1 and T3.

b) There is an "ALLOW" of "B".
This should select the TEST elements with NAME T1 only.

c) There is no "DENY" of "X".
This should select all three TEST elements.

d) There are no "ALLOW" elements at all. (i.e no specific ALLOW means
"allow all".)
This should select the test elements with NAMEs T2 and T3.

Is there a better way to structure the data?

Here is a start for "a)" above:

query '
<MATCHES>
{
for $t in doc("sample.dbxml/sample")/SAMPLE/TEST
where empty(doc(sample.dbxml/sample")/SAMPLE/TEST/[DENY/string()="A"])
return $t
}
</MATCHES>
'

Thanks.
Bob

Bob wrote:
collection()/SAMPLE/TEST[not(DENY = "A")]

collection()/SAMPLE/TEST[ALLOW = "B"]

See (a)

collection()/SAMPLE/TEST[empty(ALLOW)]

The structure of your data looks fine.

Hope this gets you started in using XQuery.

John

On Mon, 28 Nov 2005 07:59:26 -0800, John Snelson wrote:

.... clip examples ...

Thanks. That was a big help.