Custom Tables Catalog Module extension for Joomla!

3.1.6 (2023-09-11) - Back-end: Copy field bug fixed; Copy table bug was fixed. TableJoin field type: deleted value check added, checks if selected value present and not block the selection option. TableJoin: Add a new option (inside the select box) that passes a selected parameter to a modal form when needed. Tags added: {{ record.missingfields(separator) }} and {{ record.missingfieldslist }}. Tag improvement: {{ fieldname.edit }} tag can be used outside the record - this allows changes to be applied to all the records on that page (visible records). Input elements: Placeholder attribute added to Table Join field input box. Virtual fields are refreshed when the Refresh button is clicked.
 
3.1.5 (2023-08-21) - Save/Publish/Unpublish record code reorganized. Custom PHP functions moved to the Plugin. A custom PHP script may override the Return To page parameter; TableJoin Field Type: Third-party table Primary key bug fixed. "Selected value does not have a parent" check added. Add a new record button to add child records; Detailed View Calendar field activation added when needed; Twig Library updated. {{ tables.getvalue }} tag bug was fixed and a Modal form return link was added.

3.1.4 (2023-07-24) - Table Join JSON list encoding improved. Table Join additional filter override bug fixed. Virtual value has to be processed even when calling the ".value" function. Table Multi Record field type bug fixed. The default Page layout issue is fixed. Tags {{ record.min }},{{ record.max }},{{ record.avg }},{{ record.sum }} fixed. They were returning count value instead. Table Multi-join default class conflict fixed. Improved Select box added to Table Join field type.

3.1.3 (2023-07-04) - Table Join field type: A list of parameters can be passed to render a value. Twig JSON filters added ( "| json_decode" and "| json_encode"). The {{ html.button }} improved, the empty default value changed to NULL. Back-end Layouts and Tables list of Dependence fixed. Query parameters can be passed to a modal form while adding a new record. Add a new record while selecting an Item from the dropdown list functionality added. The multi-Table Join field inline parameters issue is fixed. The filter can be passed as a parameter now.

3.1.2 (2023-06-22) - htmlspecialchars added for output values. Following tags has been added: {{ record.count('table','filter') }}, {{ record.avg('table','field','filter') }}, {{ record.max('table','field','filter') }}, {{ record.min('table','field','filter') }}, {{ record.sum('table','field','filter') }}, text function + character problem fixed. Filters improved.

3.1.1 (2023-06-20) - Save Table Join id fixed. Multiple Table Join field type improved. Selector values are processed. Table Join multi-record field type value separator character added. A default value can be applied to almost any field type. Twig parsing error messaging improved. Layouts can be saved as files - the "Save Layouts to file" option was added to the Global Configuration. Back-end list of records Table Join values bug fixed.

3.1.0 (2023-05-05) - Search by Radio field type added. Save non-numerical Table Join IDs issue fixed.

3.0.9 (2023-04-27) - Import tables bug fixed. reCapthca check fixed. Email validation added. MySQL <5.7 checks added. Order By field permission bug fixed. Multiple Table Join record values can be separated by custom char. Records fields type: Output layout parameter added.

3.0.8 (2023-04-03) - File Box field type code cleaned. Documentation bug fixed. Search text input box max length changed from 0 to 1024 (bug fixed). Virtual Field Type added. Virtual field storage option added and Field Type check added. Logs view warnings fixed. Table Join layout error handling improved.

3.0.7 (2023-02-19) - CSV explode fixed, double character separators are possible. Option List null value bug fixed. FileBox php8 compatibility fixed. Language files updated. Virtual Generated field added. Backend: Save as Copy and Check-in buttons redirect bug fixed.

3.0.6 (2023-02-01) - Image Gallery field type: Image Size selector added. Default Image Size options added to Layout Editor - Image Gallery field type. User field type php 8.0 compatibility fixed. Google Map does not load if no key provided. HTML tag parameter "width" replaced with CSS. Alias field length extended to 1025 chars.

3.0.5 (2023-01-28) - Menu Item - Default Catalog Layout added - no need to create or select. Ordering Field Type bug fixed. 

3.0.4 (2023-01-25) - Filebox field type, multiple filebox fields bug fixed. Table Join filter params bug fixed. {{ table.title }} multilingual bug fixed. Export table structure file name is limited to 128 characters. XML output possible without clean=1 URL parameter. Pagination warning fixed. Twig loader check added. Empty parameter check added. {{ html.search() }} tag improved. The field may contain a Layout name after it to render the values according it. Example {{ html.search("myfield:TheLayoutName") }}

3.0.3 (2023-01-07) - Back-end. Layout editor bug fixed (CodeMirror Unicode character)

3.0.2 (2023-01-03) - Twig filters available during Form Submit - useful to filter what fields to save. {{ record.id }} tag returns "" when adding new records. Table Join value can be used in default values. Field name Sanitization added - when adding a new table field the field name is cleaned to "a-z0-9". German translation improved in the back-end. Joomla 3 - back-end, list ordering (sort-by) bug fixed. Back-end import table structure bug fixed.

3.0.1 (2022-12-20) - Joomla 3, Back-end. Edit Table - Save, Save and Close buttons fixed. 

3.0.0 (2022-12-10) - Back-end: Add new record button problem fixed. Compatibility with J4.2.5. Table Join field type warning fixed. Postfix quote character problem fixed. Table Join sub select fixed. Save multilingual string bug fixed. Table Join default value from query added. {{ field.getvalue }} tag added. Layout editor - the link to depending layout fixed. Table Join UTF-8 encoding enforced. (Joomla 3) Select a record with the checkmark and press Edit. It open the form to add a record and not to edit. - Fixed. Fields. Save&Close. "not checked in" fixed.

2.9.9 (2022-11-29) - Documentation improved (images added). The tag {{ user("lastvisitDate") }} can be written in lower case. PHP 8.1 compatibility issues fixed. The tag {{ html.search }} tag requires at least one field check added.

2.9.8 (2022-11-11) - Image File field type - multiple uploads problem fixed. Code maintenance: Types fixed. Table Join custom title option added: Example: {{ componentid.edit("mycss","readonly",["grades","grade"],"gradesTitleLayout") }}. Documentation: Unnecessary quotes deleted.

2.9.7 (2022-11-06) - {{ url.format() }} tag fixed. Export to CSV works without any Layout. User registration email subject and body text Joomla 4 bug fixed. Export to CSV file button added to the Back-end: List of Records. Multiple Image File field type problem fixed.

2.9.6 (2022-10-25) - Radio field type selector added. Image field type folder changed event: move files by step is changed to 1000 files per step. Details page: Listing Id value possible bug fixed. Layout Editor: Tag double click functionality improved/fixed.

2.9.5 (2022-10-22) - Details Page view - filter affecting the listing id bug fixed [Issue #36]. Layout editor - {{ fieldname.edit }} tag double click bug fixed [Issue #34]. Table Join field type Parent Selector explanation added [Issue #35].

2.9.4 (2022-10-19) - Image field type improved - An option to select the way to name the uploaded file is added. Edit form - list of fields edited is rendered from the layout. J3 Layout Editor - Tag properties modal window - Radio box bug fixed.

2.9.3 (2022-10-03) - Back-end: Control Panel Search, Filters and "Sort By" fixed or improved. Field name transliterator added. Twig Library updated (security update).

2.9.2 (2022-09-28) - Back-end: List of fields and Records - Go back to Tables button added. Table name may contain the underscore character. Blob upload size limited by blob field type along with PHP settings.

2.9.1 (2022-09-27) - Blob field type improved. Files uploaded to BLOB field are downloadable same like normal files. The original field name can be stored in selected field. File extension can be detected by the MIME type of the data if the field to store the original file name is not selected.

2.9.0 (2022-09-14) - Back-end: Add new field - Save and continue button fixed. Custom ordering fields and layout wizard fixed. Documentation: numerical parameters without quotes bug fixed. Text field type value length can be set between 255bytes to 4gb. Duplicate JS file declaration fixed. User author not updated if already set bug fixed. Table tag id added to simple catalog and catalog page layouts. Blob field type added.

2.8.9 (2022-08-24) - Search Reset button added {{ html.searchreset }}

2.8.8 (2022-08-24) - Field Type Ordering functionality improved: You can drag and drop records to organize the order in the front-end.

2.8.7 (2022-08-18) - Google Map view added to catalog layout. Captcha fixed. JS code cleaned.

2.8.6 (2022-08-10) - Back-end: Both field types Table Join and Multi Table Join are improved - field name select box added. Field selection also works in the Layout Editor, when editing tag parameters.

2.8.5 (2022-08-02) - Image parameters back-end for joomla 3.x fixed. {{ table.title }} tag bad fixed. Alpha-numerical field names can be used in filters. XML fieldtypes and tags loaded using PHP. Pagination for J4 improved. Pagination arrows option added (Text or Icons).

2.8.4 (2022-07-27) - Image Gallery and File Box filed types fixed.

2.8.3 (2022-07-26) - {{ html.checkboxcount }} tag added. Extended Twig filters added. Multi table join field value bug fixed. Connection to third-party table bug fixed. Upload image required message added.

2.8.2 (2022-07-13) - New tags added: {{ table.recordstotal }}, {{ table.recordpagestart }} and {{ table.recordsperpage }}. Also RTF file format is available to upload.

2.8.1 (2022-07-04) - {{ fieldname.layout() }} Layout content can be passed as an argument instead of Layout Name. {{ tables.getrecords() }} limit parameter fixed. Default records per page limit set to 20000. User Groups field type output value fixed. {{ toolbar("editmodal") }} fixed.

2.8.0 (2022-06-23) - Ordering improved, nested tables can be used, example: "model.brand.name desc" - where "model" and "brand" is Table Join fields and "name" the string field. Open detailed by alias instead of listing_id fixed. User not found warning fixed.

2.7.9 (2022-06-21) - CSV export improved: {{ url.format("csv","","",16,"app_video_csv",",") }}, you can pass layout name to render the export. Also there is a parameter to specify the delimiter/separator.

2.7.4 [2022-05-11] - Model independent. Loads catalog using CT class - works faster.

2.6.2 [2022-03-10] - Version update.

2.6.0 [2022-01-18] - Compatibility with Custom Tables component fixed.

1.0.2 [2018-04-08] - Compatibility issue fixed. 1.0.1 [2018-05-08] - First release.

*Version number is to match the main component (Custom Tables) version.