hi, some issuie i`ve just finded out - when you add a new product in admin the product you can not find it in the list because it appears somewere in the inner pages and not by some order
seems like a "Sp_ProductLoadAllPaged" sp is not doing it`s job ?
ORDER BY CASE WHEN @OrderBy = 0 AND @CategoryID IS NOT NULL AND @CategoryID > 0 THEN pcm.DisplayOrder END ASC, CASE WHEN @OrderBy = 0 AND @ManufacturerID IS NOT NULL AND @ManufacturerID > 0 THEN pmm.DisplayOrder END ASC, CASE WHEN @OrderBy = 0 AND @RelatedToProductID IS NOT NULL AND @RelatedToProductID > 0 THEN rp.DisplayOrder END ASC, CASE WHEN @OrderBy = 0 THEN p.ProductId END DESC, -- instead of THEN p.[Name] END ASC, CASE WHEN @OrderBy = 5 THEN dbo.NOP_getnotnullnotempty(pl.[Name],p.[Name]) END ASC, CASE WHEN @OrderBy = 10 THEN pv.Price END ASC, CASE WHEN @OrderBy = 15 THEN p.CreatedOn END DESC
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Hai ancora qualche domanda o hai bisogno di aiuto?