NewsFeedItem Table (506)
Contains news feed items - published to one or more users, with one or more language descriptionsFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| newsfeeditem_id | Primary key | PK | No |
| Title | Short, descriptive headline. Plain text title. Multi-language string supported: ‘US:“english”;NO:“norsk”’. | String(1000) | No |
| Summary | Short, descriptive summary. Plain text summary. Multi-language string supported: ‘US:“english”;NO:“norsk”’. | String(4000) | No |
| ImageLink | URL Link to an image associated with the news item. | String(2000) | No |
| SourceLink | URL Link to the source of the news item, or an SOProtocol link to a SuperOffice item | String(2000) | No |
| PreviewHint | Preview hint for the news item. e.g. {contact_id=123} | String(100) | No |
| FromName | Name of the instance that published this item. e.g. Pete the prospector | String(200) | No |
| FromCategoryName | Type of the instance that published this item. e.g. Prospector Agent | String(200) | No |
| Priority | Importance of the news item. Low to High. Higher priority items may be shown more prominently in the feed. | Enum EMailPriority | No |
| ExpiresAt | When the news item expires and should no longer be shown in feeds (UTC) | UtcDateTime | Yes |
| Status | Indicates if the item is being handled by a CTA. (normal, processing, processed) | Enum NewsFeedItemStatus | No |
| contact_id | Related contact id - 0 if not related to a contact | FK contact | No |
| person_id | Related person id - 0 if not related to a person | FK person | No |
| project_id | Related project id - 0 if not related to a project | FK project | No |
| sale_id | Related sale id - 0 if not related to a sale | FK sale | No |
| ApplicationId | The id of the application that registered this news item. Used to resolve where any CTA should be posted when clicked. | String(100) | No |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
| Location | Place related to news item (city or city + country) (optional) | String(200) | No |
| RatingPercent | Rating as percentage (0-100). 0 = undefined. 1-9 = No stars, 10-30 = One star, Two stars = 31-50, 90-100 = Five stars. Client can render rating as stars, pie chart, thumbs up or down, however they want. Default 0 indicates no rating. | Int | No |
Indexes
| Fields | Types | Description |
|---|---|---|
| ExpiresAt | UtcDateTime | Index |
| contact_id | FK | Index |
| person_id | FK | Index |
| project_id | FK | Index |
| sale_id | FK | Index |
| registered | UtcDateTime | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| contact | Companies and Organizations. |
| NewsFeedItemCta | List of Calls-to-Action buttons to attach to a given news item. One item may have multiple CTAs (e.g. Approve + Reject). |
| NewsFeedItemHtml | Detailed description of the news item, in a specific language. |
| NewsFeedItemRecipient | Recipients of the news feed item. One news feed item may be sent to multiple recipients (users). |
| person | Persons |
| project | Projects |
| sale | Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels. |
Replication Flags
- None
Security Flags
- No access control via user’s Role.