How do I create a postgresSQL query searching for a UUID


My id column is a uuid, I can't work out how I can query against the id field.

1 Like

Are you querying the database directly or a table with data from a query?

  1. Direct: select * from yourschema.yourtablename where uuid = {{id.value}}
  2. Query on a table component use Query JSON with SQL
    select * from {{}} where id = {{id.value}}
1 Like

use ::uuid cast format