Different Views of One Table
Jege
New Member
Posts: 1
9 года 3 мес. назад #594
от Jege
Jege создал тему: Different Views of One Table
Hello,
I am quite new in joomla. I use a component creator just for 3 days and I couldn't manage to do the following:
There is one table - for ex. visitor_entries
1. one user enters surname of a visitor and department name where the visitor should come
2. another user (responsible for visitor entry permissions) looks at this, selects and enters some additional information about the visitor, but this user isn't allowed to change the data entered by the previous user.
3. third user enters the status change in the table when the visit is finished
4. if the visitor hasn't come, the first or second user is allowed to cancel the visit by entering the status change in the table
So, I have actually one table with 4 different views and controls.
Can you give me the hint how to do it?
I have searched through the source files, but I couldn't find any "update" or "insert" command generated through php or xml
I am quite new in joomla. I use a component creator just for 3 days and I couldn't manage to do the following:
There is one table - for ex. visitor_entries
1. one user enters surname of a visitor and department name where the visitor should come
2. another user (responsible for visitor entry permissions) looks at this, selects and enters some additional information about the visitor, but this user isn't allowed to change the data entered by the previous user.
3. third user enters the status change in the table when the visit is finished
4. if the visitor hasn't come, the first or second user is allowed to cancel the visit by entering the status change in the table
So, I have actually one table with 4 different views and controls.
Can you give me the hint how to do it?
I have searched through the source files, but I couldn't find any "update" or "insert" command generated through php or xml
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Tomasz Tomzik
Посетитель
7 года 10 мес. назад #1364
от Tomasz Tomzik
Tomasz Tomzik ответил в теме Different Views of One Table
nice support! One year ago...
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Tomasci
New Member
Posts: 17
7 года 2 мес. назад #1499
от Tomasci
Tomasci ответил в теме Different Views of One Table
Hi.
Did you find out how to do this?
I have a simular issue. I want to create both list and grid view for 1 table.
Thanks
Did you find out how to do this?
I have a simular issue. I want to create both list and grid view for 1 table.
Thanks
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
sophia Abigail
New Member
Posts: 1
1 год 7 мес. назад #9995
от sophia Abigail
sophia Abigail ответил в теме Different Views of One Table
We can create View using CREATE VIEW statement. A View can be created from a single table or multiple tables. Syntax:
There are two types of database views: dynamic views and 192.168.l.254 static views. Dynamic views can contain data from one or two tables and automatically include all of the columns from the specified table or tables. Dynamic views are automatically updated when related objects or extended objects are created or changed.Complex View Contains Multiple Tables Data hence it is not possible to perform DML command on this view. Yes, Possible but only when we create the View of One table, Means for Simple View you can perform Insert,Update and Delete also but in Complex View you Can't Means a View which is created by More then two Tables.
There are two types of database views: dynamic views and 192.168.l.254 static views. Dynamic views can contain data from one or two tables and automatically include all of the columns from the specified table or tables. Dynamic views are automatically updated when related objects or extended objects are created or changed.Complex View Contains Multiple Tables Data hence it is not possible to perform DML command on this view. Yes, Possible but only when we create the View of One table, Means for Simple View you can perform Insert,Update and Delete also but in Complex View you Can't Means a View which is created by More then two Tables.
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Время создания страницы: 0.326 секунд