jsr-170 queries using a between statement

Rhythmyx Technical Discussion
1

I’m trying to create a simple query using a between statement. I’m trying to grab all content between specific dates … Here’s what I’ve tried …

select rx:sys_contentid, rx:displaytitle, rx:sys_contentstartdate from rx:camagPeContent WHERE rx:sys_contentstartdate BETWEEN (‘2008-01-01’) AND (‘2008-12-31’) ORDER BY sys_contentstartdate DESC

I’ve also tried

select rx:sys_contentid, rx:displaytitle, rx:sys_contentstartdate from rx:camagPeContent WHERE rx:sys_contentstartdate BETWEEN (‘2008-01-01 00:00:00’) AND (‘2008-12-31 23:59:59’) ORDER BY sys_contentstartdate DESC

but each time I just get an unexpected exception. Can one do between statements with this jsr stuff?

Shane

2

Shane,

JCR query language does not include a BETWEEN operator. The supported operators are:

[ul]
[li]< (less than)
[/li][li]> (greater than)
[/li][li]= (equals)
[/li][li]<= (less than or equal to)
[/li][li]>= (greater than or equal to)
[/li][li]<> (does not equal)
[/li][li]LIKE
[/li][/ul]

We document the supported operators in several places, including the Workbench Help and the Rhythmyx Implementation Guide.

RLJII