Intersect SQL Index builder with ProductIndex Builder

Adrian Ursu

Posted on 04/05/2016 17:53:35

Hi Guys,

I have a special case where I have to list a bunch of products that are related with some serial numbers in a separate table.

I have managed to create a SQL Index builder in order to filter based on Serial NUmber and a bunch of other parameters and now I have to decide the approach for displaying the product list.

The current approach is to use the Query Publisher and use Dynamicweb API for transforming the ProductID into a product Ibject and access all other fields.

I was wondering if it's possible to intersect the result of the SQL Indexer with the ProductIndex, meaning "feed" the productID's resulted from the SQL Index (after applying the filters) into a standard product Index inside a ProductCatalogue module.

I know my question sounds a bit stupid but I had to ask it.

Thank you in advance,

Adrian

Replies

Nicolai Høeg Pedersen

Posted on 09/05/2016 12:56:38

Hi Adrian

It is not possible with the current API. A simple solution could be to redirect to a URL with the productid(s) in the queystring - so when you find products in the search, redirect to a URL with the findings in the URL and use the product catalog to render the product.

BR Nicolai

Adrian Ursu

Posted on 09/05/2016 14:31:02

Hi Nicolai,

Thanks for confirming. I knew it was a long shot but I wanted to make sure that I don't miss anything.

Thank you,

Adrian

You must be logged in to post in the forum

Developer forum

Intersect SQL Index builder with ProductIndex Builder

Replies