Sorting column with space in it

community

#1

Hi,
I’m trying to do a basic sort a column with spaces in it, “REC #”, with the following request

&order=REC%20%23%20DESC

Which is not working. It gives the message “Column not found: 1054 Unknown column ‘REC’ in ‘order clause’”. However, if I try to sort columns with no spaces, it works just fine. It seems to be cutting off after the space on the column with the space. Is there any way to get it to work without renaming the column?

EDIT: Solved my own issue! I simply just gave the column an Alias in the schema. Works wonderfully now.