Search in tags with SP Nop_ProductLoadAllPaged @Keywords ?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Il y a 13 ans
Hello,

Did someone try to include tags in search by keywords?
Example :
- I have a product named 'My Special Product' (description : 'Lorem Ipsum')
- I tag it 'cool' (a word that isn't the name or description)
- If I search 'special', no problem : the product is in the results
- But if i search 'cool', not...

I'd like to alter the SP Nop_ProductLoadAllPaged, any idea?
I don't want to use the parameter @ProductTagID but @Keywords because it comes from search.aspx.

Thanks.
Il y a 13 ans
Here is my first implementation (with search in categories and manufacters' names too):
News joins in
SELECT p.ProductID
FROM Nop_Product p
...
LEFT OUTER JOIN Nop_ProductTag pt WITH (NOLOCK) ON ptpm.ProductTagID = pt.ProductTagID
LEFT OUTER JOIN Nop_Category c WITH (NOLOCK) ON pcm.CategoryID = c.CategoryID
LEFT OUTER JOIN Nop_Manufacturer m WITH (NOLOCK) ON pmm.ManufacturerID = m.ManufacturerID

+
in the
@SearchKeywords = 0 or (...)
section after
PATINDEX
ON
p.Name
,
pv.Name
, ... :
OR PATINDEX(@Keywords,pt.Name COLLATE French_CI_AI) > 0
OR PATINDEX(@Keywords,c.Name COLLATE French_CI_AI) > 0
OR PATINDEX(@Keywords,m.Name COLLATE French_CI_AI) > 0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.