What you suggested is not useful for me. Since I expect following data only to be indexed from above data
id | name | dept_id | created_at ------------------------------------------------ 1 | rahul | 2 | 2009-12-11 01:31:18.43 5 | demo2 | 3 | 2009-12-11 12:46:18.44 8 | deo3 | 4 | 2009-12-11 05:26:18.44 On Dec 26, 8:31 am, Pat Allan <[email protected]> wrote: > 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 > > 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.
