2 Questions about Table component

[HSi-corbin]

1. How can one of the fields of data returned in the Postgresql query for the table be made into a link?

2. What's the best way to make every other row a certain color?

SIDENOTE: I think adding the boolean parameter to the component for the every other color be a nice feature. Would also need to manage that when sorted on column headers.

[lovasoa]

Hello and welcome to SQLPage !

To make a field a link, use the markdown top-level parameter for the table component and format the data in the select statement as a Markdown link [Link Text](link_url).

To color every other row, use the striped_rows top-level attribute of the table component :

-- Display a table with links and alternating row colors
select 
  'table' AS component,
  'User Name' AS markdown, -- Make the 'User Name' column interpret markdown
  TRUE AS striped_rows; -- This is the simplest way to get alternating row colors
select
  -- Create a markdown link for the user's name
  '[' || name || '](user_details.sql?id=' || id || ')' AS "User Name",
  email,
  created_at
from users;

If you really need to control the precise highlight color of rows, you can

• use the special _sqlpage_color row-level parameter with a conditional expression, typically based on ROW_NUMBER(),
• write custom css

But I would recommend sticking to TRUE AS striped_rows.

See all the features of the table component here : https://sql-page.com/component.sql?component=table

[lovasoa]

[HSi-corbin]

Thank you sir. I feel silly I missed that striped_rows parameter. I read through all the parameters checking out my options but OBVIOUSLY did not comprehend well enough.

[HSi-corbin]

...and for the markdown help. I've not played with any of the markdown stuff as of yet so that didn't hit me either as an option.

I appreciate your quick response.

[HSi-corbin]

FOLLOW UP:

Wow that was so easy. Thanks again.

IS THERE A WAY to set the target="_blank" so the link opens in a new tab? I understand some Markdown engines can do it and some can't.

[lovasoa]

Hi! No, it's not possible. You can always middle click on links to open them in new tabs though

[amrutadotorg]

Hello, I was testing the TRUE AS striped_rows parameter, but it seems that it doesn’t apply row coloring when dark mode is enabled.
link