Display variants with sql query using smart search filter

giridhar Addagalla asked on November 23, 2018 15:39

I am trying to write a sql query in the smart search filter to show the available variants of that category page can you suggest how to write it,I tried this waySELECT 'SKUID',s.SKUID,c.CategoryDisplayName FROM COM_OptionCategory c INNER JOIN COM_SKUOptionCategory s ON c.CategoryID=s.CategoryID GROUP BY s.SKUID,c.CategoryDisplayName but it will not search all the products.

Recent Answers

Peter Mogilnitski answered on November 23, 2018 15:56

Your first column must have a name

SELECT 'SKUID' as [SKUID], s.SKUID,c.CategoryDisplayName 
FROM COM_OptionCategory c 

Follow the example in the documentation and you will be ok.

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.