**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 rs1.projects.project_currency, 22, text, 3, 1 rs1.projects.project_manage_permissions, 23, text, 3, 1 rs1.projects.project_task_folder_id, 24, text, 3, 1 rs1.projects.project_effort, 25, text, 3, 1 rs1.projects.project_effort_unit, 26, int, 3, 1 rs1.projects.dynamicfield01, 27, text, 3, 1 rs1.projects.dynamicfield02, 28, text, 3, 1 rs1.projects.dynamicfield03, 29, text, 3, 1 rs1.projects.dynamicfield04, 30, text, 3, 1 rs1.projects.dynamicfield05, 31, text, 3, 1 rs1.projects.dynamicfield06, 32, text, 3, 1 rs1.projects.dynamicfield07, 33, text, 3, 1 rs1.projects.dynamicfield08, 34, text, 3, 1 rs1.projects.dynamicfield09, 35, text, 3, 1 rs1.projects.dynamicfield10, 36, 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, project_currency, project_manage_permissions, project_task_folder_id, project_effort, project_effort_unit, dynamicfield01, dynamicfield02, dynamicfield03, dynamicfield04, dynamicfield05, dynamicfield06, dynamicfield07, dynamicfield08, dynamicfield09, dynamicfield10 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       ...    
 
**DYNAMIC_FIELDS** **PROJECTS_CONFIRMATION** **NOTIFICATION1** **C2** **NOTIFICATION2**
  Projekt anlegen    **CHANGE_IMG** 
**ERROR-MESSAGE**
 Projekt
Name: **rs1.projects.project_name**
Beginnt am: **rs1.projects.project_startdate**
Endet am: **rs1.projects.project_enddate**
Abgabetermin: **rs1.projects.project_deadline**
Wiedervorlage: **rs1.projects.project_reminder**
Status: **rs1.projects.project_status** 
Art: **rs1.projects.project_type** 
Leiter: **rs2.projects_participant.name** 
Kunde: **rs1.projects.project_customer** 
Details
Beschreibung: **rs1.projects.project_description**
Ziel: **rs1.projects.project_goal**
Kickoff-Meeting: **rs1.projects.project_kickoff**
Kennzahlen
Gesamt-Budget: **rs1.projects.project_budget** **rs1.projects.project_currency**
Ist-Kosten: **CALCULATE_IS_COSTS** **rs1.projects.project_currency**
Verbleibendes Budget: **CALCULATE_REMAINING_BUDGET**
Gesamt-Aufwand: **rs1.projects.project_effort** **rs1.projects.project_effort_unit**
Ist-Aufwand: **CALCULATE_IS_EFFORT** **rs1.projects.project_effort_unit**
Verbleibender Aufwand: **CALCULATE_REMAINING_EFFORT**
Projekt-Konfiguration
Projekt-Aufgabenordner: **rs1.projects.project_task_folder_id**
Automatische Ordnerrechte-Verwaltung: **rs1.projects.project_manage_permissions**
 
**PROJECTS_CONFIRMATION_BUTTON**