Hi Abhishek, If you are seeing errors upon reindexing, it probably means you have some data that does not match the type for your range index. If that is the case, you need to fix the data so it matches your type. Either that or just ignore the errors and those documents will not match your query for that value.
-Danny From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, April 08, 2015 5:44 PM To: [email protected] Subject: [MarkLogic Dev General] Path Range Index 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
