**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"**