Retrieve Topics on SalesforceChatter.
Table Specific Information
The driver 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 driver. 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 DESCYou can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria on other columns will cause an error.
|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 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.
|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.|