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.