Groupware - **OX_APP

**NAS_DB_OBJECTS** rs1.projects.creation_date, 1, timestamp, 3, 1 rs1.projects.created_from, 2, text, 3, 1 rs1.projects.changed_from, 3, text, 3, 1 rs1.projects.changing_date, 4, timestamp, 3, 1 rs1.projects.user_right, 5, text, 3, 1 rs1.projects.intfield01, 6, int8, 3, 1 rs1.projects.project_name, 7, 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 creation_date, created_from, changed_from, changing_date, user_right, intfield01, project_name FROM projects** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** **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**