Sorry, I'm not exactly sure what you're asking... If you need Sphinx to filter by specific characters in the serial number, then you'll need to parse out each piece of information via SQL snippets... something like (I'm guessing here): has "SUBSTR(serial_number, 0, 1)", :as => :manufacturer, :type => :integer
It does seem like your logic is more complex than this, but if you want to get the data into Sphinx, it all needs to be managed by SQL queries. If this isn't a question to do with indexing, please let me know and I'll try to provide some other suggestions. -- Pat On 24/11/2009, at 12:44 AM, pcasa wrote: > I have product that the product serial number equals product series, > chip, model, manufacture, software, etc. Each of these has its own > table with all the information I need in it. > > Each product serial number is 8 characters long. i.e. 1B43A672, > 18GH8843. The second value determines how to map the serial number to > which table. i.e. If the second value is B then that is a Intel Atom > 1.6 and its mapped like this: Position_1 == @series; Position_2 == > @processor; Position_3 == @model > > But if second value is 8 then its mapped like this: Position_1 == > @manufacture;Position_2 == @processor; Position_3 == @software > > Can thinking sphinx do this? > > -- > > 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= > . > > -- 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.
