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

**URL:** <https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141>\
**Category:** API\
**Tags:** sql-query\
**Created:** [February 6, 2024, 6:01am UTC](https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141 "2024-02-06T06:01:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Axel](https://forum.seatable.com/user_avatar/forum.seatable.com/axel/32/3514_2.png) [@Axel](https://forum.seatable.com/u/Axel)\
**Post date:** [February 6, 2024, 6:01am UTC](https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141/1 "2024-02-06T06:01:09Z")

</div>

Hello!

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.

 ![2024-02-06_14-45](https://forum.seatable.io/uploads/default/original/2X/b/b8ab68bca4290656616382a7d30c086fc2de10e5.png)

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.  
 ![2024-02-06_14-46](https://forum.seatable.io/uploads/default/original/2X/c/c5840f7d266501dbf15f3eb6991f0b467d9408bd.png)

Any help on how to achieve the expected result ?

---

<div class="post-metadata">

**Author:** ![daniel.pan](https://forum.seatable.com/user_avatar/forum.seatable.com/daniel.pan/32/13_2.png) [@daniel.pan](https://forum.seatable.com/u/daniel.pan)\
**Post date:** [February 6, 2024, 8:12am UTC](https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141/2 "2024-02-06T08:12:53Z")

</div>

Please check the document on “Extended List Operators”: [SQL Reference - SeaTable Developer Manual](https://developer.seatable.io/scripts/sql/reference/#extended-list-operators)

---

<div class="post-metadata">

**Author:** ![Axel](https://forum.seatable.com/user_avatar/forum.seatable.com/axel/32/3514_2.png) [@Axel](https://forum.seatable.com/u/Axel)\
**Post date:** [February 6, 2024, 8:24am UTC](https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141/3 "2024-02-06T08:24:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [February 8, 2024, 8:25am UTC](https://forum.seatable.com/t/api-sql-query-with-link-to-other-records-fields/3141/4 "2024-02-08T08:25:12Z")

</div>

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