Ahh, once i fixed the misplaced paren, I can get back a proper error that
tells me something more useful -- No dateTime element-attribute range index
for fn:QName("", "PUBLICATION-DATE") fn:QName("", "datetime")
Thanks! - I think I know where to go from here :)
XDMP-ELEMATTRRIDXNOTFOUND: cts:search(fn:collection(),
cts:and-query((cts:directory-query("/data-sources/sbm/", "infinity"),
cts:or-query((cts:element-query(xs:QName("sum:PUBLICATION-NAME"),
cts:word-query("BenefitsPro.com", ("lang=en"), 1), ()),
cts:element-query(xs:QName("sum:PUBLICATION-NAME"),
cts:word-query("CUTimes", ("lang=en"), 1), ()),
cts:element-query(xs:QName("sum:PUBLICATION-NAME"),
cts:word-query("Treasury & Risk", ("lang=en"), 1), ()), ...)),
cts:element-attribute-range-query(fn:QName("", "PUBLICATION-DATE"),
fn:QName("", "datetime"), ">=", xs:dateTime("2017-08-23T23:59:00Z"), (),
1)), ())) -- No dateTime element-attribute range index for fn:QName("",
"PUBLICATION-DATE") fn:QName("", "datetime")
On Fri, Sep 22, 2017 at 8:15 AM, Christopher Hamlin <[email protected]>
wrote:
> I'm not sure what is the real problem.
>
> xs:dateTime ('2003-08-01T08:00:00Z') > xs:dateTime (fn:current-date()
> - xs:dayTimeDuration("P30D"))
> ,
> xs:dateTime ('2017-09-28T00:00:00-04:00') > xs:dateTime
> (fn:current-date() - xs:dayTimeDuration("P30D"))
>
> return false and true, no failure. What type is the index, and what
> is the failure?
>
> On Fri, Sep 22, 2017 at 11:10 AM, Geert Josten
> <[email protected]> wrote:
> > Hi Kari,
> >
> > Looks like you misplaced one of the parentheses. Make sure to wrap the
> > string "2017-09-22T08:00:00Z” in xs:dateTime(..) before you try to
> substract
> > the duration. In provided query you have the xs dateTime cast wrapping
> both
> > current-date and the duration.
> >
> > Cheers,
> > Geert
> >
> > From: <[email protected]> on behalf of Kari Cowan
> > <[email protected]>
> > Reply-To: MarkLogic Developer Discussion <[email protected].
> com>
> > Date: Friday, September 22, 2017 at 4:51 PM
> > To: MarkLogic Developer Discussion <[email protected]>
> > Subject: [MarkLogic Dev General] Querying DateTime values
> >
> > I need some expert tips on this bug.
> >
> > cts:element-attribute-range-query(xs:QName("PUBLICATION-
> DATE"),xs:QName("datetime"),
> > ">=", xs:dateTime(fn:current-date() - xs:dayTimeDuration("P30D")))
> >
> > The above query works fine when the publication-date is in this format:
> > <PUBLICATION-DATE date="2017-09-28"
> > datetime="2017-09-28T00:00:00-04:00">2017-09-28
> > 00:00:00:000</PUBLICATION-DATE>
> >
> > But it fails when
> > <PUBLICATION-DATE date="2003-08-01"
> > datetime="2003-08-01T08:00:00Z">2003-08-01T08:00:00Z</
> summary:PUBLICATION-DATE>
> >
> > The datetime format is different, but if I manipulate the current-date to
> > match that format, the query will fail with this message:
> >
> > [1.0-ml] XDMP-EXPR: (err:XPTY0004) "2017-09-22T08:00:00Z" -
> > xs:dayTimeDuration("P30D") -- Invalid expression
> >
> > How would I write the query to properly compare the dates?
> >
> > The goal above was to return content from the last 30 days.
> >
> >
> >
> >
> >
> > _______________________________________________
> > General mailing list
> > [email protected]
> > Manage your subscription at:
> > http://developer.marklogic.com/mailman/listinfo/general
> >
> _______________________________________________
> General mailing list
> [email protected]
> Manage your subscription at:
> http://developer.marklogic.com/mailman/listinfo/general
>
--
Kari Cowan :: Web Developer :: ALM Media
1035 Market St. Suite 550, San Francisco, CA 94103
iPhone/Text/FaceTime: +1 4157 444 762
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
