A simple solution would be to store the string "NULL" instead of null and then query.
On Wed, Mar 4, 2009 at 1:26 PM, Chris Lu <chris...@gmail.com> wrote: > Allahbaksh, > > If you ONLY want to find all document with a particular field that is not > null, you can loop through the TermEnum and TermDocs to find all the > document ids. > But this can not easily be combined with other queries. > > -- > > Chris Lu > > ------------------------- > > Instant Scalable Full-Text Search On Any Database/Application > > site: http://www.dbsight.net > > demo: http://search.dbsight.com > > Lucene Database Search in 3 minutes: > http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes > > DBSight customer, a shopping comparison site, (anonymous per request) got > 2.6 Million Euro funding! > > > > > Allahbaksh Mohammedali Asadullah wrote: > >> Hi, >> What is the optimum way in which I can find all the document which has >> particular field in it. >> >> Example >> I want to find all the document in which the field text is not null. >> >> Regards, >> Allahbaksh >> >> Allahbaksh Mohammedali Asadullah, >> Software Engineering & Technology Labs, >> Infosys Technolgies Limited, Electronics City, >> Hosur Road, Bangalore 560 100, India. >> *Board: +91-80-28520261 | Extn: 53915 | Direct: 41173915. >> Fax: +91-80-28520362 | Mobile: +91-9845505322. >> http://setlabs/slim/ >> http://allahbaksh.blogspot.com<http://allahbaksh.blogspot.com/> >> >> >> >> >> >> **************** CAUTION - Disclaimer ***************** >> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended >> solely for the use of the addressee(s). If you are not the intended >> recipient, please notify the sender by e-mail and delete the original >> message. Further, you are not to copy, disclose, or distribute this e-mail >> or its contents to any other person and any such actions are unlawful. This >> e-mail may contain viruses. Infosys has taken every reasonable precaution to >> minimize this risk, but is not liable for any damage you may sustain as a >> result of any virus in this e-mail. You should carry out your own virus >> checks before opening the e-mail or attachment. Infosys reserves the right >> to monitor and review the content of all messages sent to or from this >> e-mail address. Messages sent to or from this e-mail address may be stored >> on the Infosys e-mail system. >> ***INFOSYS******** End of Disclaimer ********INFOSYS*** >> >> >> > >
