Hi Iván
Again, a custom attribute is going to be best suited. Maybe something
like the following:
has "has_video = 1 OR (SELECT COUNT(id) FROM properties WHERE
item_id = items.id) > 0",
:as => :video_or_properties, :type => :integer
I'm making some assumptions about the schema and generated query, but
hopefully the intention is clear.
Cheers
--
Pat
e: [email protected] || m: +614 1327 3337
w: http://freelancing-gods.com || t: twitter.com/pat
discworld: http://ausdwcon.org || skype: patallan
On 25/03/2009, at 3:31 PM, Iván Belmonte wrote:
>
> Hello James
>
> Yes I see... Well, I knew these limitations, just wanted to make
> sure...
>
> And how can I say "different than"?
> Because i'm thinking about something like:
>
> Item.search('(@property_ids !0 | @has_video 1)', :match_mode
> => :extended)
>
>
> Iván
>
> On Mar 25, 5:13 am, James Healy <[email protected]> wrote:
>> Hi Ivan,
>>
>> Have a read of the following thread, it should answer your questions:
>>
>> http://groups.google.com/group/thinking-sphinx/browse_thread/thread/
>> c...
>>
>> Essentially, you can use OR when searching indexed text fields, but
>> not
>> attributes.
>>
>> You might also want to read the documentation in
>> lib/thinking_sphinx/index/builder.rb, it covers some of the
>> differences
>> and limitations of fields (indexes ...) and attributes (has ...).
>>
>> James
>>
>> Iván Belmonte wrote:
>>
>>> Well, another solution is applying OR to conditions, this way:
>>
>>> in model, as normally:
>>
>>> ------------
>>> define_index so
>>> [...]
>>> indexes :has_video
>>> has pictures(id), :as => :picture_ids
>>> end
>>> ------------
>>
>>> Then, in the controller;
>>
>>> Item.search(:conditions => { :picture_ids => 1..1000
>>> | :has_video =>
>>> 1 })
>>
>>> each condition alone works great. What i'd need is the syntax for
>>> "OR'ing" them
>>
>>> Iván
>>
>>> On Mar 25, 4:39 am, Iván Belmonte <[email protected]> wrote:
>>>> Trying to index this way:
>>
>>>> indexes pictures.size, :as => :num_pictures
>>
>>>> But still not working... i'm desperate :-(
>>
>>>> Iván
>>
>>>> On Mar 25, 2:38 am, Iván Belmonte <[email protected]> wrote:
>>
>>>>> I see that items not having associated pictures don't have the
>>>>> field
>>>>> "picture_ids", so maybe the easiest way was asking sphinx for that
>>>>> field.... something like:
>>
>>>>> Item.search(:conditions => { :picture_ids => !nil })
>>
>>>>> or something similar... does it exist any syntax for asking this?
>>
>>>>> Thanks again,
>>
>>>>> Iván
>>
>>>>> On Mar 25, 1:47 am, Iván Belmonte <[email protected]> wrote:
>>
>>>>>> Helllo there,
>>
>>>>>> I have a model like this:
>>
>>>>>> -------------
>>>>>> define_index do
>>>>>> indexes description
>>>>>> indexes amount
>>>>>> [...]
>>>>>> indexes has_video <----- this field is bool
>>>>>> indexes pictures(:id), :as => :picture_ids
>>>>>> [...]
>>>>>> end
>>>>>> --------------
>>
>>>>>> Then what i need to search is something like this:
>>
>>>>>> --------------
>>>>>> Model.search("some keywords" (@has_video "1" | @picture_ids "*")
>>>>>> --------------
>>
>>>>>> I mean, I need to match:
>>>>>> - "some keywords" AND
>>>>>> - "has_video" is set to "1" _OR_ Model has one or more Pictures
>>>>>> associated.
>>
>>>>>> I didn't find any documentation about the second part... how
>>>>>> can I do
>>>>>> this?
>>
>>>>>> Thanks in advance!
>>
>>>>>> Ivan
>>
>>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
