Catalog search is not getting the required sorted result on the specified
property in SortProperty of search option class.
I have two different catalogs, sort property is working fine with one
catalog (with small catalog data-arround 500 items) but same code getting
wrong sorted ordered data on the other catalog (large catalog data-more
than
100000 items).
I looked into the stored procedures, and fix this problem by adding an
“Order by” clause in ctlg_GetResults_for_SingleCatalog stored
procedure of
productcatalog database in case when eJoinType = -1:
I would like to have recommendations, either above fix is workable or not?
or any other suggestions
