Re: Execute an independent query from the main query

2012-11-19 Thread Indika Tantrigoda 
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.comwrote:

 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

Re: Execute an independent query from the main query

2012-11-18 Thread Erick Erickson 
Depending on your use-case, you might be able to use the join
functionality. Be aware that this doesn't return the values of the
from field, so it may not be suitable.

_why_ do you want to do this? I'm wondering if this is an _XY_
problem.

Best,
Erick


On Sun, Nov 18, 2012 at 9:14 AM, Indika Tantrigoda indik...@gmail.comwrote:

 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

Re: Execute an independent query from the main query

2012-11-18 Thread Luis Cappa Banda 
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