Thanks for the quick response. An answer is better than me hitting my head against it for another day trying to find a way to do the impossible.
On Nov 16, 8:39 pm, Pat Allan <[email protected]> wrote: > Hi Jake > > You're actually hitting a limitation in Sphinx here - string attributes > (stored as integers indicating alphabetical order) are calculated on a per > index basis. So, the person index has no knowledge of the values for > name_sort in the asset index. > > So, without some serious hackery, you're out of luck for the moment. There > *may* be some way to get around this with Sphinx 1.10-beta, but TS doesn't > support the new features in that yet (the existing features it has no problem > with). > > Sorry this isn't the answer you were hoping for. > > -- > Pat > > On 17/11/2010, at 3:30 PM, Jake wrote: > > > > > > > > > I have multiple separate models that are all indexed by Sphinx. My > > goal is to be able to search all of them and return the results all > > sorted by a specific field, integrated with each other. For example, I > > want to search a model Asset and a model Person, returning a list > > ordered by the field name. > > > Currently, I am using this (optionally with a search string): > > > ThinkingSphinx::Search.search :classes => [Person, Asset], :order > > => :name_sort > > > This returns all people ordered by name, followed by all assets > > ordered by name. However, if I have the two people named Link and > > Zelda and two assets named Master Sword and Tri-Force, I want them > > returned in the following order: Link, Master Sword, Tri-Force, Zelda. > > > Is this possible in Sphinx/ThinkingSphinx? > > > P.S. The Asset model is currently the base class for Single Table > > Inheritance, and I'm able to search the subclasses in this manner (the > > various classes are returned intermingled). I don't want to include > > the new models as a subclass to Asset as they have no columns in > > common, nor will other new models I'm going to add. In fact, Assets > > has a column named title that I'm indexing with the :as => :name > > option so that I could hopefully sort both Asset and Person on the > > field name. > > > -- > > 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 > > athttp://groups.google.com/group/thinking-sphinx?hl=en. -- 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.
