Hi
I have a scenario that I am not sure how to write the query for.
Here is the scenario - have an employee record with multi value for project,
started date, end date.
looks something like
John Smith web site bug fix 2010-01-01 2010-01-03
You didn't tell us what your schema looks like, what fields with what
types are involved.
But similar to how you'd do it in your database, you need to find
'documents' that have a start date before your date in question, and an
end date after your date in question, to find the ones whose
Thanks for the reply. We had the search within the database initially, but
it proven to be too slow. With solr we have much better performance.
One more question, how could I find the most current job for each employee
My data looks like
John Smith department A web site bug fix
I think there's something wrong with your database then, but okay.
You still haven't said what your Solr schema looks like -- that list of
values doesn't say what the solr field names or types are. I think this
is maybe because you don't actually have a Solr database and have no
idea how Solr