Sage CRM

Hi, I have built 2 gadgets from a view that pulls information from Sage 300 OE invoices. Now I have been told that we cannot filter or sort by fields that have aliases. So the data in my gadgets is all over the place. When will this be fixed? …