Hi,
I have an xml in which date is stored as below:
<Date Year="2015" Month="11" Day="25">2015 Nov 25</Date>
Now I need to search for those elements in the xml those date falls between D1
and D2
where D1 = 2015-08-29 and D2 = 2015-12-03
sample XML( this is a big file,I have just taken few elements here) :
<DocumentList>
<Document>
<DocumentType>AM</DocumentType>
<ID>/docs/123.xml</ID>
<Number>0005002</Number>
<Date Year="2015" Month="11" Day="20">2015 Nov 20</Date>
</Document>
<Document>
<DocumentType>AM</DocumentType>
<ID>/docs/3456.xml</ID>
<Number>0005002</Number>
<Date Year="2016" Month="02" Day="25">2015 Nov 25</Date>
</Document>
<Document>
<AddedToSynopsysDate>2016-02-18T20:17:54.674+05:30</AddedToSynopsysDate>
<DocumentType>AM</DocumentType>
<ID>/docs/678.xml</ID>
<Number>0005002</Number>
<Date Year="2015" Month="11" Day="30">2015 Nov 30</Date>
</Document>
<DocumentList>
Do I need to create attribute range index for each (year, month and date)
Could you please help on this?
Note: We cant change the format in which the date is stored in the xml.
Thanks
Pragya
"This e-mail and any attachments transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential , proprietary or
privileged information. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of this e-mail or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful."
_______________________________________________
General mailing list
General@developer.marklogic.com
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
