Lobby Data Source Designer: Column As not allowed

you should not need “as status” here

just put the rest of the text (up to “END”) into the column, and then name it.

thx for your reply. I tried that but then the Order by doesn’t work and I get an error:

Hi Bob,

No need to use case statement in the state column to display but use order by as below,

in the order by clause,
decode(state,'Blocked',1,'Planned',2,'Released',3,'Reserved',4,'Picked',5,'Partially  Delivered',6,'Delivered',7)

Thanks,
Sanjay

Thx for the idea. However that code merely replaces the text for a number; I need for it to be sorted on my case results text; not the DB status value- see my 1st print screen in my original post. Blocked, Planned, Released, etc...

ORDER BY columns don’t get AS aliases in SQL. However, if we’re working in pure SQL without a middle application trying to interpret it, you can do an ORDER BY on the alias itself: ORDER BY status

thx for the explanation. So this can’t be done in a Lobby, correct?

Hi,

This can be done in Lobby.

Please use the case statement in the columns section and the order by decode expression which I have mentioned above in the order by clause section in lobby or also you can use the same case statement in order by clause.

ok, thx. it works! I misunderstood your solution- once I put the decode) code in the Order by it worked.