Table: trello_search_board - Query Trello Boards using SQL

Trello is a web-based, Kanban-style, list-making application. It's a subsidiary of Atlassian, used for project management and task organization. Trello Boards are the primary components of the Trello system where cards (tasks) are created, organized, and managed.

Table Usage Guide

The trello_search_board table provides insights into Trello Boards that match a specific search query. As a project manager or team lead, explore board-specific details through this table, including board names, descriptions, and associated metadata. Utilize it to uncover information about boards, such as those related to specific projects, teams, or tasks, thereby facilitating efficient board management and task organization.

Important Notes

You must always include at least one search term in the where or join clause using the query column. You can narrow the results using the search qualifiers in any combination. See Trello search for details on the Trello query syntax.

Examples

List all boards with the word "test" in the name

Discover the segments that include the term "test" in their names, allowing for targeted analysis or management of these specific areas within your organization. This is useful for quickly identifying and focusing on testing-related tasks or projects.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'name:test';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'name:test';

List all boards that are starred

Explore which of your Trello boards have been marked as important by using the 'starred' feature. This helps prioritize tasks and focus on key projects.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'is:starred';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'is:starred';

List all boards that are closed

Discover the segments that include all boards which are no longer active. This could be beneficial for understanding the lifecycle of boards and identifying patterns or reasons for closure.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = '-is:open';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = '-is:open';

List all boards that are open and have the word "test" in the name

Discover the open boards that include 'test' in their name, useful for identifying specific project or task boards in a larger Trello organization.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'is:open name:test';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_search_board
where
  query = 'is:open name:test';

Schema for trello_search_board

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
closed	boolean		Indicates whether the board is closed.
custom_fields	jsonb		The custom fields associated to the board.
description	text		A description or summary of the board.
id	text		The unique identifier for the board.
id_organization	text		The id of the organization associated with the board.
label_names	jsonb		The label names of the board.
member_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the member.
name	text		The name of the board.
pinned	boolean		Indicates whether the board is pinned.
prefs	jsonb		The preferences of the board.
query	text	=	The query provided for the search.
short_url	text		The shortened URL of the board.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
starred	boolean		Indicates whether the board is starred.
subscribed	boolean		Indicates whether the board has been subscribed.
title	text		The title of the board.
url	text		The URL of the board.

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_search_board