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/
