Table: trello_list - Query Trello Lists using SQL
Trello is a collaboration tool that organizes your projects into boards. A Trello board is a list of lists, filled with cards, used by you and your team. The Trello List resource in this context represents a list within a specific Trello board.
Table Usage Guide
The trello_list
table provides insights into lists within Trello boards. As a project manager or team leader, you can use this table to explore list-specific details, including card count, list status (open or closed), and associated metadata. This table is useful for tracking the progress of tasks and managing workflow across different projects or teams.
Important Notes
- You must specify the
id_board
in thewhere
or join clause (where id_board=
,join trello_board b on b.id=
) to query this table.
Examples
Basic info
Explore which Trello lists are active or closed within a specific board. This can help manage workflow and track project progress.
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b';
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b';
Get lists in a specific board which are closed
Explore which lists within a specific project board have been closed. This is particularly useful to track project progress and identify any tasks that are no longer active.
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b' and closed;
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b' and closed = 1;
Get lists in a board which have been subscribed to
Discover the segments that have been subscribed to within a specific board. This is useful in identifying the areas of interest or focus for a particular team or project.
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b' and subscribed;
select id, name, id_board, closed, posfrom trello_listwhere id_board = '12330ad5e3b81053d7d5315b' and subscribed = 1;
Get total lists in each board
Explore which boards have the most lists to better manage your project workflows and resource allocation. This can help in identifying where most activity is concentrated and aid in balancing the workload.
select id_board, count(*) as total_listsfrom trello_list l, trello_board bwhere l.id_board = b.idgroup by id_board;
select id_board, count(*) as total_listsfrom trello_list l, trello_board bwhere l.id_board = b.idgroup by id_board;
Schema for trello_list
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
closed | boolean | Indicates whether the list is closed. | |
id | text | = | The unique identifier for the list. |
id_board | text | = | The id of the board the list belongs to. |
name | text | The name of the list. | |
pos | double precision | The position of the list. | |
subscribed | boolean | Indicates whether the list has been subscribed. | |
title | text | The title of the list. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- trello
You can pass the configuration to the command with the --config
argument:
steampipe_export_trello --config '<your_config>' trello_list