**NAS_DB_OBJECTS**
rs1.projects_dependencies.intfield01, 1, int, 3, 1
rs1.projects_dependencies.id, 2, int, 3, 1
rs1.projects_dependencies.successor, 3, text, 3, 1
rs1.projects_dependencies.dependency_type, 4, int, 3, 1
rs1.projects_dependencies.object_type, 5, int, 3, 1
rs2.projects_antecessors.intfield01, 1, int, 3, 1
rs2.projects_antecessors.id, 2, int, 3, 1
rs2.projects_antecessors.antecessor, 3, text, 3, 1
rs2.projects_antecessors.object_type, 4, int, 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 intfield01, id, successor, dependency_type, object_type 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 id FROM projects_participants WHERE intfield01 = |**vkn**| AND merged_permission > |**CHIEF_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 = ORDER BY |**DEPENDENCIES_ORDER**|**
**NAS_NFC = maxRowSide**
**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**