Content and Columns

All Joomla articles or content is stored in one database table organised into different categories. However, in this extension, the content is stored in different database tables.

Database tables are called "Content" and different articles or items are called "Rows" or "Records". This extension gives you more power and control over the data. You can use it to create almost any application.

To create a new table click "New".

1. Content Tab

Title: This is the title of the table.

Description: This is the description of the table. It is displayed on the front-end list of records layout.

Name: This is the name of the database table. The name should be in small letters.

Access: Select the view access level for the database table.

2. Options Tab

Here, you can set the ordering of the records as displayed in the front-end.

Order Column: Select the name of the column.

Order Direction: Select from Ascending or Descending.

3. Display Tab

Here, you can set how records or items are displayed on the front-end. For a particular content, there are three types of display or views - List, Item and Form.

A. List View

Layout: Select the layout. There are two layouts available - cards, table.

Columns: In case of "cards" layout, enter the number of columns.

Table Headings: In case of "table" layout, enable or disable to show table headings.

Show Columns: Select columns to be displayed on the list view. Leave empty to use default columns. 

Show Search: If enabled, a search form is displayed above the records.

Show Date: If enabled, date is displayed for the records. You can enter which date (modified, created, or any other custom field column) is displayed in the Date Column.

B. Item View

Show Date: If enabled, date is displayed. You can enter which date (modified, created, or any other custom field column) is displayed.

Show Relations: If database table is related to other tables, you can show related records.

C. Form View

Title Field Label: Enter the label for the title field. Title is required for the record to be inserted into the database.

Description Field Label: Enter the label for the description field.

Show Description Field: Enable or disable to show description field on the front-end.

Default Access: Select the default access for the record when it is saved.

Default Status: Select the default status for the record when it is saved.

4. Columns Tab

After a new table is created, this tab will show all the columns (or fields) and their datatype in the table.

Columns

When you create a new table, 13 common columns are automatically created. You can extend the functionality by adding custom columns as per your requirement.

Default Columns

  1. id
  2. title
  3. alias
  4. description
  5. published
  6. created
  7. created_by
  8. modified
  9. image
  10. ordering
  11. access
  12. hits
  13. note

You can add columns to the database tables to extend its functionality. For example, if you are creating Movies database, you can add columns for release date, director, story and so on. Columns are also called "custom fields" or just "fields".