Project and Portfolio Management Practitioners Forum
cancel

Request Summary Bar Chart portlet

Highlighted
Sevilay
Honored Contributor.

Request Summary Bar Chart portlet

Hi,

i get an error when i press the "demand owner" filter on the "Request Summary Bar Chart" portlet.The error message doesn't show the validation name but displays the query in the validation.If i find the validation i can change the query in it.

Does anybody know the validation's name?

Thanks in advance.

Validation SQL:
SELECT u.user_id, u.full_name, u.username, o.org_unit_name, u.email_address
FROM KRSC_ORG_UNITS o,KRSC_ORG_UNIT_MEMBERS m, KNTA_USERS u
where 1=1
AND o.org_unit_id = m.org_unit_id
AND u.user_id = m.user_id
AND (o.parent_org_unit_ID = NVL(?,'') OR o.org_unit_id = NVL(?,''))
AND NVL(u.start_date, CURRENT_DATE) <= CURRENT_DATE
AND NVL(u.end_date, CURRENT_DATE + 1) > CURRENT_DATE
order by u.full_name