search in the new product field nop 4.10

Hi,

I added a new field in the product table. Insert and update works.
Now I would like to search also in this field (search box). For this I changed the SP ProductLoadAllPaged.
But I can not search over the field.
Has something changed in version 4.10?

Best regards

ksprovis.net wrote:
Did it work before when you made the same change in a prior version?

Did you change SP ProductLoadAllPaged to accept additional parameter(s)?
Share some code if you need help troubleshooting.

New York wrote:


yes in an early version of nopCommerce it worked.


    --SuchBegriff
    SET @Keywords = REPLACE(@Keywords, '-', '')
    SET @Keywords = REPLACE(@Keywords, ' ', '')
    SET @sql = @sql + '
    UNION
    SELECT p.Id
    FROM Product p with (NOLOCK)
    WHERE '
    IF @UseFullTextSearch = 1
      SET @sql = @sql + 'CONTAINS(p.[SuchBegriff], @Keywords) '
    ELSE
      SET @sql = @sql + 'PATINDEX(@Keywords, p.[SuchBegriff]) > 0 '

Have you manually tested the stored procedure?
Do you know for sure that your new parameter is being passed in?

Can you Trace with SQL Server Profiler, or can you add some debugging code to the sp to check the final SQL query text?

New York wrote:


where do I have to pass the new parameter?