FireDAC Components for Salesforce Chatter

Build 21.0.7930

Folders

Query Folders.

Table Specific Information

Select

You must specify the primary key, Id, to query this table. The = operator is allowed. The component will use the Salesforce Chatter API; to filter the results by the Id column.

Other filters are processed client side within the component. For example, the following query is processed server side:

SELECT * FROM Folders WHERE Id = 'abc123'

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refer to any other columns will cause an error.

Columns

Name Type Description
Id [KEY] String The unique identifier of the folder.
Name String The folder name.
Path String The path to the folder.
CreatedDate Datetime The date and time when the folder was created.
Type String The folder type description.
IsInMyFileSync Boolean Whether the folder is synced with Salesforce Files Sync.
ModifiedDate Datetime The date and time when the folder was last modified.
MySubscriptionId String The folder's subscription id.
MySubscriptionUrl String The folder's subscription url.
ParentFolderId String The folder's parent folder id.
ParentFolderUrl String The folder's parent folder url.
Url String The folder url.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Filter String Specifies a filter for items within a folder. The value IsInMyFileSync filters out the items that are not synced in a folder.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930