There's #where and #group_by methods in the define_index block you can use to customise the generated SQL query - this may allow you to get the records you want. You can find the syntax in the second-last section of this page: http://freelancing-god.github.com/ts/en/indexing.html
-- Pat On 24/12/2009, at 6:57 PM, rahul100885 wrote: > Hi All, > > I want to filter my result on table which have following structure, > > id | name | dept_id | created_at > ------------------------------------------------ > 1 | rahul | 2 | 2009-12-11 01:31:18.43 > 2 | rahul1 | 2 | 2009-10-11 12:24:18.50 > 3 | rahul3 | 2 | 2009-11-11 11:54:18.34 > 4 | demo1 | 3 | 2009-10-11 07:45:18.26 > 5 | demo2 | 3 | 2009-12-11 12:46:18.44 > 6 | demo3 | 3 | 2009-11-11 09:36:18.36 > 7 | deo1 | 4 | 2009-11-11 08:51:18.41 > 8 | deo3 | 4 | 2009-12-11 05:26:18.44 > > In this structure I want to index only those records from a groups of > dept_id which have latest created_at date > > OR you can say > > distinct dept_id with latest created_at date. > > For above scenario how can I specify a where condition into > define_index part of model. > > or scope or any think which I can specify after index done. > > -- > > 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. > > -- 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.
