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 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 intfield01, creation_date, created_from, changing_date, changed_from, user_right, sid, tid, project_startdate, project_enddate, project_deadline, project_budget, project_type, project_kickoff, project_description, project_goal, project_customer, project_name, project_status, project_phase FROM projects** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT id, name FROM projects_participants** **NAS_WHERE = WHERE intfield01 = |**vkn**| AND role = |**LEADER_ROLE_INDEX**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs2** Groupware - **OX_APP_TITLE**

Project

**TASK_FOLDER_INFORMATION**

**rs1.projects.project_name**

**ERROR-MESSAGE**

Do you really want to delete this project?

Project
Name:	rs1.projects.project_name
Start date:	rs1.projects.project_startdate
End date:	rs1.projects.project_enddate
Reminding Date:	rs1.projects.project_deadline
Status:	rs1.projects.project_status
Type:	rs1.projects.project_type
Leader:	rs2.projects_participants.name (rs2.projects_participants.id)
Customer:	rs1.projects.project_customer

Assigned Jobs
Delete assigned jobs? Yes No tasks_information Note: If you don't delete assigned jobs they will be detached from the project and assignement changed to "General Job"!