Lobby element designer

savasciftci wrote:

Hello,

 

How can I sort by month in the IFS lobby tools.

 

I tend to add an order by clause in the data source e.g.  ORDER BY 'YYYY-IW' or 'YYYY-MM'  or 'YYYY-Q'
 

You could also do something like:

year, DECODE(MONTH,'JAN',1,'FEB',2,'MAR',3,'APR',4,'MAY',5,'JUN',6,'JUL',7,'AUG','8','SEP','9','OCT',10,'NOV',11,'DEC',12) 

In PL SQL developer it works right. But in the lobby screen doesn’t work. My problem in the lobby screen. If I chose sorting by X axis, it sorting by alphabet

savasciftci wrote:

In PL SQL developer it works right. But in lobby screen doesn’t work. My problem in the lobby screen. If I chose sorting by X axis, it sorting alphabet

 

Can you set month column to ‘Number’ and not ‘Text’?

 

It works in data source designer but doesn’t work in element designer.

Month should be your X Axis.

My X Axis Month Description

Have you unticked “Use Top-N Options” in the Formatting section?

If you have that ticked the sorting of the data source is not considered.

Only two option in my screen.

To order by the result. Use the code below.

select to_char(to_date('Mayıs','MONTH', 'NLS_DATE_LANGUAGE = Turkish'), 'mm') from dual;