q=*:* -{!join from=aId to=id fromIndex=b}(-statusId:1)
On Tue, Dec 6, 2016 at 2:04 PM, Akshay Vadher <[email protected]>
wrote:
> I have posted a stackoverflow question too - http://stackoverflow.com/
> questions/40993515/solr-outer-join-not-join-query.
>
>
>
> I may be asking too much but I want to do a left outer join between two
> cores and get data from Aonly where B does not have related data.
>
> Following is exactly my equivalent SQL query (for simplicity I have
> removed other conditions),
>
> 1. SELECT A.* FROM A AS A
>
> WHERE A.ID NOT IN (SELECT B.A_ID FROM B AS B WHERE B.STATUS_ID != 1)
>
> I understand that solr join is actually subquery, I need data from only A.
>
> It would be very easy if the not was not there in where condition for sub
> query.
>
> For example,
>
> 2. SELECT A.* FROM A AS A
>
> WHERE A.ID IN (SELECT B.A_ID FROM B AS B WHERE B.STATUS_ID != 1)
>
> I can have q={!join from=aId to=id fromIndex=b}(-statusId:1).
>
> How can I do a nagete here, i.e. solr query for *1*
>
>
>
>
>
> Regards,
>
> Akshay Vadher
>
> Senior Software Engineer
>
> Synoverge Technologies Pvt. Ltd.
>
> [email protected] | +91 96620 59401
> <http://tel:+91%2096620%2059401/>
>
>
>
> “You know, sometimes all you need is twenty seconds of insane courage.
> Just literally twenty seconds of just embarrassing bravery. And I promise
> you, something great will come of it.”
> ― Benjamin Mee <http://www.goodreads.com/author/show/1350576.Benjamin_Mee>
> , *We Bought a Zoo <http://www.goodreads.com/work/quotes/3805656>*
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
>
> CONFIDENTIALITY NOTICE:
>
> The contents of this email message and any attachments are intended solely
> for the addressee(s) and may contain confidential and/or privileged
> information and may be legally protected from disclosure. If you are not the
> intended recipient of this message, or if this message has been addressed to
> you in error, please immediately alert the sender by reply email and then
> delete this message and any attachments. If you are not the intended
> recipient, you are hereby notified that any use, dissemination, copying, or
> storage of this message or its attachments is strictly prohibited
>
>
--
Sincerely yours
Mikhail Khludnev
