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 the where 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,
  pos
from
  trello_list
where
  id_board = '12330ad5e3b81053d7d5315b';

select
  id,
  name,
  id_board,
  closed,
  pos
from
  trello_list
where
  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,
  pos
from
  trello_list
where
  id_board = '12330ad5e3b81053d7d5315b'
  and closed;

select
  id,
  name,
  id_board,
  closed,
  pos
from
  trello_list
where
  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,
  pos
from
  trello_list
where
  id_board = '12330ad5e3b81053d7d5315b'
  and subscribed;

select
  id,
  name,
  id_board,
  closed,
  pos
from
  trello_list
where
  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_lists
from
  trello_list l,
  trello_board b
where
  l.id_board = b.id
group by
  id_board;

select
  id_board,
  count(*) as total_lists
from
  trello_list l,
  trello_board b
where
  l.id_board = b.id
group by
  id_board;

Schema for trello_list

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
member_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the member.
name	text		The name of the list.
pos	double precision		The position of the list.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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