Different Views of One Table
Jege
Fresh Boarder
Posts: 1
9 Jahre 3 Monate her #594
von Jege
Different Views of One Table wurde erstellt von Jege
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
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Tomasz Tomzik
Besucher
7 Jahre 10 Monate her #1364
von Tomasz Tomzik
Tomasz Tomzik antwortete auf Different Views of One Table
nice support! One year ago...
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Tomasci
Fresh Boarder
Posts: 17
7 Jahre 2 Monate her #1499
von Tomasci
Tomasci antwortete auf 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
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
sophia Abigail
Fresh Boarder
Posts: 1
1 Jahr 7 Monate her #9995
von sophia Abigail
sophia Abigail antwortete auf 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.
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Ladezeit der Seite: 0.150 Sekunden