**NAS_DB_OBJECTS** rs1.prg_projects.user_right, 1, text, 3, 1 rs1.prg_projects.group_right, 2, text, 3, 1 rs1.prg_projects.intfield01, 3, int8, 3, 1 rs1.prg_projects.intfield06, 4, int8, 3, 1 rs1.prg_projects.field05, 5, int8, 3, 1 rs2.prg_tasks.created_from, 1, text, 3, 1 rs2.prg_tasks.group_right, 2, text, 3, 1 rs2.prg_tasks.timestampfield01, 3, timestamp, 3, 1 rs2.prg_tasks.timestampfield02, 4, timestamp, 3, 1 rs2.prg_tasks.intfield01, 5, int8, 3, 1 rs2.prg_tasks.field01, 6, text, 3, 1 rs2.prg_tasks.field04, 7, text, 3, 1 rs2.prg_tasks.field05, 8, text, 3, 1 rs3.count.count, 1, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT user_right, group_right, intfield01, intfield06, field05 FROM prg_projects** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT created_from, group_right, timestampfield01, timestampfield02, intfield01, field01, field04, field05 FROM prg_tasks** **NAS_WHERE = WHERE |**ProjectsTasksSql**|(field03 IS NOT NULL AND field03 LIKE '|**rs1.prg_projects.intfield01**|') AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)) OR (orp = 2) AND prg_tasks.created_from LIKE '|**NAS_USER**|' AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)))))** **NAS_ORDER = ORDER BY |**PROJECTS_TASKS_ORDER**|** **NAS_MR = 200** **NAS_NFC = maxRowSide** **NAS_SQL_OBJECTS NAME=rs2** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(intfield01) AS count FROM prg_tasks** **NAS_WHERE = WHERE |**ProjectsTasksSql**|(field03 IS NOT NULL AND field03 LIKE '|**rs1.prg_projects.intfield01**|') AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)) OR (orp = 2) AND prg_tasks.created_from LIKE '|**NAS_USER**|' AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)))))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs3** **NAS_VO TYPE="CHOICE" NAME="ProjectsTasksSelect" DB_VALUE=0|1|2 HTML_VALUES=List|Active tasks|Finished tasks REFERENZ=S2 JAVASCRIPT=class="select-normal" onChange="this.form.submit();"**