List Projects of Selected Object Type
The following query lists all the projects of a selected object type. Here PROJECT is a variable, replaced by the selected object type name.
SELECT [PROJECT].name, [PROJECT].current_routing,[PROJECT].creator
FROM [PROJECT], parent_list
WHERE (parent_list.child = [PROJECT].pdm_blobid) AND
(([PROJECT].pdm_current = 1) AND ([PROJECT].pdm_deleted = 0));
Example:
Work in Progress
| Column label: | Contains the following data: |
|---|---|
| Project | PROJECT.name |
| creator | PROJECT.creator |
| Task | second part of PROJECT.current_routing |
| Team Member | last past of PROJECT.current_routing |