: Am 20.07.2011 19:23, schrieb Kyle Lee: : > Is the mediacode always alphabetic, and is the ID always numeric? : > : No sadly not. We expose our products on "too" many medias :-).
If i'm understanding you correctly, you're saying even the prefix "AB" is not special, that there could be any number of prefixes identifying differnet "mediacodes" ? and the product ids aren't all numeric? your question seems .... absurd. I can only assume that I am horribly missunderstanding your situation. (which is very easy to do when you only have a single contrieved piece of example data to go on) As a general rule, it's not a good idea to think about Solr in the same way as a relational database, but Perhaps if you imagine for a moment that your Solr index *was* a (read only) relational database, with each solr field corrisponding to a column in your DB, and then you described in psuedo-code/sql how you would go about doing the types of id lookups you want to do, it might give us a better idea of your situation so we can suggest an approach for dealing with it. -Hoss
