API - SQL query with “Link to other records” fields


I am trying to use the POST operations called List Rows (with SQL)
I have a table with “Link to other records” fields as you can see in the screenshot.

I am trying to retrieve the all dates from theis table where the proposal is {{proposal name}}.
I tried the following sql query:

“SELECT Date FROM Assigned Days WHERE Proposal = LAGALAYE yann 202408061

It does not work because I can see that proposal is actually an array.

Any help on how to achieve the expected result ?

Please check the document on “Extended List Operators”: SQL Reference - SeaTable Developer Manual

1 Like

Thank you @daniel.pan I should have read more in depth!

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.