How do I create a postgresSQL query searching for a UUID

Hi,

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

@Buzz
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 {{yourtablecomponentname.data}} where id = {{id.value}}
1 Like