**NAS_DB_OBJECTS** rs1.prg_projects.created_from, 1, text, 3, 1 rs1.prg_projects.group_right, 2, text, 3, 1 rs1.prg_projects.timestampfield01, 3, timestamp, 3, 1 rs1.prg_projects.timestampfield02, 4, timestamp, 3, 1 rs1.prg_projects.intfield01, 5, int8, 3, 1 rs1.prg_projects.field01, 6, text, 3, 1 rs1.prg_projects.field03, 7, text, 3, 1 rs1.prg_projects.field04, 8, text, 3, 1 rs1.prg_projects.field05, 9, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT created_from, group_right, timestampfield01, timestampfield02, intfield01, field01, field03, field04, field05 FROM prg_projects** **NAS_WHERE = WHERE ((field05 NOT LIKE 'DONE' AND (upper(field01) LIKE '|**searchPattern**|' OR upper(field04) LIKE '|**searchPattern**|' OR upper(field07) LIKE '|**searchPattern**|')) AND (((user_right LIKE '|**NAS_USER**|') OR (group_right LIKE 'g' AND intfield01 IN (SELECT object_id FROM prg_projects_members WHERE ((intfield01 = object_id) AND (member_uid LIKE '|**NAS_USER**|')))))))** **NAS_ORDER = ORDER BY |**PROJECT-ORDER**|** **NAS_MR = 200** **NAS_NFC = maxRowSide** **NAS_SQL_OBJECTS NAME=rs1** **NAS_VO TYPE="CHOICE" NAME="SPO_projectsView" DB_VALUE=1|2|3|4 HTML_VALUES=Liste|Überfällige Projekte|nächsten 7 Tage|Archiv REFERENZ=S2 JAVASCRIPT=onChange="this.form.submit();"**