Hi Rushab,
use cts:and-query() to filter, documents with empty date element.
i.e. cts:element-query(xs:QName("DATE-ELEMENT"), cts:and-query(()))
please excuse the syntax or typo.
Cheers!
-Mihir
On Mon, Sep 23, 2013 at 3:00 AM, <[email protected]>wrote:
> Send General mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://developer.marklogic.com/mailman/listinfo/general
> or, via email, send a message with subject or body 'help' to
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of General digest..."
>
>
> Today's Topics:
>
> 1. Date Search (Metha, Rushabh)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 22 Sep 2013 13:30:55 +0000
> From: "Metha, Rushabh" <[email protected]>
> Subject: [MarkLogic Dev General] Date Search
> To: "[email protected]"
> <[email protected]>
> Message-ID:
> <
> 80AD0349C110C444B61294784AAF6D2A06A3DD@smtp_mail.bankofamerica.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
>
> I am performing a search:search query on an date element (which has a
> element date range index set).
> In the database some times the element date will have null value.
> When doing a search for a given date eq, gt or lt we are getting the
> documents as per search criteria but also getting the documents where the
> date element is blank.
> Please advise.
>
> Thanks,
> Rushabh Mehta
> Call:(W) +91 40 66674084
>
> ----------------------------------------------------------------------
> This message w/attachments (message) is intended solely for the use of the
> intended recipient(s) and may contain information that is privileged,
> confidential or proprietary. If you are not an intended recipient, please
> notify the sender, and then please delete and destroy all copies and
> attachments, and be advised that any review or dissemination of, or the
> taking of any action in reliance on, the information contained in or
> attached to this message is prohibited.
> Unless specifically indicated, this message is not an offer to sell or a
> solicitation of any investment products or other financial product or
> service, an official confirmation of any transaction, or an official
> statement of Sender. Subject to applicable law, Sender may intercept,
> monitor, review and retain e-communications (EC) traveling through its
> networks/systems and may produce any such EC to regulators, law
> enforcement, in litigation and as required by law.
> The laws of the country of each sender/recipient may impact the handling
> of EC, and EC may be archived, supervised and produced in countries other
> than the country in which you are located. This message cannot be
> guaranteed to be secure or free of errors or viruses. Attachments that are
> part of this EC may have additional important disclosures and disclaimers,
> which you should read. By messaging with Sender you consent to the
> foregoing.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://developer.marklogic.com/pipermail/general/attachments/20130922/a3148273/attachment-0001.html
>
> ------------------------------
>
> _______________________________________________
> General mailing list
> [email protected]
> http://developer.marklogic.com/mailman/listinfo/general
>
>
> End of General Digest, Vol 111, Issue 30
> ****************************************
>
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
