Filter: better handling of column names and labels

New syntax component "filter"

correctly nest items with the same values with different parents

code sniffer fixes

do not sort lists alphabetically

Now nested lists reflect the result set order again. The only exception
being the index level which is always sorted alphabetically. N/A entries
are still always las

do not sort lists alphabetically

Now nested lists reflect the result set order again. The only exception
being the index level which is always sorted alphabetically. N/A entries
are still always last.

show more ...

make empty values easier to see in list dump method

Provide mechanism for disabling default select filter 'latest = 1'

lists: correctly handle nesting with empty values

empty values are shown as n/a when they are used in nesting, otherwise
not shown just as before

index based on display not compare value

added classes config parameter

This allows users to set custom CSS classes on aggregations potentially
restyling them differently for different use cases.

This makes startScope and finishScope part

added classes config parameter

This allows users to set custom CSS classes on aggregations potentially
restyling them differently for different use cases.

This makes startScope and finishScope part of the public API of the
Aggregation class. It should no longer be called within render() but is
instead called outside.

This might potentially break plugins implementing their own
aggregations. Needs to be checked

show more ...

fixed tests and codesniffer complaints

Add indexing support

Using the index keyword, lists can now have an alphabetical Index at the
top level.

only have unique result rows when nesting

This fixes row duplication on nesting with multiple multival fields

some streamlining for the aggregation classes

Have an abstract base class for aggregations to ensure proper
signatures, reuse more code from the table syntax

Add nesting option for List Aggregations

This allows to create nested lists based on the selected number of
result columns. This is basically a group-by after the fact and
displaying it in a tree. M

Add nesting option for List Aggregations

This allows to create nested lists based on the selected number of
result columns. This is basically a group-by after the fact and
displaying it in a tree. Multivalues are split up for grouping, so that
a result can be nested by tags for example.

show more ...

use GROUP_CONCAT_DISTINCT

Make all tests run with the new SQLiteDB class

Use new \dokuwiki\plugin\sqlite\SQLiteDB class for DB access

code style fixes

more test and deprecation fixes

PHP8 fix in ConfigParser. replaces #628

splitLine has been adjusted to always return an array. Test added.

Add variable date filter based on strtotime

Update InlineConfigParser.php

Update AggregationValue.php

Ensure `$result` has the proper size.

Fix more PHP 8 warnings

Fixes #560 #618