ToUpper in Order by ->Simple query

ToUpper in Order by ->Simple query

  
Hi,

In a simple query is possible to order by upper values one column?
In SQL Server you dont have this issue but  in a oracle DB final result is not the same...

Just like this
Select *
From OSUSR_A7L_USER_MAS
Order by Upper(name)

Best Regards
Hi João,

it is not possible to do it as a simple query.

Best regards
Actually I think you can acomplish what you want with a simple query. Create a parameter in your simple query and use it as your "order by".
 
Then use the ToUpper() function in the input parameter "OrderBy"of your query.

I didn't manage to test it. Try it and let me know.
Cheers!
Hi,

(note that I also didn't test it, just reading the previous post and giving my 2 cents)

The OrderBy is an expression to be used on the order by of the query, using ToUpper("Name") would generate a query like "Order By NAME"
Also, since it's Oracle, and when using "Name" requires the entity attribute in the database to have that exact casing it will not work.


Try:

"Upper({User_Master}.[Name])" or just "Upper(Name)" in the dynamic OrderBy

Regards,
João Rosado
João Rosado wrote:
Hi,

(note that I also didn't test it, just reading the previous post and giving my 2 cents)

The OrderBy is an expression to be used on the order by of the query, using ToUpper("Name") would generate a query like "Order By NAME"
Also, since it's Oracle, and when using "Name" requires the entity attribute in the database to have that exact casing it will not work.


Try:

"Upper({User_Master}.[Name])" or just "Upper(Name)" in the dynamic OrderBy

Regards,
João Rosado
 
 Hi, that as my first try :)

"Invalid syntax in 'Order By' parameter." is what you get...
Like André said, it's not possible using a simple query.

Thanks to all.