JDBC Driver for Gmail

Build 21.0.8137

Filters

Query Filters in Gmail.

テーブル固有の情報

利用可能なFilters をクエリします。

Select

ドライバーはGmail REST API を使用して、Id カラムを参照する検索条件を処理します。ドライバーは他のフィルタを、ドライバー内のクライアントサイドで処理します。

  • Id '=' 演算子をサポート。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM Filters WHERE ID = 123

Columns

Name Type References Description
Id [KEY] String The server assigned ID of the filter.
AddLabelIds String List of labels to add to the message.
RemoveLabelIds String List of labels to remove from the message.
Forward String Email address that the message should be forwarded to.
From String The sender's display name or email address.
To String The recipient's display name or email address. Includes recipients in the
Subject String Case-insensitive phrase found in the message's subject.
Query String Only return messages matching the specified query. Supports the same query format as the Gmail search box.
NegatedQuery String The primary email address of the user. Writeable on create only. On update, a secondary email is added.
HasAttachment Boolean Whether the message has any attachment.
ExcludedChats Boolean Whether the response should exclude chats.
Size Integer The size of the entire RFC822 message in bytes, including all headers and attachments.
SizeComparison String How the message size in bytes should be in relation to the size field.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137