Bug: List filtered rows of a view

[Bela]

I am using your “Try it” API on api.seatable.com with the endpoint “list rows” for a certain view of a table in my cloud seatable account base.

There is a strange bug where I get false responses when certain filters are selected on the view.

For example if I have a “link to other table column” with multiple entries allowed and I successfully filter for a string value that is not part of the first entry of this link column my response is suddenly:

{
“rows”: [ ]
}

If I filter for a string value that is part of the first entry of this link column everything works fine.

If I filter for a string value that is part of a lookup to linked column I get a response of 500 internal server error.

This is the table:

This is the filter leading to a 500 error

This is the filter that leads to empty rows being returned

This is a filter that works fine because it points to the first entries in the link column and not the second

These are the settings of the link to other table column “Abrechnungsvorgänge” (the column name of that table is of type function and concatenates multiple strings)

These are the settings of the column “Aktueller Abrechnungsstand”

outputs of Try it API (same output when i use VScode and terminal)

[sha]

@Bela

This is the filter leading to a 500 error

Hmm, this should not happen. Please share the columns/schema of the table “Leistungsstatus”, since it seems like it is also linked to the first table. This will help in reproducing the bug.

And is this occurring on cloud.seatable.io? (which is currently on v6.1.8)
Or does this occur when using a self-hosted instance?

---

@Bela

This is the filter that leads to empty rows being returned

This is a filter that works fine because it points to the first entries in the link column and not the second

If you hover over the little warning triangle right next to the filter definition, you’ll see the following notice:

If there are multiple items in the cell, a random one will be chosen and be compared with the filter value.

So there’s no guarantee that the filter will iterate over all linked entries and try to compare their values with the given value to be searched.

[Bela]

Hi sha.

Thanks for your response!

Yes it is the cloud.seatable.io that I used two days ago.

This is the table Leistungsstatus:

This is the table Abrechnungsvorgänge:

“Name” is just a concatenation formula. “Positionen” is a link to the Table where the bug occured.

This is the table “Abrechnungspositionen” where the error occurred

The API errors occurs regardless of whether I make a request to the default view or a different view.

I noticed the warning triangle, when filtering for strings in a link column. I just wanted to share with you my experiments while studying this bug. And for some reason filtering for a string that is part of the second link leads to an empty array of rows being returned, while filtering for a string that is part of the first link doesn’t. Its just what I noticed.

I hope this will help you in reconstructing the bug. Good luck with it. And thanks for taking care!

[sha]

Thank you very much for the additional details!

I was able to reproduce this bug and already created a bug report in our internal bug tracking system. Unfortunately, there seems to be an issue when using the enthält einen von (has any of) filter modifier on a link-formula column.

Unfortunately, this bug is also present in version 6.2.12 of SeaTable which will be deployed on cloud.seatable.io tomorrow.

As a workaround, you can use the SQL query endpoint with the following query:

SELECT * FROM `Abrechnungspositionen` WHERE `Aktueller Abrechnungsstand` HAS ANY OF ("Sponsor_Zahlung")

This should result in the expected output.

Sorry for the inconvience!