Hello,
How can I sort by month in the IFS lobby tools.
Best answer by TAPSUDJAY
View original
This topic has been closed for comments
Userlevel 7
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
Userlevel 7
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.
Userlevel 7
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.
Userlevel 5
+14
To order by the result. Use the code below.
select to_char(to_date('Mayıs','MONTH', 'NLS_DATE_LANGUAGE = Turkish'), 'mm') from dual;Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.