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:
- Default
- Block (div)
- Inline (span)
- Comma Separated Values
- List (ordered or unordered)
- Table
- Link Button
- Image
- Date
- Progress Bar
- QR Code
- 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