[Resolved] SQL Order By based on parameter

[max_max_mir]

I am trying to order by a column in my SQL query, but this column I am trying to order by depends on a parameter to be supplied by the end user. Any suggestions how to do it?

SQL Query: Select * from table1 order by $P{param1}

The problem is, $P{param1} is of type String, and in the query, it gets translated to a string with quotes. On the other hand, an expression like Select * from table1 order by $P{param1}.equals("column1")?column1:column2 doesn't work either.

Post Edited by max_max_mir at 08/11/2010 17:30

[robsil]

Try $P!{param}.  The '!' indiciates that it should be a literal string replacement which should solve your problem

[max_max_mir]

Thank you! That worked!