Re: Join with faceting and filtering

2015-10-05 Thread Mikhail Khludnev
Hello Troy, What a challenge!! On Thu, Oct 1, 2015 at 3:42 PM, Troy Edwards wrote: > > 2) It appears that I cannot have fromIndex=Contracts because it is very > large and has to be sharded. Per my understanding SolrCloud join does not > support multiple shards > .. but it doesn't mean it will

Re: Join with faceting and filtering

2015-10-01 Thread Troy Edwards
I had missed a field in ContractItem index (ClientId) *ContractItem* ContractItemId - string ItemId - string ClientId - string ContractCode - string (facet and filter on this) Priority - integer (order by priority descending) Active - boolean (filter on this) 2) It appears that I cannot have fr

Re: Join with faceting and filtering

2015-10-01 Thread Mikhail Khludnev
1. i'd say it's challenge. 2. can't you do the opposite filter active contracts, join them back to items, and facet then? q=(Description:colgate OR Categories:colgate OR Sellers:colgate)&fq={!join from=ItemId to=ItemId fromIndex=Contracts)Active:true&facet.field=SellersString 3. note: there is {!te

Join with faceting and filtering

2015-09-30 Thread Troy Edwards
I am working with the following indices *Item* ItemId - string Description - text (query on this) Categories - Multivalued text (query on this) Sellers - Multivalued text (query on this) SellersString - Multivalued string (Need to facet and filter on this) *ContractItem* ContractItemId - string