Interact | profile | Audience Levels | [AudienceLevelName] | Offers by Raw SQL
This set of configuration properties enables you to define the table names required for additional
Interact
features. You are only required to define the table name if you are using the associated feature.
enableOffersByRawSQL
Description
If set to
True
,
Interact
enables the offersBySQL feature for this audience level that allows you to configure SQL code to be executed to create a desired set of candidate offers at runtime.. If
False
,
Interact
does not use the offersBySQL feature.
If you set this property to true, you may also configure the
Interact | profile | Audience Levels | (Audience Level) | Offers by Raw SQL | SQL Template
property to define one or more SQL templates.
Default value
False
Valid Values
True | False
cacheSize
Description
Size of cache used to store results of the OfferBySQL queries. Note that using a cache may have negative impact if query results are unique for most sessions.
Default value
-1 (off)
Valid Values
-1 | Value
cacheLifeInMinutes
Description
If the cache is enabled, this indicates the number of minutes before the system will clear the cache to avoid staleness.
Default value
-1 (off)
Valid Values
-1 | Value
defaultSQLTemplate
Description
The name of the SQL template to use if one is not specified via the API calls.
Default value
None
Valid Values
SQL template name
Interact | profile | Audience Levels | [AudienceLevelName] | SQL Template
Copyright IBM Corporation 2014. All Rights Reserved.