...
The convention for storing the primary key in a database custom field is to mark the primary key field in the query using "as pk".
Let's use a nested select in a dynamic query for an example:
| Code Block | ||
|---|---|---|
| ||
SELECT id, fk_id, col1 FROM testTable1 WHERE fk_id = (select id from testTable2 where col = {customfield_10000}); |