Iâ€™ve imported a site from EVO to REVO and iâ€™m migrating Ditto to GetResources.
Snippets works fine, but I need to sort by TV from this values: 10, 9.5, 9, 8.5, etc.
Using DITTO: &orderBy=`numbers DESC` (this paremeters works fine)
Using GetResources: &sortbyTV=`numbers` &sortdirTV =`DESC` (9.5, 9, 8.5, 10) Number 10 is in the end of the list.
What should I do? (Sorry for my english)
I havenâ€™t tested any of the above. Hopefully get resources likes the syntax
Please post back
Thanks for the help, but it still doesnâ€™t work.
Iâ€™ve tried even with: &sortdir=`DESC` but doesnâ€™t work either.
Any other sugestions?
Iâ€™m not sure it will help, but make sure you have &includeTVs=`1` and &tvPrefix=`` (and maybe &processTVs=`1`) in the tag.
Thank for the help, but is doesnâ€™ work. &includeTVs=`1`, &tvPrefix=`tv.` and &processTVs=`1` are included.
Any other sugestions? It seems that GetResources "see" the number 10 as 1, or "see" numbre 9.5 as 95.
I have this same problem. Has anyone come up with a solution?
Try adding this to the getResources tag:
I really thought that would do it:
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
Does your TV value begin with a dollar sign? That could interfere with the sorting process.