Search Query Questions

2009-05-14 Thread Chris Miller 

I have two questions:

1) How do I search for ALL items? For example, I provide a sort query  
parameter of "updated" and a rows query parameter of 10 to limit the  
query results. I still have to provide a search query, of course. What  
if I want to provide a list of ALL results that match this? Or, in  
this case, the most recent 10 updated documents?


2) How do I search for all documents with a field that has data? For  
example, I have a field "foo" that is optional and multi-valued. How  
do I search for documents that have this field set to anything.


Thanks,

Chris Miller
ServerMotion
www.servermotion.com

Re: Search Query Questions

2009-05-14 Thread Chris Miller 

Oh, one more question

3) Is there a way to effectively do a GROUP BY? For example, if I have  
a document that has a photoID attached to it, is there a way to return  
a set of results that does not duplicate the photoID field?


Thanks,

Chris Miller
ServerMotion
www.servermotion.com



On May 14, 2009, at 7:46 PM, Chris Miller wrote:


I have two questions:

1) How do I search for ALL items? For example, I provide a sort  
query parameter of "updated" and a rows query parameter of 10 to  
limit the query results. I still have to provide a search query, of  
course. What if I want to provide a list of ALL results that match  
this? Or, in this case, the most recent 10 updated documents?


2) How do I search for all documents with a field that has data? For  
example, I have a field "foo" that is optional and multi-valued. How  
do I search for documents that have this field set to anything.


Thanks,

Chris Miller
ServerMotion
www.servermotion.com