Specifying Different Column as DOC ID using Thinking Sphinx

Question

I am using the great Thinking Sphinx plugin for accessing Sphinx Search in RoR 2.2.3. I have a cache table that stores pre-compiled views. This is the source data table for Sphinx.

However, the ID column on this table is basically garbage, and the ID that I want is stored in another column (cacheable_id). How can I setup Thinking Sphinx to use the "other column" as Sphinx's DOC ID instead of the plain old "ID" column.

Thanks in advance!!

Answer 1

Hi there

There's no way to do this with Thinking Sphinx at the moment. However, there is a fork out there that does what you need. I'd recommend you create your own fork, and mix the latest official TS release with the relevant patch from this fork. I'm not quite sure how cleanly it will merge though.