Power BI Connector for Salesforce Chatter

Build 20.0.7587

FeedElements

Search all feed elements in an organization.

Table Specific Information

Select

You must specify the SearchTerms to query this table. The = operator is allowed.

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

SELECT * FROM FeedElements WHERE SearchTerms = 'abc123'
SELECT * FROM FeedElements WHERE SearchTerms = 'abc123' AND CommunityId='12345'

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 user.
ActorAdditionalLabel String Actor additional label.
ActorCommunityNickname String Actor community nickname.
ActorCompanyName String Actor company name.
ActorDisplayName String Actor display name.
ActorFirstName String Actor first name.
ActorId String Actor id.
ActorName String Actor name.
ActorLastName String Actor last name.
ActorIsActive Boolean Whether actor is active or not.
ActorIsInThisCommunity Boolean Whether actor is in this company or not.
ActorMySubscription String Actor subscription.
ActorMyReputation String Actor reputation.
ActorMyTitle String Actor title.
ActorMyType String Actor type.
ActorURL String Actor URL.
ActorUserType String Actor user type.
ActorMotifColor String Actor motif color.
ActorMotifAggregate String Actor motif large icon URL.
ActorPhotoAggregate String Actor phot url.
BodyMessageSegmentsAggregate String Body message segments.
BodyIsRichText Boolean Whether is rich text or not.
BodyText String Body text.
CanShare String Whether it is possible to share or not.
ClientInfo Boolean Client info.
CreatedDate Datetime Created date.
ModifiedDate Datetime Modified date.
Event Boolean Event.
FeedElementType String Feed element type.
HeaderAggregate String Header.
IsDeleteRestricted Boolean Whether delete is restricted or not.
OriginalFeedItem String Original feed item.
OriginalFeedItemActor String Original feed item actor.
CapabilitiesAggregate String Capabilities.
ParentAggregate String Parent.
PhotoUrl String Photo of the URL.
RelativeCreatedDate String Relative created date.
Type String Type.
Url String URL.
Visibility String Visibility.
CommunityId String Id of the community.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SearchTerms String Query to search the files database.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587