how to select with condition?

[imknight]

Hi looking for some help on how to query the API

• how do I query with API for SQL "Select * from projects where user_id in ( select * from users )"
• how do I query with the relation key? I manage to have /rest/v1/projects?select=*,development(name) to get all projects with development, how can I match it with development name?

[steve-chavez]

Hey @imknight,

how do I query with API for SQL "Select * from projects where user_id in ( select * from users )"

You'll need to create a view for this case, see Custom Queries.

how do I query with the relation key? I manage to have /rest/v1/projects?select=*,development(name) to get all projects with development, how can I match it with development name?

Check Embedded filters.

[imknight]

thanks! really appreciate it.