What you're trying to do is not possible with Sphinx in the way you're thinking: Sphinx does not have any understanding of relationships between different pieces of data within fields or attributes, so there's nothing linking a schedule date and schedule name together within a project index.
I'd recommend you search on Schedule instead, and then, because there's only one schedule name and one schedule due date, you should be fine. From there, you can then use that schedule's project in the search results. Cheers -- Pat On 15/02/2013, at 11:29 AM, yekta wrote: > Hello, > > I've tried asking my question on Stack Overflow but haven't had any luck so I > thought I'd try here. Any help would be greatly appreciated. > > I'm wondering if there's a way I can build my indices in such a way soas to > be able to sort on a Date of the Project's related Model, where the search > matches specific :names of the `related` Model's value. > > I've explained more thoroughly in the StackOverflow question but essentially > I'm trying to do this: > > Project.search(query, :order => "due_date desc", :match_mode => :extended) > But I only want to return Project results where a Schedule matches a specific > :name value. > > Please let me know if that doesn't make sense. Right now I've solved this > problem with sorting post-search, I'm hoping there's a way within the domain > of Sphinx/Thinking-Sphinx to accomplish this. > > Thanks > > -- > 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?hl=en. > 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
