We need to "enhance" the original search results page with some "extended" information that we have in a few custom tables. The idea is to use the productids returned by aspdnsf_GetProducts to join to our tables.
My question is: am I overcomplicating it? There is a more simple way of doing it? Or the approach seems to be fine?
Of course the ideal scenario would be to include the call to my custom stored procedure in the header of the page.search.xml.config along with the other existent queries, but I am not sure if this is possible since the necessary parameters will come from the aspdnsf_GetProducts sp that runs basically at the same time... I am almost sure that it is not possible but decided to ask.
I hope that it all makes sense...