Hello everybody.
I'm trying to make a query to website repository using SQL language:
SELECT *
FROM nt:base
WHERE jcr:path LIKE '/a/b/%/%'
and sector='a'
and
(
(actionStartDate>='2006-01-01T00:00:00+0100' AND
actionStartDate<'2007-01-01T00:00:00+0100')
)
actionStartDate is a paragraph field (Date type). A page contains a
paragraph with actionStartDate = 2006-02-19 (the result is
'2006-02-18T23:00:00.000Z' if I print like a string, I'm in GMT+1 time
zone).
sector is a field (string) of the same paragrapth.
If I try to execute the sql:
SELECT *
FROM nt:base
WHERE jcr:path LIKE '/a/b/%/%'
and sector='a'
the result collection contains a Content node. This is the page that
contains this paragraph.
How can I filter SQL over repository with date fileds?
Thanks in advance.
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
