Groupware - **OX_APP

**NAS_DB_OBJECTS** rs1.projects.intfield01, 1, int, 3, 1 rs1.projects.creation_date, 2, timestamp, 3, 1 rs1.projects.created_from, 3, text, 3, 1 rs1.projects.changing_date, 4, timestamp, 3, 1 rs1.projects.changed_from, 5, text, 3, 1 rs1.projects.user_right, 6, text, 3, 1 rs1.projects.sid, 7, text, 3, 1 rs1.projects.tid, 8, text, 3, 1 rs1.projects.project_startdate, 9, timestamp, 3, 1 rs1.projects.project_enddate, 10, timestamp, 3, 1 rs1.projects.project_deadline, 11, timestamp, 3, 1 rs1.projects.project_budget, 12, float8, 3, 1 rs1.projects.project_type, 13, text, 3, 1 rs1.projects.project_kickoff, 14, timestamp, 3, 1 rs1.projects.project_description, 15, text, 3, 1 rs1.projects.project_goal, 16, text, 3, 1 rs1.projects.project_customer, 17, text, 3, 1 rs1.projects.project_name, 18, text, 3, 1 rs1.projects.project_status, 19, text, 3, 1 rs1.projects.project_phase, 20, text, 3, 1 rs1.projects.project_currency, 21, text, 3, 1 rs2.projects_participants.id, 1, text, 3, 1 rs2.projects_participants.name, 2, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT projects.intfield01, projects.creation_date, projects.created_from, projects.changing_date, projects.changed_from, projects.user_right, projects.sid, projects.tid, projects.project_startdate, projects.project_enddate, projects.project_deadline, projects.project_budget, projects.project_type, projects.project_kickoff, projects.project_description, projects.project_goal, projects.project_customer, projects.project_name, projects.project_status, projects.project_phase, projects.project_currency FROM projects** **NAS_WHERE = WHERE (projects.fuid = |**PROJECT_FOLDER_ID**| AND (projects.user_right LIKE '%|**NAS_USER**|%' OR projects.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 projects.user_right LIKE '%|**NAS_USER**|%'))|**ADDITIONAL_AND**|** **NAS_ORDER = ORDER BY |**PROJECT_ORDER02**|** **NAS_MR = 200** **NAS_NFC = maxRowSide** **NAS_SQL_OBJECTS NAME=rs1** **NAS_VO TYPE="CHOICE" NAME="projectsView" DB_VALUE=1|2|3|4|5 HTML_VALUES=Alle|Liste|Überfällige Projekte|Nächsten 7 Tage|Archiv REFERENZ=VO_PROJECT_VIEW_SELECT JAVASCRIPT=onChange="this.form.submit();"** Groupware - **OX_APP_TITLE**

**VO_PROJECT_VIEW_SELECT**

Liste

**NumberOfResults_rs1**

**ERROR-MESSAGE** **NAS-REPEAT NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT id, name FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**rs1.projects.intfield01**| AND role = |**LEADER_ROLE_INDEX**|** **NAS_ORDER = ** **NAS_MR = 200** **NAS_NFC = maxRowSide** **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