Configurable report ignoring "ORDER BY"

Re: Configurable report ignoring "ORDER BY"

by David Manning -
Number of replies: 1

Thanks Tim... Oops duh. Clearly that wouldn't work smile I had pasted the incorrect code. What I'm actually using is the following: 


SELECT username, firstname, lastname, city
FROM prefix_user
WHERE prefix_user.deleted = 0
AND prefix_user.lastlogin = 0 
AND prefix_user.lastaccess = 0
%%FILTER_CITY:prefix_user.city%%
ORDER BY city
It appears that if I disable the "enable javascript ordering" it works properly in Chrome and IE... When I enable the "enable javascript ordering" it fails in both browsers. So I guess for now I should just disable that feature (especially since I don't really know why I'd want it clown
Average of ratings: -
In reply to David Manning

Re: Configurable report ignoring "ORDER BY"

by Mykl Belfatto -

I have the same issue....if "enable javascript ordering" is checked ORDER BY  doesn't work.  If  "enable javascript ordering" is not checked, ORDER BY  works. 

Average of ratings: Useful (1)