Configurable report ignoring "ORDER BY"

Re: Configurable report ignoring "ORDER BY"

David Manning གིས-
Number of replies: 1

Thanks Tim... Oops duh. Clearly that wouldn't work དགའ་འཛུམ་ 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 ཨ་ཙ་ར་
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to David Manning

Re: Configurable report ignoring "ORDER 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. 

དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།:Useful (1)