[bdbxml] metadata queries
"Mark Robert Salamon" <[email protected]> Tue, 27 Sep 2005 10:21:04 -0400
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <[email protected]> |
------_=_NextPart_001_01C5C36E.B2183420
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I had two questions related to metadata-based queries. first, what
operators are available? I'm sure that the =3D, >, etc. queries are
available. Are any of the following SQL-like operators available (or
their equivalent), and can someone show me an example of each:
=20
between
=20
is null
=20
is not null
=20
in(a,b,c...)
=20
substring()/like -- and any wildcard or regex characters
=20
Second, how do you combine multiple queries together (metadata or
regular ones), and can you provide examples. For example, if I want to
look for documents with metadata author=3D'jsmith' and date-created >
2005-01-01, how would I do that? similar if i'm combining metadata and
regular queries at once. in other words, are the AND and OR operators
available for querying metadata and xml data and what is the syntax
like.
=20
Thanks!
------_=_NextPart_001_01C5C36E.B2183420
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial size=3D2>I had =
two questions=20
related to metadata-based queries. first, what operators are=20
available? I'm sure that the =3D, >, etc. queries are =
available. =20
Are any of the following SQL-like operators available (or their =
equivalent), and=20
can someone show me an example of each:</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005> <FONT =
face=3DArial=20
size=3D2>between</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005> <FONT =
face=3DArial=20
size=3D2>is null</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005> <FONT =
face=3DArial=20
size=3D2>is not null</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005> <FONT =
face=3DArial=20
size=3D2>in(a,b,c...)</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005> <FONT =
face=3DArial=20
size=3D2>substring()/like -- and any wildcard or regex=20
characters</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005></SPAN><SPAN =
class=3D642111614-27092005><FONT=20
face=3DArial size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial =
size=3D2>Second, how do you=20
combine multiple queries together (metadata or regular ones), and can =
you=20
provide examples. For example, if I want to look for documents =
with=20
metadata author=3D'jsmith' and date-created > 2005-01-01, how would I =
do=20
that? similar if i'm combining metadata and regular queries at =
once. =20
in other words, are the AND and OR operators available for querying =
metadata and=20
xml data and what is the syntax like.</FONT></SPAN></DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D642111614-27092005><FONT face=3DArial=20
size=3D2>Thanks!</FONT></SPAN></DIV></BODY></HTML>
------_=_NextPart_001_01C5C36E.B2183420--