FireDAC Components for Salesforce Chatter

Build 21.0.7930

Topics

Retrieve Topics on SalesforceChatter.

Table Specific Information

Select

The component will use the Salesforce Chatter API to process filters based on the following columns: CommunityId, GroupId, UserId, Id (the primary key), or a combination of two Ids. Allowed operators are = and AND.

Filters on other columns are executed client side within the component. For example, the following query is executed to the Salesforce Chatter APIs:

SELECT * FROM Topics WHERE GroupId = 'abc123'

You can also use the Salesforce Chatter APIs to sort through a list of topics by Name or Popularity.

SELECT Name FROM Topics ORDER BY Name

SELECT Name FROM Topics ORDER BY Popular DESC
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria on other columns will cause an error.

Columns

Name Type Description
Id [KEY] String The unique identifier of the topic.
Name String The name of the topic.
SearchTerms String Query to search the files database.
CreatedDate Datetime The date and time when the topic was created.
Description String Description of the topic.
ImagesAggregate String Images associated with the topic.
IsBeingDeleted Boolean Whether the topic is being deleted.
NonLocalizedName String Non-localized name of the topic.
TalkingAbout Integer The number of people talking about this topic over the last two months.
Url String The URL to the topic detail page.

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
IsMe Boolean Instead of specifying your exact Id, set this to true to retrieve your account information
GroupId String Id of the group associated with the current topic.
UserId String Id of the user associated with the current topic.
CommunityId String Id of the community associated with the current topic.
ExactMatch Boolean Use with the q (SearchTerms) parameter and specify true to find a topic by its exact, case-insensitive name. Specify true and use with the q (SearchTerms) parameter and the fallBackToRenamedTopics parameter set to true to find the most recent renamed topic match if there isn't an exact match. Default value is false.
RenamedTopics Boolean Use with the q (SearchTerms) parameter and the exactMatch parameter set to true. If an exact match is not found and fallBackToRenamedTopics is set to true, the most recent renamed topic match is returned. If there are multiple renamed topic matches, only the most recent is returned. If there are no renamed topic matches, an empty collection is returned.

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