The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Request Summary Bar Chart portlet

Highlighted
Sevilay
Collector

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

//Add this to "OnDomLoad" event