Solr sort issue between two solr cores (indexed types)

[Former Member]

Hello Experts, I am working on a use case , where all the product data is storing to to product index but not the price property. And price data will be managed separately on second index (core) , The query generation and all is difference for this.

For some business reason we can store price values in the product index.

But i have an issue where i need to sort by price low to high and high to low. as there is no price stored into prouduct index. I was trying with solr join approach. but i am not finding a best solution to sort the price from solr second index while joining with product index. Please help me in getting this resolved.

Or suggest me the best way to handle this situation.

[a_e_dubey]

I have an idea let me know if you need still.