Populating the GUI
To populate the GUI for "Due Date" report, the list of objects based on a Project and the list of Project Managers based on the ProjMan role must be located.
To locate the list of objects based on a Project, use the following query:
SELECT DISTINCT name FROM objecttype WHERE classtype = 20 ORDER BY name ASC;
To get the list of Project Managers based on the ProjMan role, the Contenta API is used to execute the following Contenta Server commands:
SELECT "desktop"
LIST USERS "ProjMan";