**NAS_DB_OBJECTS** rs1.prg_projects.created_from, 1, text, 3, 1 rs1.prg_projects.group_right, 2, text, 3, 1 rs1.prg_projects.user_right, 3, text, 3, 1 rs1.prg_projects.timestampfield01, 4, timestamp, 3, 1 rs1.prg_projects.timestampfield02, 5, timestamp, 3, 1 rs1.prg_projects.timestampfield03, 6, timestamp, 3, 1 rs1.prg_projects.intfield01, 7, int8, 3, 1 rs1.prg_projects.intfield02, 8, int8, 3, 1 rs1.prg_projects.intfield03, 9, int8, 3, 1 rs1.prg_projects.intfield04, 10, int8, 3, 1 rs1.prg_projects.intfield06, 11, int8, 3, 1 rs1.prg_projects.field01, 12, text, 3, 1 rs1.prg_projects.field02, 13, text, 3, 1 rs1.prg_projects.field03, 14, text, 3, 1 rs1.prg_projects.field04, 15, text, 3, 1 rs1.prg_projects.field05, 16, text, 3, 1 rs1.prg_projects.field06, 17, text, 3, 1 rs1.prg_projects.field07, 18, text, 3, 1 rs1.prg_projects.field08, 19, text, 3, 1 rs1.prg_projects.field09, 20, text, 3, 1 rs2.count.work, 1, int, 3, 1 rs3.count.work, 1, int, 3, 1 rs4a.prg_tasks.field09, 1, text, 3, 1 rs4.count.cost, 1, int, 3, 1 rs5.prg_projects_notification.notification, 1, text, 7, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT created_from, group_right, user_right, timestampfield01, timestampfield02, timestampfield03, intfield01, intfield02, intfield03, intfield04, intfield06, field01, field02, field03, field04, field05, field06, field07,field08,field09 FROM prg_projects** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT sum(intfield05) AS work FROM prg_tasks** **NAS_WHERE = WHERE ((field03 LIKE '|**rs1.prg_projects.intfield01**|') AND (field06 LIKE 'H'))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs2** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT sum(intfield05) AS work FROM prg_tasks** **NAS_WHERE = WHERE ((field03 LIKE '|**rs1.prg_projects.intfield01**|') AND (field06 LIKE 'D'))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs3** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT DISTINCT field09 FROM prg_tasks** **NAS_WHERE = WHERE (field03 LIKE '|**rs1.prg_projects.intfield01**|')** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs4a** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT notification FROM prg_projects_notification** **NAS_WHERE = WHERE object_id = |**rs1.prg_projects.intfield01**| AND member_uid LIKE '|**NAS_USER**|'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs5** **NAS_VO TYPE="CHOICE" NAME="rs5.prg_projects_notification.notification" DB_VALUE= |1440|2880|4320 HTML_VALUES=Keine Erinnerung|1 Tag(e)|2 Tag(e)|3 Tag(e) REFERENZ=C2 JAVASCRIPT=class="select-normal"** Groupware - **OX_APP_TITLE**
   Projekt       Teilnehmer       Meilenst.       Aufgaben       Historie       Notizen       Verknüpfungen       Anhänge    
 
**PROJECTS_CONFIRMATION** **NOTIFICATION1** **C2** **NOTIFICATION2**
  Projekt anlegen   **CHANGE_IMG** 
**ERROR-MESSAGE**
 Projekt
Name: **rs1.prg_projects.field01**
Beginnt am: **rs1.prg_projects.timestampfield01**
Endet am: **rs1.prg_projects.timestampfield02**
Wiedervorlage: **rs1.prg_projects.timestampfield03**
Status: **rs1.prg_projects.field05** 
Art: **rs1.prg_projects.field04** 
Leiter: **rs1.prg_projects.field03** 
Externe Teilnehmer: **rs1.prg_projects.field06** 
Kunde: **rs1.prg_projects.field07** 
Details
Beschreibung: **rs1.prg_projects.field02**
Einnahmen: **rs1.prg_projects.intfield02** **rs1.prg_projects.field09**
Geplante Kosten: **rs1.prg_projects.intfield03** **rs1.prg_projects.field09**
Geplante Dauer: **rs1.prg_projects.intfield04** **rs1.prg_projects.field08**
Ist Dauer: **rs3.count.work** Arbeitstage und **rs2.count.work** Stunden
Ist Kosten: **NAS-REPEAT NAME=rs4a** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT sum(intfield03) AS work FROM prg_tasks** **NAS_WHERE = WHERE (field03 LIKE '|**rs1.prg_projects.intfield01**|' AND field09 LIKE '|**rs4a.prg_tasks.field09**|')** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs4** **NAS-REPEAT NAME=rs4a**
**rs4.count.cost**  **rs4a.prg_tasks.field09** 
 
**PROJECTS_CONFIRMATION_BUTTON**