Hmm. That's surprising. If you're finding it's working well for you, then, uh, fantastic. It's certainly not the behaviour I would expect though.
On 3 Feb 2014, at 10:54 pm, [email protected] wrote: > Hi Pat, > > I agree, It would be better upgrade it. > > Could you explain me, please, in detail what do you mean about: And passing > nil in won't work, I'm afraid - an empty set is different to matching a nil > value in a set. ? > > I say so because, It's seems to work in my case. > > I mean: with a filter like this with: { product_ids: ids } -> [1,2,3,4] > obviously I can't find record (Digital assets) without a product association. > > But If I pass this array [1,2,3,4,nil] my search results include those > Digital assets without of an explicit product association. And It's what I > want. > > But I'm afraid of doing something wrong without see it > > Bye. > > Il giorno lunedì 3 febbraio 2014 12:29:20 UTC+1, Pat Allan ha scritto: > Hi Yuri > > It's Sphinx that you definitely need to upgrade - but I've no idea if TS > v2.0.14 will work with Sphinx 2.1.x. You could give it a shot, I guess? Note > that the :select option becomes :sphinx_select with TS v2.0.14. > > And passing nil in won't work, I'm afraid - an empty set is different to > matching a nil value in a set. > > -- > Pat > > On 3 Feb 2014, at 8:49 pm, [email protected] wrote: > >> Uhm ... unfortunately I'm using TS 2.0.14 >> >> Could be a problem? >> >> Is it possibile to do it without upgrading the GEM? >> >> Thanks. >> >> Il giorno lunedì 3 febbraio 2014 10:46:07 UTC+1, [email protected] ha >> scritto: >> Hi Pat, thanks again for your support. >> >> Probably is a stupid question but .... is not possible to pass simply a nil >> value in the array? >> >> I mean: instead of prod_ids = [1,2,3,4,5] -> [1,2,3,4,5,nil] >> >> Bye. >> >> Il giorno sabato 1 febbraio 2014 00:32:26 UTC+1, Pat Allan ha scritto: >> Hi Yuri >> >> It's certainly possible, but more complex - you'll need to construct the >> filter in a more manual manner. I think the following will work: >> >> Digitalasset.search( >> select: "*, LENGTH(product_ids) = 0 OR IN(product_ids, #{ids.join(', ')} >> AS in_products", >> with: {in_products: true} >> ) >> >> Though you need to be using Sphinx 2.1.2 or newer (that's when the LENGTH >> function was introduced to Sphinx). >> >> If you're using Thinking Sphinx v3.0.6, that'll work, but you'll need to >> make changes as outlined in the release notes: >> https://github.com/pat/thinking-sphinx/releases/v3.0.6 >> >> Or, you can upgrade to v3.1.0, which works with Sphinx 2.1.x releases as the >> default. A read of the release notes for other changes wouldn't hurt: >> https://github.com/pat/thinking-sphinx/releases/v3.1.0 >> >> Cheers >> >> -- >> Pat >> >> On 1 Feb 2014, at 1:28 am, [email protected] wrote: >> >> > Hi all, >> > for first sorry for my english. >> > >> > I've 3 tables in my DB >> > - digitalassets >> > - product_digitalassets >> > - products >> > >> > the 2nd table is a join table in a M:N relationship >> > >> > I collect documents through digitalassets table and I've created an >> > attribute field in my Index: >> > >> > as product_digitalassets.product_id, :as => :product_ids >> > >> > in order to filtering the resultset. >> > >> > In fact I send to search the query command: >> > >> > with: { product_ids: ids } where ids is an array of product ID >> > >> > Everything is ok but now I want to retrieve not only the Digitalassets >> > within the list o product_ids but also the Digitalassets without a product >> > association. >> > >> > I mean: >> > >> > Digitalasset 1 -> products [1,2,3] >> > Digitalasset 2 -> products [1,2,4] >> > Digitalasset 3 -> products [5,6,7] >> > Digitalasset 4 -> products NULL >> > >> > How to get the Digitalasset 1, Digitalasset 2 and Digitalasset 4? >> > >> > Now for me is sufficent to search with: { product_ids: [1,2] } -> result = >> > Digitalasset 1 and Digitalasset 2 >> > >> > But in this way I can not get the Digitalasset 4. >> > >> > Thanks in advance. >> > >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "Thinking Sphinx" group. >> > To unsubscribe from this group and stop receiving emails from it, send an >> > email to [email protected]. >> > To post to this group, send email to [email protected]. >> > Visit this group at http://groups.google.com/group/thinking-sphinx. >> > For more options, visit https://groups.google.com/groups/opt_out. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Thinking Sphinx" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/thinking-sphinx. >> For more options, visit https://groups.google.com/groups/opt_out. > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
