Hi Mohit You will find the Thinking Sphinx docs to be pretty helpful with setting all this up. You will need to keep in mind that Sphinx doesn't use SQL queries for filters, but has it's own filter system (with exact filter matches on attributes, and keyword matches on fields). http://freelancing-god.github.com/ts/en/
It's also worth noting that you can bring in data from associations quite easily when defining fields and attributes. Have a look through the examples on the indexing page: http://freelancing-god.github.com/ts/en/indexing.html If you get stuck with anything in particular, let us know. -- Pat On 21/12/2009, at 5:33 PM, mohitnegi wrote: > I want to use thinking sphinx in my application, basically i have a > filter criteria screen, and depending on the user input, the sql query > is generated, which joins all the tables based on user input, now i > want > to use thinking sphinx for this query, > my problem is how to pass sql query to thinking sphinx and then how to > differentiate between fields which has same name but are from > different > tables(eg, id will be there in all the tables) > > -- > > 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.
