Documentation Center

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:
ProjectPROJECT.name
creatorPROJECT.creator
Tasksecond part of PROJECT.current_routing
Team Member last past of PROJECT.current_routing