I am a Apache Solr beginner. My data-config.xml contains this code
<entity name="event">
<field column="event_id" name="id" />
...
<entity name="request_history" query="select request_date, request_expiry_date from request_history where id=event.id">
<field column="request_date" name="start_date" />
<field column="request_expiry_date" name="expire_date" />
</entity>
AND following is what in shcema.xml file against those fields
<field name="start_date" type="tdate" indexed="true" stored="true" multiValued="true"/>
<field name="expire_date" type="tdate" indexed="true" stored="true" multiValued="true"/>
So, for a single event, there can be multiple requests hence multiple "start_date" and "expire_date". Now I need to find all requests within a date range and all requests not within a given date range, but not getting any way.