Hi Otis, Yes, that seems like one solution, however I have multiple opening and closing hours, within the same day. Therefore it might become somewhat complicated to manage the index. For now I shifted the business logic to the client and a second query is made to get the additional data. Thanks for the suggestion.
Indika On 20 November 2012 02:50, Otis Gospodnetic <otis.gospodne...@gmail.com>wrote: > Hi Indika, > > So my suggestion was to maybe consider changing the index structure and > pull open/close times into 1 or more fields in the main record, so you > don't have this problem all together. > > Otis > -- > Performance Monitoring - http://sematext.com/spm/index.html > Search Analytics - http://sematext.com/search-analytics/index.html > > > > > On Sun, Nov 18, 2012 at 10:39 PM, Indika Tantrigoda <indik...@gmail.com > >wrote: > > > Hi Otis, > > > > Actually I maintain a separate document for each open/close time along > with > > the date (i.e. Sunday =1, Monday =2). I was thinking if it would be > > possible to query Solr asking, give the next day's (can be current_day > +1) > > minimum opening time as a response field. > > > > Thanks, > > Indika > > > > On 19 November 2012 04:50, Otis Gospodnetic <otis.gospodne...@gmail.com > > >wrote: > > > > > Hi, > > > > > > Maybe your index needs to have a separate field for each day open/close > > > time. No join or extra query needed then. > > > > > > Otis > > > -- > > > Performance Monitoring - http://sematext.com/spm > > > On Nov 18, 2012 5:35 PM, "Indika Tantrigoda" <indik...@gmail.com> > wrote: > > > > > > > Thanks for the response. > > > > > > > > Erick, > > > > My use case is related to restaurant opening hours, In the same > request > > > to > > > > Solr I'd like to get the time when the restaurant opens the next > > > > day, preferably part of the fields returned, and this needs to be > > > > independent of the main queries search params. > > > > > > > > Yes, the Join wouldn't be suitable in this use case. > > > > > > > > Luis, > > > > I had thought of having the logic in the client side, but before > that I > > > > wanted to see if I could get the result from Solr itself. I > > > > am currently using SolrJ along with Spring. > > > > > > > > Thanks, > > > > Indika > > > > > > > > On 18 November 2012 21:49, Luis Cappa Banda <luisca...@gmail.com> > > wrote: > > > > > > > > > Hello! > > > > > > > > > > When queries become more and more complex and you need to apply one > > > > second > > > > > query with the resultant docs from the first one, or re-sort > results, > > > or > > > > > maybe add some promotional or special docs to the response, I > > recommend > > > > to > > > > > develop a Web App module that implements that complex business > logic > > > and > > > > > dispatches queries from your Client App to your Solr back-end. That > > > > module, > > > > > let's call Search Engine, lets you play with all those special use > > > cases. > > > > > If you are familiar with Java I suggest you to have a look at the > > > > > combination between SolrJ and Spring framework or Jersey. > > > > > > > > > > Regards, > > > > > > > > > > - Luis Cappa. > > > > > El 18/11/2012 15:15, "Indika Tantrigoda" <indik...@gmail.com> > > > escribió: > > > > > > > > > > > Hi All, > > > > > > > > > > > > I would like to get results of an query that is different from > the > > > main > > > > > > query as a new field. This query needs to be independent from any > > > > filter > > > > > > queries applied to the main query. I was trying to achieve this > by > > > > > > fl=_external_query_result:query($myQuery), however that result > > seems > > > to > > > > > be > > > > > > governed by any filter queries applied to the main query ? Is it > > > > possible > > > > > > to have a completely separate query in the fl list and return its > > > > result > > > > > > along with the results (per results), or would I need to create a > > > > > separate > > > > > > query on the client side to get the results of the independent > > query > > > > > (based > > > > > > on the results from the first query) ? > > > > > > > > > > > > Thanks in advance, > > > > > > Indika > > > > > > > > > > > > > > > > > > > > >