Groupware - **OX_APP

**NAS_DB_OBJECTS** rs2.prg_tasks.intfield01, 1, int, 3, 1 rs2.prg_tasks.field01, 2, text, 3, 1 rs2.prg_tasks.field03, 3, text, 3, 1 rs2.prg_tasks.timestampfield01, 4, timestamp, 3, 1 rs2.prg_tasks.timestampfield02, 5, timestamp, 3, 1 rs4.projects_milestones.intfield01, 1, int, 3 , 1 rs4.projects_milestones.id, 2, int, 3 , 1 rs4.projects_milestones.name, 3, text, 3 , 1 rs4.projects_milestones.mdate, 4, timestamp, 3 , 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, id, name, mdate FROM projects_milestones** **NAS_WHERE = WHERE (intfield01 = |**vkn**|) AND (('|**NAS_USER**|' IN (SELECT projects.user_right FROM projects WHERE projects.intfield01 = |**vkn**|) OR '|**NAS_USER**|' IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > 2 AND projects_participants.intfield01 = |**vkn**|)))** **NAS_ORDER = ORDER BY mdate ASC** **NAS_MR = 200** **NAS_NFC = 10** **NAS_SQL_OBJECTS NAME=rs4** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01, field03, timestampfield01, timestampfield02 FROM prg_tasks** **NAS_WHERE = WHERE (field03 IS NOT NULL AND field03 LIKE '|**vkn**|') AND (('|**NAS_USER**|' IN (SELECT projects.user_right FROM projects WHERE projects.intfield01 = prg_tasks.field03) OR '|**NAS_USER**|' IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > 2 AND projects_participants.intfield01 = prg_tasks.field03)) OR ('|**NAS_USER**|' IN (SELECT prg_tasks_members.member_uid FROM prg_tasks_members WHERE prg_tasks_members.object_id = prg_tasks.intfield01)))** **NAS_ORDER = ORDER BY field01 ASC** **NAS_MR = 200** **NAS_NFC = 10** **NAS_SQL_OBJECTS NAME=rs2** Groupware - **OX_APP_TITLE**