Allow displaying publish status in aggregations of page data

Multiple fixes for PHP 8 (#600)

Manual code style adjustments

PHP code sniffer autofixes

Fix PHP code style

Add option to remove single columns from wildcard (#533)

Fix bug in struct filter variable evaluation

When a search contains a struct variable expression for filtering and
the variable references a schema that is not assigned to the current
search but has

Fix bug in struct filter variable evaluation

When a search contains a struct variable expression for filtering and
the variable references a schema that is not assigned to the current
search but has a column with the same name like one from the assigned
schemas, the evaluation of the variable doesn't return the correct
value.

This patch fixes the bug by ensuring that findColumn() returns false
in case the requested schema wasn't found within the assigned schemas.

To make sure the behavior of other callers of findColumn() remains the
same, we introduce a parameter 'strict' to trigger this new behavior
in applyFilterVarsStruct().

There is also a unit test added in a separate commit that explicitely
checks this case.

Signed-off-by: Frieder Schrempf <dev@fris.de>

show more ...

Eliminate warnings in PHP 8

added spaces around the IN operator

Add forgotten grouping column to search queries

This should have been done long ago when rid was introduced

Adjust page assignment checks to not exclude serial data from aggregations

For some reason the search query with clause 'assigned !=0' did not return rows where assigned is NULL. This should work ac

Adjust page assignment checks to not exclude serial data from aggregations

For some reason the search query with clause 'assigned !=0' did not return rows where assigned is NULL. This should work according to specs and does work as expected in standalone queries. Fixed by using an explicit IS NULL check.

show more ...

Remove islookup property of schemas

CSV import must still be adjusted

Fix schema assignment check in aggregations

Fix code standard violation

Restructure search query

Move schema assignment clauses into an ever-present JOIN, conditional on pid. Also remove the $idColumn parameter, previously used to check if schema assignment clauses shou

Restructure search query

Move schema assignment clauses into an ever-present JOIN, conditional on pid. Also remove the $idColumn parameter, previously used to check if schema assignment clauses should be added to queries.

show more ...

More flexible page access check in search queries

Add page access clauses in a subquery, conditional on non-empty page id

Manual coding style fixes

Method and variable visibility, camel case method names. Some exclusions due to inheritance

Automatic coding style fixes

Access Dokuwiki's refactored lexer

Lexer changed significantly between current stable Greebo and master. Now we can use both versions.

Make more SQL queries contingent on the join column ($idColumn)

Fix data access for lookup types

Fix multi columns

Use the correct column for joining tables depending on data type. This is an initial "it works" implementation and should be revised and done more carefully.

Merge branch 'master' into serial

Merge pull request #414 from solewniczak/feature-in-operator-in-filters

IN operator in struct filter

Inline editors are mostly adapted to new data access