Hi all! I'm trying to join 2 indexes together to produce a final result using only Solr + Velocity Response Writer.
The problem is that each "hit" of the main index contains references to some common documents located in another index. For example, the hit could have a field that describes in what state its located. This field would have a value of "NY" for New York etc... Now what if, in velocity, I want to show this information in full detail. Instead of the NY, I would like to show "New York"? This information has not been indexed in the main index, but rather in a second one. Is it possible to coalesce or join these results together so that I can pass a simple Velocity template to generate the final HTML? Or do I have to write a webapp in java to cache all these global variables (the state codes, the country codes etc...)? Daniel Shane
