**NAS_DB_OBJECTS** rs1.projects.intfield01, 1, int, 3, 1 rs1.projects.creation_date, 2, timestamp, 3, 1 rs1.projects.created_from, 3, text, 3, 1 rs1.projects.changing_date, 4, timestamp, 3, 1 rs1.projects.changed_from, 5, text, 3, 1 rs1.projects.user_right, 6, text, 3, 1 rs1.projects.sid, 7, text, 3, 1 rs1.projects.tid, 8, text, 3, 1 rs1.projects.project_startdate, 9, timestamp, 3, 1 rs1.projects.project_enddate, 10, timestamp, 3, 1 rs1.projects.project_deadline, 11, timestamp, 3, 1 rs1.projects.project_reminder, 12, timestamp, 3, 1 rs1.projects.project_budget, 13, float8, 3, 1 rs1.projects.project_type, 14, text, 3, 1 rs1.projects.project_kickoff, 15, timestamp, 3, 1 rs1.projects.project_description, 16, text, 3, 1 rs1.projects.project_goal, 17, text, 3, 1 rs1.projects.project_customer, 18, text, 3, 1 rs1.projects.project_name, 19, text, 3, 1 rs1.projects.project_status, 20, text, 3, 1 rs1.projects.project_phase, 21, text, 3, 1 rs2.projects_participant.id, 1, text, 3, 1 rs2.projects_participant.name, 2, text, 3, 1 participant_count.count.count, 1, text, 3, 1 milestone_count.count.count, 1, text, 3, 1 task_count.count.count, 1, text, 3, 1 dependency_count.count.count, 1, text, 3, 1 note_count.count.count, 1, text, 3, 1 link_count.count.count, 1, text, 3, 1 attachment_count.count.count, 1, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, creation_date, created_from, changing_date, changed_from, user_right, sid, tid, project_startdate, project_enddate, project_deadline, project_reminder, project_budget, project_type, project_kickoff, project_description, project_goal, project_customer, project_name, project_status, project_phase FROM projects** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND (user_right LIKE '|**NAS_USER**|' OR '|**NAS_USER**|' IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.intfield01 = |**vkn**|))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT id, name FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND role = |**LEADER_ROLE_INDEX**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs2** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_participants.id) AS count FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND group_id LIKE |**NO_GROUP_ASSIGNMENT**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=participant_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_milestones.id) AS count FROM projects_milestones** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=milestone_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(prg_tasks.intfield01) AS count FROM prg_tasks** **NAS_WHERE = WHERE (field03 IS NOT NULL AND field03 LIKE '%|**vkn**|%') AND ((|**HAS_USER_RIGHT_OR_IS_LEADER**|) OR (|**IS_CHIEF**|) OR (|**IS_PARTICIPANT**|))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=task_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_dependencies.id) AS count FROM projects_dependencies** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND ('|**NAS_USER**|' IN (SELECT id FROM projects_participants WHERE intfield01 = |**vkn**| AND merged_permission > |**STAFF_ROLE_INDEX**|) OR '|**NAS_USER**|' IN (SELECT user_right FROM projects WHERE intfield01 = |**vkn**|) OR '|**NAS_USER**|' IN (SELECT member_uid FROM prg_tasks_members WHERE object_id IN (SELECT successor FROM projects_dependencies WHERE intfield01 = |**vkn**|) OR object_id IN (SELECT antecessor FROM projects_antecessors WHERE intfield01 = |**vkn**| AND id = projects_dependencies.id)))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=dependency_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(prg_notes.intfield01) AS count FROM prg_notes** **NAS_WHERE = WHERE prg_notes.sid LIKE '|**vkn**|'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=note_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(links.id) AS count FROM links** **NAS_WHERE = WHERE links.firstid = |**vkn**| AND lower(links.firstmodule) LIKE '%project%'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=link_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(attachments.id) AS count FROM attachments** **NAS_WHERE = WHERE attachments.attachedto = |**vkn**| AND lower(attachments.module) LIKE '%project%'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=attachment_count** Groupware - **OX_APP_TITLE**
   Projekt       Team (**participant_count.count.count**)      Meilenst. (**milestone_count.count.count**)      Aufgaben (**task_count.count.count**)      Abhängigkeiten (**dependency_count.count.count**)      Diagramm       ...    
 
**PROJECTS_CONFIRMATION** **NOTIFICATION1** **C2** **NOTIFICATION2**
  Diagramm-Download    **CHANGE_IMG** 
**ERROR-MESSAGE**
 Projekt Gantt Diagramm
**CREATE_TABLE_ROWS**
    Betreff 
 
**PROJECTS_CONFIRMATION_BUTTON**