Hi all,
I have a Line with area chart in oracle apex 5.1.3 based on the following sql query:
select 'januar' as month, januar as timer from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_jan as januar
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'februar', februar from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_feb as februar
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'mars', mars from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_mar as mars
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'april', april from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_apr as april
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'mai', mai from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_may as mai
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'juni', juni from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_jun as juni
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'juli', juli from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_jul as juli
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'august', august from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_aug as august
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'september', september from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_sep as september
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'october', october from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_oct as october
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'november', november from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_nov as november
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
UNION ALL
select 'desember', desember from (
SELECT ce.last_name as last_name, cu.username as username,
pe.estimate_dec as desember
FROM prj_project_employees ppe, core_users cu, cmp_employees ce, prj_estimates pe
where ppe.prj_project_id = :P190_SHOW
and ppe.id = pe.owner_table_id
and pe.estimate_year = :P190_YEAR
and ce.id = ppe.cmp_employee_id
and cu.id = ce.core_user_id
and ce.id = :P190_PERSON)
And is displayed in the JET - chart as this
Notice the X-axis being sorted alphabetically. This wasnt the case before the new update and I cant for the love of god find out why or where I can turn of this sorting in the page designer.
Any help?