Extension:Cargo/Version history

Here is the entire version history for Cargo:

• 0.5 - 2015-01-06 - Initial version released
• 0.5.1 - 2015-01-12 - Various coding improvements
• 0.5.2 - 2015-02-02 - $wgCargoFieldTypes global variable added; "table_schema" field in database schema changed from VARCHAR to BLOB; other bug fixes; i18n added

• 0.6 - 2015-02-24 - "gallery" format added; "delimiter" parameter added for "csv" format; subqueries within queries now rejected; support added for Page Schemas; fix to avoid duplicates when populating tables via runJobs.php; fix for page moves; fix to support extra whitespaces in "tables" and "fields" parameters in #cargo_query; support added for dates in the format "YYYYMMDD"; fix for date handling in "dynamic table" format; fixes for Special:Drilldown display; other bug fixes
• 0.6.1 - 2015-03-23 - "more results text" parameter added to #cargo_query; better handling when "limit=0" is set in queries; "csv" and "json" format outputs get downloaded automatically, and have new "filename" and "link text" parameters; CSS classes added to "table" format; fix for handling of blank aliases in queries; fixes for Special:Drilldown; other fixes

• 0.7 - 2015-04-24 - Added query form to Special:ViewData; added "excel" format; "name" parameter added for "calendar" format; recreate data uses Ajax to prevent timeouts for large data sets; Special:Drilldown displays a simple text input (instead of a notice) if there is a large number of values; bug fixes

• 0.8 - 2015-05-20 - "having" parameter added for #cargo_query and #cargo_compound_query; "tag cloud" format added; date precision storage and display improved; "timeline" band selection improved; "timeline" can display a non-name field as the page name; "view" parameter added for "calendar" format; other bug fixes

• 0.9 - 2015-07-13 - Handling added for PostgreSQL; cargoRecreateData.php script added; fixes for when Cargo has a separate DB; $wgCargo24HourTime setting added; newlines removed between template calls for "template" format; fix for compound queries with "calendar" format; other bug fixes

• 0.10 - 2015-10-06 - "exhibit" format added; $wgCargoAllowedSQLFunctions variable added; other SQL validation improvements; extension.json file added; other improvements and bug fixes

• 0.11 - 2016-02-09 - Added String, URL and Email types; added "native" format and Lua library; added many more parameters for "gallery" format; added "named args" parameter for "template" format; fixed display of year-only and year-and-month-only dates; list values now displayed with middle dot (·) as delimiter; improved parsing and validation of SQL functions; fixed parsing/storage of Boolean values; commas and parentheses can be included in allowed values; extension.json only used for MW 1.27+; other bug fixes

• 1.0 - 2016-04-19 - Added _pageData table; added "Searchtext" type; added querying of Searchtext fields using "MATCHES" keyword; improved handling of PostgreSQL; added cargo.query() function for Lua interface; improved handling of Approved Revs extension
• 1.0.1 - 2016-05-05 - Fix for "Searchtext" storage for MySQL 5.6 and earlier; various fixes for query parsing

• 1.1 - 2016-08-15 - Added 'no html' param to #cargo_query; added $wgCargoGoogleMapsKey setting; changed $wgCargoPageDataColumns values from constants to strings; removed Lua "get" function; removed "native" format; added display of num rows to main Special:CargoTables screen; added "backlinks" to Special:CargoTables; added "view table" link to "table was recreated" text; removed drilldown header if there are no filters for a table; fix for hyphens in field names; fix for table deletion; fix for compound query with "calendar" format; fix for full storage of coordinate values; fix for long values for list fields; fix for display of URL list fields; fix for display within Special:RunQuery; fix for "gallery" format CSS display; fixes for MW 1.27
• 1.1.1 - 2016-09-15 - Added 'File', 'Email' to set of types not handled by drilldown; fix for drilldown bug from version 1.1; more fixes for MW 1.27

• 1.2 - 2016-11-17 - Added _fileData table; added full-text search of pages and files to Special:Drilldown; many bug fixes, especially for Special:Drilldown

• 1.3 - 2017-02-07 - Added support for MS SQLServer; "text color" and "height" parameters, and many alias options, added for "calendar" format; remote autocompletion added for Special:Drilldown; handling removed for MW < 1.21; added handling of "order by" to "dynamic table" format; fix for loading of JS files for "timeline" format; fix for handling of quotes with "MATCHES" keyword; fixes for handling dates in Special:Drilldown; fix for handling "join" together with "group by"; further fixes for Page Forms rename
• 1.3.1 - 2017-05-05 - Added aliasing for table names in queries; added $wgCargoHideNamespaceName variable; added updating of _pageData and _fileData tables on page move; fix for display of "timeline" format; fixed handling for MS SQL Server; improvements to Special:CargoTables display; fixes for Coordinate fields with spaces in their names; fix for querying non-ASCII characters in table and field names; fix for "calendar" format when there's no _pageName field; improved handling for MW 1.28+

• 1.4 - 2017-09-12 - Added support for hierarchy fields (including "WITHIN" and "HOLDS WITHIN" keywords, and $wgCargoMaxVisibleHierarchyDrilldownValues setting); "rows per page" parameter added for "dynamic table" format; "table" format made sortable; handling removed for MW 1.22; fix for handling of tables and fields with a number in their name; other fixes

• 1.5 - 2017-11-16 - "Replacement table" option added when recreating data; SQL check put in place to avoid duplicate rows; 2nd version of FullCalendar added to support MW 1.30+; FullCalendar i18n support added; end times displayed on calendar events; calendar week and day displays changed to use an "agenda" view; calendar "list" view added for MW 1.30+; "_lastUploadDate" and "_numPages" fields added for "_fileData" table; code file restructuring; more i18n for error messages; bug fixes

• 1.6 - 2018-01-22 - New query param, 'max display chars'; added "merge similar cells" param to "table" format; added "delimiter" param for "template" format; added table structure display to top of "View table"; added automatic minimizing of large texts in "View table"; changed default sort to be on more than one field; fix for blank aliases; fix to prevent updated pages from getting deleted from "read-only" tables; fixed display of values that start with a '*' or '#'; fix for MW 1.23 support; other fixes

• 1.7 - 2018-03-09 - "mandatory", "unique" and "regex" parameters added for #cargo_declare; "offset" parameter added for queries; data storage turned into a transaction as further guard against duplicate rows; DB information can be obtained from $wgDBservers setting; set of forbidden field and table names (due to being SQL keywords) expanded; other fixes and improvements

• 2.0 - 2018-10-19 - Overhaul of Special:Drilldown (most popular values shown for large value sets; additional tabs displayed ('map', 'timeline', 'calendar', 'gallery') depending on field types; custom tabs; dependent filters added; parent tables added; better mobile display); added indexing of most DB fields; added handling for <, > comparisons in joins; added _isRedirect column to _pageData; added "pie chart" format; added "searchable columns", "details fields" and "hidden fields" parameters to "dynamic table" format; added "show dimensions" parameter to "gallery" parameter; added "parse values" parameter for export formats; made #cargo_declare syntax case-insensitive; added $wgCargoDefaultStringBytes and $wgCargoDefaultMapService global variables; added "CargoTablesActionLinks" and "CargoBeforeStoreData" hooks; added table of contents for "page values" view; various special changes converted to use OOUI; fixed handling of fields that hold a list of dates; fixed display of null dates; fixed display of dates in "bar chart" format; better error handling in "bar chart"; fixed handling of "link text" param in #cargo_declare; many other fixes
• 2.0.1 - 2018-10-30 - Fixed declaration of list fields; fixes for creation and deletion of replacement tables; improved handling of MW >= 1.32

• 2.1 - 2019-01-31 - Added "slideshow" format; added "Start date", "End date", "Start datetime" and "End datetime" types; added "Wikitext string" type, changed "Wikitext" storage to be TEXT; removed "Purge cache" tab (should now be done via Purge extension); added logging of table actions; added "_position" field to list tables; added "runcargoqueries" permission; added TRIM() hack for not-to-be-parsed fields; made _fileData path field "hidden" in drilldown; fixes for the handling of non-ASCII characters in the names and aliases of tables and fields; fix for assessing type of MIN(), MAX(); striping in "table" format now done differently based on "merge similar cells"; fix for MySQL search for MW >= 1.31; other fixes
• 2.1.1 - 2019-02-07 - Restored "purge cache" tab; removed confirmation step for purge cache action; added $wgCargoDBRowFormat setting; fix for "timeline" format JS errors; fix for timeline display of events with no end date
• 2.1.2 - 2019-02-21 - Fixes for querying "deferred" formats like calendar and maps; fix for querying list fields

• 2.2 - 2019-06-10 - Added "Rating" data type; removed escaping of " " as "_" in drilldown filter values; changed URL values in query results to be links; storage and querying fixes for PostgreSQL; drilldown fixes; fixed handling for self-links in query results; other fixes

• 2.3 - 2019-09-18 - Renamed Special:ViewData to Special:CargoQuery and overhauled interface; added "bibtex" format; added "replacement" option for _pageData, _fileData; disallowed "-" and final "_" in table and field names; fixes for #cargo_compound_query; other fixes
• 2.3.1 - 2019-09-30 - Fix for "action=pagevalues"; fix for pagination for filter values with spaces in Special:Drilldown; other fixes

• 2.4 - 2020-01-09 - Removed support for MW <= 1.28; improved support for MW >= 1.32; removed support for MySQL <= 5.6; "colors" and "hide legend" params added to "pie chart" format; fixes for checking of duplicate values during storage; fixes for Special:CargoQuery; fixes for storage of categories info in _pageData table; fixes for handling of page moves; fixes for "details fields" param of "dynamic table" format; fixes for handling of Approved Revs; other fixes

• 2.5 - 2020-04-28 - Added "leaflet" map result format; added "leaflet" service option to #cargo_display_map; changed Special:CargoTables display to be more compact; added "IF" to default allowed SQL functions; added "View wikitext" option to Special:CargoQuery; fix for storage of lists of dates; fix for queries to join on "list tables" only if they are queried on; improved handling of MW 1.32+; other fixes

• 2.6 - 2020-06-09 - Added "icalendar" result format; internal SQL for "HOLDS" in "where" parameter changed to use nested SELECT calls; added $wgCargoDBprefix global variable; changed default value of $wgCargoTablesPrioritizeReplacements to false; Special:CargoTables ignores tables that are "registered" in cargo_tables but do not exist; bug fixes; added PHP tests

• 2.7 - 2020-08-18 - Added new (optional) helper tables to hold data from the Flex Diagrams extension; various improvements and fixes for MW 1.31 and newer MW versions; _fileData table gets updated on file uploads; fix for storage of list of Integer fields; disallow list of Boolean fields; fixes for Special:Drilldown CSS; other fixes
• 2.7.1 - 2020-12-28 - Added "=link" alias for calendar format; improved handling for MW 1.35; fixes for PHP 7.4; other bug fixes

• 2.8 - 2021-04-14 - Made #cargo_store parameters optional; added Special:CargoTableDiagram; added handling for $wgDBport (PostgreSQL feature); improved handling of non-ASCII characters in field names; removed support for MW 1.29 (and jQuery 1); added parsing of "intro", "outro" parameters of queries; fixed calendar format when no colors are set; improved parsing of quotes in MATCHES queries; PostgreSQL fixes

• 3.0 - 2021-09-23 - Removed support for MW 1.30 and 1.31; removed support for MSSQL and Oracle databases; added "bpmn" and "gantt" result formats; added marker clustering support for "leaflet" format; added "cluster" and "center" parameters for all map formats; added "icon" parameter handling for non-compound map queries; added "recreate data" link when viewing a table; added sticky header and field-information icon to "pagevalues" action display; added century filtering to Special:Drilldown; switched to OOUI for some interface elements in Special:Drilldown and Special:CargoQuery; removed check of $wgAdvancedSearchHighlighting when displaying text snippets; added ability to create Cargo table automatically on template save, for use by the Page Exchange extension; fixes for storage of blank and invalid dates; other fixes

• 3.1 - 2022-01-26 - Added cargo_backlinks DB table; added "zip" query format; added auto-formatting to "bpmn" query format; added datepicker navigation tool to "calendar" format; added "column widths" and "header tooltips" to "dynamic table" display format; added fallback when _pageName does not exist in Cargo "icalendar" format; added "formatTable" Lua function; enabled creating and recreating special tables from Special:CargoTables; overhaul of _bpmnData table for Flex Diagrams extension; added "replacement table" handling for _bpmnData and _ganttData; removed lockForUpdate() call, added in version 2.5 - it slowed down page saves considerably; added Unicode replacement for '#' in query "where" string; added ordering of join conditions according to "tables" argument; improved handling for MW 1.37+, 1.38+; fixed storage of Integer fields not specified in #cargo_store; various Special:Drilldown fixes; other fixes

• 3.2 - 2022-04-27 - Added _lastEditor and _pageIDOrRedirect fields to _pageData table; added display of delimiter for list fields in Special:CargoTables; added "default fields" like _pageName in _pageData table display within "action=pagevalues"; added $wgCargoLegacyStoreNullAsEmptyString variable to enable storage of missing fields as blank instead of null; removed PHP entry point; fixes when using cargo_backlinks DB table (added support for MW < 1.37; fixed bugs for "group by" and other queries); fixed PostgreSQL date field error in Special:Drilldown; improved handling for MW 1.38+; other bug fixes

• 3.3 - 2022-09-14 - Removed support for MW 1.32; added "table" param as alias for "_table" to #cargo_attach; added $wgCargoLegacyNullLuaFieldsAsEmptyString and $wgCargoStoreUseTemplateArgsFallback settings; added "columns" param to Gantt format; Gantt display improvements; added "cargotables" and "cargofields" API actions; bug fixes
• 3.3.1 - 2022-11-30 - Fixed support for MW 1.39+; fixed handling of date list storage; fixes for handling of hierarchy fields in Special:Drilldown; made ASC and DESC checks case-insensitive; other fixes

• 3.4 - 2023-01-18 - Removed support for MW 1.33 and 1.34; improved support for MW 1.39+; added "edit" link to Page column in Special:CargoTables; added Cargo actions to Special:RecentChanges; fixed Cargo query parsing in special pages (like Page Forms' Special:RunQuery); other fixes
• 3.4.1 - 2023-02-16 - Fixes for PHP 8 handling; fix for display of file redirects; other bug fixes and code improvements
• 3.4.2 - 2023-04-03 - Improved support for MW 1.37+; improved escaping of query results; added $wgCargoIgnoreBacklinks setting; fixed backlinks handling in read-only mode; other fixes
• 3.4.3 - 2023-07-19 - "feed" format added; "Columns" column added to Special:CargoTables; added support for PhpSpreadsheet library for "excel" format; default downloadable for "excel" format changed from "results.xls" to "results.xlsx"; fixed recreating Cargo tables with more than 500 rows for MW 1.39+; fixed MySQL search handling for MW 1.41+; changed backlink updates to use LinksUpdate, making them more reliable; fixed handling of different "join on" orders in queries with more than two tables; updated hook handling; disallowed single and double quotes in table and field names; added data (re)population when a template is modified/added via Page Exchange; other bug fixes
• 3.4.4 - 2023-12-11 - Added handling of "lat", "lon" and "URL" aliases for map formats; added handling of "id" alias for "feed" format; got "feed" format working with MW 1.35; improved "calendar" format header layout; improved support for MW 1.39+; other fixes

• 3.5 - 2024-02-28 - Removed support for MW 1.35 and 1.36; improved support for MW 1.40+ and PHP 8; added Lua functions for #cargo_store and #cargo_declare; improved query validation; other improvements
• 3.5.1 - 2024-03-13 - Added ratelimit support to Special:CargoQuery and Cargo querying API; fixes for date handling in Special:Drilldown with PostgreSQL; removed backlinks querying when querying helper tables or doing aggregating queries; added parsing of description field in "feed" format; removed some unused JS global variables