Table: trello_my_notification - Query Trello Notifications using SQL

Trello Notifications are a feature within the Trello platform that provides updates to users about activities related to their boards, cards, and other Trello entities. These notifications can be triggered by various actions such as card movements, comments, due dates, and more. Notifications play a critical role in keeping users informed about the status and updates of their tasks and projects in Trello.

Table Usage Guide

The trello_my_notification table provides insights into Trello Notifications within the Trello platform. As a project manager or team member, explore notification-specific details through this table, including the type of notification, date it was created, member who created it, and associated data. Utilize it to track activities, stay updated on project progress, and manage your tasks more effectively.

Examples

Basic info

Discover the segments that contain unread notifications and their associated dates and types in your Trello account. This can help you pinpoint specific areas that require your attention, enabling you to manage your workload more effectively.

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification;

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification;

List all unread notifications

Discover the segments that contain all your unread notifications. This can help you manage your workload by focusing on the tasks that require your immediate attention.

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  unread;

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  unread = 1;

List all notifications created by a particular member

Determine the notifications initiated by a specific member. This can help understand the member's activity and engagement level on the platform.

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  id_member_creator = '34458739284892367890';

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  id_member_creator = '34458739284892367890';

List all notifications from last week

Discover the segments that have received notifications in the past week. This can help you keep track of recent activities and understand the areas where action might be needed.

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  date > now() - interval '1 week';

select
  id,
  date,
  unread,
  type,
  data,
  id_member_creator
from
  trello_my_notification
where
  date > datetime('now', '-7 day');

Schema for trello_my_notification

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
data	jsonb		Additional data related to the notification, which varies depending on the notification type.
date	timestamp with time zone		The timestamp of when the notification was created.
date_read	timestamp with time zone		The timestamp of when the notification was read.
id	text		The unique identifier for notification.
id_action	text		The id of the action of the notification.
id_member_creator	text		The id of the member who created the notification.
member_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the member.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the notification.
type	text		The type of notification.
unread	boolean		Indicates whether the notification is unread.

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_my_notification