Hi, thanks to the new version 3.8.
I have upgraded my system from 3.5 to 3.8 (via 3.6, 3.7 etc). Before I worked on SQL Procedure to make the search including the SKU field too as follows. In the new 3.8, I could not find out where to upgrade the SQL code. Please help.
thanks in advance!
James
FYI The following was the code which I had to change before and worked great!
Find the store procedure --ProductLoadAllPaged
Instead of
--SKU
IF @SearchSku = 1
BEGIN
SET @sql = @sql + '
UNION
SELECT p.Id
FROM Product p with (NOLOCK)
WHERE '
IF @UseFullTextSearch = 1
SET @sql = @sql + 'CONTAINS(p.[Sku], @Keywords) '
ELSE
SET @sql = @sql + 'PATINDEX(@Keywords, p.[Sku]) > 0 '
END
Use
--SKU
--IF @SearchSku = 1
--BEGIN
SET @sql = @sql + '
UNION
SELECT p.Id
FROM Product p with (NOLOCK)
WHERE '
IF @UseFullTextSearch = 1
SET @sql = @sql + 'CONTAINS(p.[Sku], @Keywords) '
ELSE
SET @sql = @sql + 'PATINDEX(@Keywords, p.[Sku]) > 0 '
--END