complex queries

View: New views
3 Messages — Rating Filter:   Alert me  

complex queries

by Kevin Osborn-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I don't think this is possible, but I figure that I would ask.

So, I want to find documents that match a search term and where a field in those documents are also in the results of a subquery. Basically, I am looking for the Solr equivalent of doing a SQL IN clause.

As I said, I don't think it is possible and would be highly suprised if it was.


Re: complex queries

by Erik Hatcher :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On May 6, 2008, at 8:57 PM, Kevin Osborn wrote:
> I don't think this is possible, but I figure that I would ask.
>
> So, I want to find documents that match a search term and where a  
> field in those documents are also in the results of a subquery.  
> Basically, I am looking for the Solr equivalent of doing a SQL IN  
> clause.

"search clause" AND field:(value1 OR value2 OR value3)

does that do the trick for you?    If not, could you elaborate with  
an example?

        Erik


Re: complex queries

by Vicky_Dev :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Hi Erik,

Is it possible to get result of one solr query feed into another Solr Query?

Issue which I am facing right now is::
I am getting results from one query and I just need 2 index attribute values . These index attribute values are used for form new Query to Solr.

Since Solr gives result only for GET request, hence there is restriction on : forming query with all values.

Please do send your views on above problem

Thanks
~Vikrant


Erik Hatcher wrote:
On May 6, 2008, at 8:57 PM, Kevin Osborn wrote:
> I don't think this is possible, but I figure that I would ask.
>
> So, I want to find documents that match a search term and where a  
> field in those documents are also in the results of a subquery.  
> Basically, I am looking for the Solr equivalent of doing a SQL IN  
> clause.

"search clause" AND field:(value1 OR value2 OR value3)

does that do the trick for you?    If not, could you elaborate with  
an example?

        Erik