Shared view from empty table does not show for sharees

[enjeck]

Steps to reproduce

1. Create a table and add columns
2. Do not add any rows
3. Create a view from the table. While creating the view, add a new filter with setting: Creator -> Is equal -> Me (user ID)
4. Share the view

Expected behavior

The shared view is not visible in the list of views for the sharee

Actual behavior

The view should show

Tables app version

No response

Browser

No response

Client operating system

No response

Operating system

No response

Web server

None

PHP engine version

None

Database

None

Additional info

No response

[benjaminfrueh]

Hi @enjeck, I think filters on meta-columns (IDs -1 to -5) are currently causing issues.

This could be related to the change in line 316 in this recent commit: https://github.com/nextcloud/tables/pull/1866/commits/12638a8054aba27a3d8f1e0763636dd26ddc2fac#diff-4cfcdf93ee32c8ecd9188d2b8cb6e58fd1089c1dbe0d0f4c41ad324ec42e18bcR316

The function replacePlaceholderValues() now also calls $this->columnMapper->find() on the negative meta-column IDs, triggering a “did expect one result but found none” query error in my quick test, causing tables and views not to load.

[enjeck]

Hi @enjeck, I think filters on meta-columns (IDs -1 to -5) are currently causing issues.

This could be related to the change in line 316 in this recent commit: 12638a8#diff-4cfcdf93ee32c8ecd9188d2b8cb6e58fd1089c1dbe0d0f4c41ad324ec42e18bcR316

The function replacePlaceholderValues() now also calls $this->columnMapper->find() on the negative meta-column IDs, triggering a “did expect one result but found none” query error in my quick test, causing tables and views not to load.

Thanks for checking!