Support Topics Documentation Slack YouTube Blog

Including Relations in Where clause

I’ve no idea whether this is the right place to ask - but here goes anyway.

Is there anyway to use a ‘where clause’ that applies to a field in a related table?

For example: Table A has a column linked to Table B via a 1to1 relation.

Can I find all the items in Table A, that have a specific value in the file they are linked to in table B?

What is the syntax for that request?

Hi Oli,

Yes, it is possible. You can access properties/columns of a related table using the dot notation. For example:

relatedColumnName.columnFromRelatedTable < X

Hope this helps.

Regards,
Mark

It really does - thank you.