steampipe plugin install trellosteampipe plugin install trello

trello_board trello_card trello_list trello_member trello_my_board trello_my_member trello_my_notification trello_my_organization trello_organization trello_search_board trello_search_card trello_token trello_webhook

Table: trello_search_card - Query Trello Cards using SQL

Trello is a web-based, Kanban-style, list-making application, and a subsidiary of Atlassian. Users can create their task boards with several columns and move the tasks between them. Typically columns include task statuses: To Do, In Progress, Done. The tool can be used for personal and business purposes including real estate management, software project management, school bulletin boards, lesson planning, and law office case management.

Table Usage Guide

The trello_search_card table provides insights into Trello Cards within the Trello platform. As a project manager or team member, explore card-specific details through this table, including card names, descriptions, due dates, and associated lists. Utilize it to uncover information about cards, such as their current list, members assigned, and the status of their completion.

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

Get all cards assigned to a specific member

Identify all task cards assigned to a specific team member. This is useful for tracking individual workloads and progress in project management scenarios.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = '@username';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = '@username';

Get cards without any members assigned

Identify instances where task cards have no members assigned. This could be useful to pinpoint areas that may need additional resources or oversight in a project management context.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = '-has:members';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = '-has:members';

Get all cards from a specific board

Determine the areas in which specific board cards are used, including their status and due dates. This is useful for tracking task progress and managing project timelines effectively.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'board:123ace54605094aa59b02c4b';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'board:123ace54605094aa59b02c4b';

Get all cards created within a month

Discover the segments that have been recently added within the past month. This can be useful to track the progress of tasks or projects in real-time and maintain an updated workflow.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'created:month';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'created:month';

Get all cards created within 14 days

Explore which tasks have been initiated within the last two weeks. This is useful for keeping track of recent project developments and understanding current workload.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'created:14';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'created:14';

Get all cards due within a week

Discover the tasks that are due within the upcoming week. This can help you prioritize your work and manage your time effectively.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:week';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:week';

Get all cards due within a day

Discover the segments that have tasks due within a day. This is beneficial for managing time-sensitive projects and ensuring all tasks are completed on schedule.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:day';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:day';

Get all cards with attachments

Discover the segments that have attachments within a project management tool. This is particularly useful for identifying tasks that contain additional information or resources, aiding in effective project tracking and management.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'has:attachments';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'has:attachments';

Get all cards with a specific label

Discover the segments that include all cards marked with a specific label. This allows for a focused overview of tasks that are blocked, facilitating effective project management and troubleshooting.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'label:Blocked';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'label:Blocked';

Get all cards with a specific label color

Explore which tasks have been tagged with a specific label color in a project management tool. This can help in quickly identifying and categorizing tasks based on their labels, enhancing project organization and management.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'label:blue';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'label:blue';

Get all cards from a specific list in a board

Explore which tasks are currently listed under the 'To Do' category for a specific project board. This is useful for project management, allowing you to quickly assess the status and details of all pending tasks in one place.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'list:"To Do" board:123ace54605094aa59b02c4b';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'list:"To Do" board:123ace54605094aa59b02c4b';

Get all cards that are overdue

Discover the segments that have overdue tasks in Trello. This query is useful in identifying and managing tasks that have passed their due date, assisting in project management and task prioritization.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:overdue';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:overdue';

Get all cards that are overdue and no members assigned

Explore which tasks are overdue and currently unassigned, to efficiently allocate resources and prioritize workload. This can help in identifying bottlenecks and improving project management.

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:overdue -has:members';

select
  id,
  name,
  description,
  id_board,
  id_list,
  start,
  due,
  closed
from
  trello_search_card
where
  query = 'due:overdue -has:members';

Schema for trello_search_card

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
attachments	jsonb		The attachments of the card.
badges	jsonb		The badges of the card.
check_item_states	jsonb		The check item states of the card.
checklists	jsonb		The checklists of the card.
closed	boolean		Indicates whether the card is closed.
custom_field_items	jsonb		The custom field items of the card.
custom_field_map	jsonb		The custom field map of the card.
date_last_activity	timestamp with time zone		The timestamp of the last activity on the card.
description	text		The description or summary of the card.
due	timestamp with time zone		The due date of the card, if set.
due_complete	boolean		Indicates whether the due date of the card is complete.
email	text		The email id associated with the card.
id	text		The unique identifier for the card.
id_attachment_cover	text		The id of the attachment used as the card cover.
id_board	text		The id of the board the card belongs to.
id_check_lists	jsonb		The ids of checklists attached to the card.
id_labels	jsonb		The ids of labels attached to the card.
id_list	text		The id of the list the card belongs to.
id_members	jsonb		The ids of members attached to the card.
id_members_voted	jsonb		The ids of members who voted on the card.
id_short	text		The short id of the card.
labels	jsonb		The labels of the card.
manual_cover_attachment	boolean		The manual cover attachment of the card.
name	text		The name of the card.
pos	bigint		The position of the card.
query	text	=	The query provided for the search.
short_link	text		The shortened link of the card.
short_url	text		The shortened URL of the card.
start	timestamp with time zone		The start time of the card.
subscribed	boolean		Indicates whether the card has been subscribed.
title	text		The title of the card.
url	text		The URL of the card.

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_card