Groupware - **OX_APP

**NAS_DB_OBJECTS** 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.projects_participants.intfield01, 1, int, 3, 1 rs3.projects_participants.id, 2, text, 3, 1 participant_count.count.count, 1, text, 3, 1 milestone_count.count.count, 1, text, 3, 1 task_count.count.count, 1, text, 3, 1 dependency_count.count.count, 1, text, 3, 1 note_count.count.count, 1, text, 3, 1 link_count.count.count, 1, text, 3, 1 attachment_count.count.count, 1, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT prg_tasks.created_from, prg_tasks.group_right, prg_tasks.timestampfield01, prg_tasks.timestampfield02, prg_tasks.intfield01, prg_tasks.field01, prg_tasks.field04, prg_tasks.field05 FROM prg_tasks** **NAS_WHERE = WHERE (field03 IS NOT NULL AND field03 LIKE '%|**vkn**|%') AND ((|**HAS_USER_RIGHT_OR_IS_LEADER**|) OR (|**IS_CHIEF**|) OR (|**IS_PARTICIPANT**|))** **NAS_ORDER = ORDER BY |**TASKS_ORDER**|** **NAS_NFC = maxRowSide** **NAS_SQL_OBJECTS NAME=rs2** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_participants.id) AS count FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND group_id LIKE |**NO_GROUP_ASSIGNMENT**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=participant_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_milestones.id) AS count FROM projects_milestones** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=milestone_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(prg_tasks.intfield01) AS count FROM prg_tasks** **NAS_WHERE = WHERE (field03 IS NOT NULL AND field03 LIKE '%|**vkn**|%') AND ((|**HAS_USER_RIGHT_OR_IS_LEADER**|) OR (|**IS_CHIEF**|) OR (|**IS_PARTICIPANT**|))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=task_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(projects_dependencies.id) AS count FROM projects_dependencies** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND ('|**NAS_USER**|' IN (SELECT id FROM projects_participants WHERE intfield01 = |**vkn**| AND merged_permission > |**STAFF_ROLE_INDEX**|) OR '|**NAS_USER**|' IN (SELECT user_right FROM projects WHERE intfield01 = |**vkn**|) OR '|**NAS_USER**|' IN (SELECT member_uid FROM prg_tasks_members WHERE object_id IN (SELECT successor FROM projects_dependencies WHERE intfield01 = |**vkn**|) OR object_id IN (SELECT antecessor FROM projects_antecessors WHERE intfield01 = |**vkn**| AND id = projects_dependencies.id)))** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=dependency_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(prg_notes.intfield01) AS count FROM prg_notes** **NAS_WHERE = WHERE prg_notes.sid LIKE '|**vkn**|'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=note_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(links.id) AS count FROM links** **NAS_WHERE = WHERE links.firstid = |**vkn**| AND lower(links.firstmodule) LIKE '%project%'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=link_count** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(attachments.id) AS count FROM attachments** **NAS_WHERE = WHERE attachments.attachedto = |**vkn**| AND lower(attachments.module) LIKE '%project%'** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=attachment_count** Groupware - **OX_APP_TITLE**