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.
