Hello Lee,
I thought maybe this is a solution:
I can index every night the correct openinghours for next day. So
tonight(00:01) i can index the openinghours for 2011-24-06. My query in my
dih can looks like this:
select *
from OPENINGHOURS o
where o.startdate <= NOW() AND o.enddate >= NOW()
AND o.companyid = '${OTHER_ENTITY.companyid}'
With this query i only save the openinghours for today. So i have only one
field(openinghours).
Openinghours
18:00
Then i can facets easilty on openinghours(facet.field=openinghours).
I don't know if i can update it every night without problems? I can use the
delte import?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Complex-situation-tp3071936p3099468.html
Sent from the Solr - User mailing list archive at Nabble.com.
