Hi All
My document model looks like below
Subject Area1
<data>
<element1 active='2014-02-01T00:00:00'
inactive='9999-12-31T00:00:00'>A</element1>
<element1 active='2013-01-01T00:00:00'
inactive='2014-01-31T00:00:00'>B</element1>
<key active='2013-01-01T00:00:00' inactive='9999-12-31T00:00:00'>key0</key>
<data>
Subject Area2
<data>
<element2 active='2011-02-01T00:00:00'
inactive='9999-12-31T00:00:00'>AA</element2>
<element2 active='2010-01-01T00:00:00'
inactive='2011-01-31T00:00:00'>BB</element2>
<key active='2013-01-01T00:00:00' inactive='9999-12-31T00:00:00'>key0</key>
<data>
I need to join document of Subject Area1 document to Subject Area2 document
based on <key/> and fetch <element2/> value where
@inactive=9999-12-31T00:00:00. I can't run cts:search because both the volume
by count and size is extremely high.
I tried achieving through cts:values over path reference and created path range
index over ./data/element2[@inactive='9999-12-31T00:00:00'] but its throwing me
exception while re-indexing that item @inactive is dataTime data type and not
comparable with string.
Is there any way to create path range index with dataTime data type as
attribute value or is there any better way to address this.
Thanks
Abhishek
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient(s), please reply to the sender and
destroy all copies of the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email,
and/or any action taken in reliance on the contents of this e-mail is strictly
prohibited and may be unlawful. Where permitted by applicable law, this e-mail
and other e-mail communications sent to and from Cognizant e-mail addresses may
be monitored.
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
