Filters on non meta columns don't work in views

[henryherkula]

Steps to reproduce

1. Create new to-do list table
2. Filter on progress (is working)
3. Create view from filter
4. Filtered view is empty

Expected behavior

Rows should be filtered by the filter settings in the view.

Actual behavior

No rows are shown.

Tables app version

0.6.3

Browser

Firefox 119.0.1

Client operating system

Windows 10

Operating system

FreeBSD 13.1-RELEASE-p7 amd64

Web server

Nginx

PHP engine version

PHP 8.2

Database

MySQL

Additional info

• no errors in the console

[datenangebot]

Do you use the template to create the table? If I follow your steps to reproduce, it works for me.

[henryherkula]

Yes, I did use the template. I am not sure why it is not working. Filters on the meta columns are working as intended. :/

[tbousiou]

It's not working for me either. None of the views filters is working.

[datenangebot]

Okay, interesting 😬

What about the logs. Is there anything from tables in the nextcloud log or in the browser console?

[henryherkula]

Nope, nothing in the console and nothing in the log. The meta filters like ID or creation date are working fine. Maybe it is a conflict with a library or a the specific PHP version. I am not sure. :/ Still a problem in 0.6.4

[tbousiou]

I noticed that the bug appears on two servers i use that both have mysql as a database server. On my local install where i use mariadb the bug does not appear.

I just confirmed this by installing two clean installations of nextcloud one with mysql and the other with mariadb all with latest versions. Mysql has the bug, mariadb works fine.

[henryherkula]

Could reproduce, mariadb works, mysql is not working. Installed mariadb as a fix for myself.

[tbousiou]

Could reproduce, mariadb works, mysql is not working. Installed mariadb as a fix for myself.

If this is the case then it's a strange bug, as far as I know apps in nextcloud are database agnostic.

I want to add that the sorting filters don't work as well.

[koebi80]

Same problem on two installtions. MySQL is used.

Filter on base table column work:

Same filter in view edit doesen't work: I have noticed that after selecting a line in the dropdown, the cursor jumps a few spaces backwards in the text line.

[xbluemonkx]

HI, for me SORTING on meta columns does not work. In my case I want to sort by last edited, but it does not do it. - I think this is the same issue as in this ticket, therefore i did not create a new ticket.