For using PPM existing tools: - You query the data base for the data you want displayed in your portlet (SQL - structured query language) This becomes your Data Source created in the PPM Workbench.
Try this: - Logon on to your PPM App Server and start the PPM Workbench - In the left pane select Sys Admin > Server Tools - Click on the window that says SQL Runner and maximize it. - In the SQL Statement space, cut and paste the following SQL commands
FROM knta_users usr, krsc_org_unit_members oum, krsc_org_units ou
WHERE 1=1 AND oum.org_unit_id = ou.org_unit_id AND usr.user_id = oum.user_id AND usr.username in (select username from knta_users_v where enabled_flag='Y')
order by full_name
- This is the start of a custom portlet for displaying all of the enabled PPM users. - Once it is running in the SQL runner, you can kind of save it as a permanent Data Source. - Data Sources are created in the Dashboard > Data Sources section of the PPM Workbench.