TF Any Documentation

TF Any is Joomla custom fields plugin to display records from any Joomla database table or display any custom data in variety of formats.

General Options

Data Source: Select "Database Table" to display records from any Joomla database.

Database Table: Enter the database table name without prefix. For example: content, users

Select Columns: Enter comma separated names of columns to display.

Order Direction: Choose the ordering of records selected - Ascending, Descending or Random.

Order Column: Enter the name of column for ordering.

Limit: Number of records to display.

Offset: Enter the starting point to return the results.

After creating the field, you can add one or more conditions (WHERE clause) in the custom field while adding or editing the article.

Display Options

These settings define how data is displayed at the front-end.

Display Type: Choose how to display the data. Following options are available:

  1. Default
  2. Block (div)
  3. Inline (span)
  4. Comma Separated Values
  5. List (ordered or unordered)
  6. Table
  7. Link Button
  8. Image
  9. Date
  10. Progress Bar
  11. QR Code
  12. Raw (Used for Debugging)

Use Cases for Database as Source

  • Product comparison
  • Pricing tables
  • Event listings
  • Team or member directory
  • Real-estate or property listings
  • Course listings
  • FAQ tables
  • Download or document lists
  • Related articles table
  • Business or directory listings