Hello Pat
Yes, the intention is very clear. And i've been trying this way too
(i'm in spain, and here now it is 6 in the morning, i've been 18 hours
reading and working on this).
The fact is that the sql seems not to be working really... how can I
see the video_or_properties field of a search? (sorry for the mistake,
it is "Pictures", not "properties")
I'm trying from the console, this way:
Item.search('somekeyword').each {|p| puts p.video_or_pictures }
But of course "video_or_pictures" is not a valid field. How can I see
how is my model indexing that sql query?
Iván
On Mar 25, 5:39 am, Pat Allan <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
