Different Views of One Table

7 years 10 months ago #594 by Jege
Different Views of One Table was created by 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

Please Log in or Create an account to join the conversation.

6 years 5 months ago #1364 by Tomasz Tomzik
Replied by Tomasz Tomzik on topic Different Views of One Table
nice support! One year ago...

Please Log in or Create an account to join the conversation.

5 years 9 months ago #1499 by Tomasci
Replied by Tomasci on topic 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

Please Log in or Create an account to join the conversation.

5 years 9 months ago #1509 by Andres Maeso
Replied by Andres Maeso on topic Different Views of One Table
Hi

As the introduction to the forum says: "Please note: This is a community forum and is not actively monitored by the Component Creator team. It is here for the community to exchange tips and tricks and help each other get the most out of Joomla Component Creator."

If you need support and you are a premium user, please use the contact form: www.component-creator.com/en/help/contact

Regards,

Andrés.

Andrés Maeso
Customer relations manager at Joomla Component Creator.

This email address is being protected from spambots. You need JavaScript enabled to view it.
The following user(s) said Thank You: Eoin Oliver

Please Log in or Create an account to join the conversation.

2 months 1 week ago #9995 by sophia Abigail
Replied by sophia Abigail on topic 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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.148 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.