**NAS_DB_OBJECTS** rs1.projects.created_from, 1, text, 3, 1 rs1.projects.user_right, 2, text, 3, 1 rs1.projects.project_name, 3, text, 3, 1 rs1.projects.project_status, 4, text, 3, 1 rs1.projects.project_startdate, 5, timestamp, 3, 1 rs1.projects.project_enddate, 6, timestamp, 3, 1 rs1.projects.intfield01, 7, int8, 3, 1 rs1.projects.project_type, 8, int8, 3, 1 rs2.projects_participants.id, 1, text, 3, 1 rs2.projects_participants.name, 2, text, 3, 1 rs2.projects_participants.role, 3, int, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT created_from, user_right, project_name, project_status, project_startdate, project_enddate, intfield01, project_type FROM projects** **NAS_WHERE = WHERE (fuid = |**PROJECT_FOLDER_ID**| AND (user_right LIKE '%|**NAS_USER**|%' OR intfield01 IN (SELECT intfield01 FROM projects_participants WHERE id LIKE '%|**NAS_USER**|%'))|**SQL_AND_CLAUSE**|) AND (|**HAS_READ_ALL_OBJECTS**| OR (|**HAS_READ_OWN_OBJECTS**| AND user_right LIKE '%|**NAS_USER**|%'))** **NAS_ORDER = ORDER BY |**PROJECT_ORDER02**|** **NAS_MR = 200** **NAS_NFC = 200** **NAS_SQL_OBJECTS NAME=rs1** Groupware - **OX_APP_TITLE**

**area**

**ACTDATE**, **FULLNAMESORTED**
 
**NAS-REPEAT NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT id, name, role FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**rs1.projects.intfield01**| AND role = |**LEADER_ROLE_INDEX**|** **NAS_ORDER = ** **NAS_MR = 200** **NAS_NFC = 200** **NAS_SQL_OBJECTS NAME=rs2** **NAS-REPEAT NAME=rs1**

Name

Status

Startdatum

Enddatum

Art

Leiter
**rs1.projects.project_name**  **rs1.projects.project_status**  **rs1.projects.project_startdate**  **rs1.projects.project_enddate**  **rs1.projects.project_type**  **rs2.projects_participants.name**