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

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.

I have experienced a similar issue and reported it to IFS (Case ID: G2062343). The workaround they gave worked but  later our HR Coordinator who uses the lobby pointed out that the months are again not sorted properly. I have not raised this to IFS yet. You could have a look at the case I had reported and see if the solution they have provided works for you.

To order by the result. Use the code below.

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