I'd just index the eventtype, eventby and eventtime as separate fields. Then queries something like eventtype:update AND eventtime:[<targettime> TO *].
Similarly for events update by pramod, the query would be something like: eventby:pramod AND eventtype:update HTH Erick On Wed, Jul 28, 2010 at 11:05 PM, Pramod Goyal <pramod.go...@gmail.com>wrote: > Hi, > I have a use case where i get a document and a list of events that has > happened on the document. For example > > First document: > Some text content > Events: > Event Type Event By Event Time > Update Pramod 06062010 2:30:00 > Update Raj 06062010 2:30:00 > View Rahul 07062010 1:30:00 > > > I would like to support queries like get all document Event Type = ? and > Event time greater than ? , also query like get all the documents Updated > by Pramod. > How should i design my schema to support this use case. > > Thanks, > Regards, > Pramod Goyal >