Clickable URLs in Tables

You can use this template to create clickable links in your table:

SELECT '' || id  || '/source' AS url, name, created_at
FROM queries
WHERE is_archived = false
AND name != 'New Query'

Please note that || is a PostgreSQL operator/function - for other databases, you'll need to use the suitable concat operator.

The results will be clickable links, like in this query in our demo account:

You can also use the anchor tag to show a name instead of the URL:

SELECT '<a href="' || id || '">' || name || '</a>' as name

Still need help? Contact Us Contact Us