And for 'present', you would pick some time far in the future: 2100-01-01T00:00:00Z
On 6/5/10, Israel Ekpo <israele...@gmail.com> wrote: > You need to make each document added to the index a 1 to 1 mapping for each > company and consultant combo > > <schema> > > <fields> > <!-- Concatenation of company and consultant id --> > <field name="consultant_id_company_id" type="string" indexed="true" > stored="true" required="true"/> > <field name="consultant_firstname" type="string" indexed="true" > stored="true" multiValued="false"/> > <field name="consultant_lastname" type="string" indexed="true" > stored="true" multiValued="false"/> > > <!-- The name of the company the consultant worked for --> > <field name="company" type="text" indexed="true" stored="true" > multiValued="false"/> > <field name="start_date" type="tdate" indexed="true" stored="true" > multiValued="false"/> > <field name="end_date" type="tdate" indexed="true" stored="true" > multiValued="false"/> > </fields> > > <defaultSearchField>text</defaultSearchField> > > <copyField source="consultant_firstname" dest="text"/> > <copyField source="consultant_lastname" dest="text"/> > <copyField source="company" dest="text"/> > > </schema> > > <!-- > > So for instance, you have 2 consultants > > Michael Davis and Tom Anderson who worked for AOL and Microsoft, Yahoo, > Google and Facebook. > > Michael Davis = 1 > Tom Anderson = 2 > > AOL = 1 > Microsoft = 2 > Yahoo = 3 > Google = 4 > Facebook = 5 > > This is how you would add the documents to the index > > --> > > <doc> > <consultant_id_company_id>1_1</consultant_id_company_id> > <consultant_firstname>Michael</consultant_firstname> > <consultant_lastname>Davis</consultant_lastname> > <company>AOL</company> > <start_date>2006-02-13T15:26:37Z</start_date> > <end_date>2008-02-13T15:26:37Z</end_date> > </doc> > > <doc> > <consultant_id_company_id>1_4</consultant_id_company_id> > <consultant_firstname>Michael</consultant_firstname> > <consultant_lastname>Davis</consultant_lastname> > <company>Google</company> > <start_date>2006-02-13T15:26:37Z</start_date> > <end_date>2009-02-13T15:26:37Z</end_date> > </doc> > > <doc> > <consultant_id_company_id>2_3</consultant_id_company_id> > <consultant_firstname>Tom</consultant_firstname> > <consultant_lastname>Anderson</consultant_lastname> > <company>Yahoo</company> > <start_date>2001-01-13T15:26:37Z</start_date> > <end_date>2009-02-13T15:26:37Z</end_date> > </doc> > > <doc> > <consultant_id_company_id>2_4</consultant_id_company_id> > <consultant_firstname>Tom</consultant_firstname> > <consultant_lastname>Anderson</consultant_lastname> > <company>Google</company> > <start_date>1999-02-13T15:26:37Z</start_date> > <end_date>2010-02-13T15:26:37Z</end_date> > </doc> > > > The you can search as > > q=company:X AND start_date:[X TO *] AND end_date:[* TO Z] > > On Fri, Jun 4, 2010 at 4:58 PM, Moazzam Khan <moazz...@gmail.com> wrote: > >> Hi guys, >> >> >> I have a list of consultants and the users (people who work for the >> company) are supposed to be able to search for consultants based on >> the time frame they worked for, for a company. For example, I should >> be able to search for all consultants who worked for Bear Stearns in >> the month of july. What is the best of accomplishing this? >> >> I was thinking of formatting the document like this >> >> <company> >> <name> Bear Stearns</name> >> <startDate>2000-01-01</startDate> >> <endDate>present</endDate> >> </company> >> <company> >> <name> AIG</name> >> <startDate>1999-01-01</startDate> >> <endDate>2000-01-01</endDate> >> </company> >> >> Is this possible? >> >> Thanks, >> >> Moazzam >> > > > > -- > "Good Enough" is not good enough. > To give anything less than your best is to sacrifice the gift. > Quality First. Measure Twice. Cut Once. > http://www.israelekpo.com/ > -- Lance Norskog goks...@gmail.com
