FireDAC Components for Act-On

Build 20.0.7654

ScoreDetails

Query the score details of a contact.

View Specific Information

To query data from this view, you must specify ContactId.
The component will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

  • ContactId supports the '=' and 'IN' operators.

For example, the following queries are processed server side:

SELECT * FROM ScoreDetails WHERE ContactId = 'l-0004:2'
SELECT * FROM ScoreDetails WHERE ContactId IN ('l-0004:2', 'l-0004:3')
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.

Columns

Name Type Description
ContactId [KEY] String Unique identifier of the contact.
ActivityId String Unique identifier of the activity.
Action String Brief description of the action.
IdType String Type of the activity.
Profile Boolean Whether or not the user has a profile.
Score Integer Score of the activity.
Specific Boolean Whether or not the activity is specific.
Ago Integer Days ago that activity happened.
InScoreRange Boolean Whether or not the activity is in score range.
What String Object of the activity.
When Datetime When the activity happened.
Bin String Subject of the activity.
Verb String Description of the activity.

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