Interact | profile | Audience Levels | [AudienceLevelName] | Offers by Raw SQL
This set of configuration properties enables you to define the table names required for additional Unica Interact features. You are only required to define the table name if you are using the associated feature.
enableOffersByRawSQL
- Description
-
If set to True, Unica 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, Unica 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
name
- Configuration category
- Interact | profile | Audience Levels | [AudienceLevelName] | Offers by Raw SQL | (SQL Templates)
- Description
The name you want to assign to this SQL query template. Enter a descriptive name that will be meaningful when you use this SQL template in API calls. Note that if you use a name here that is identical to a name defined in the Interact List process box for an offerBySQL treatment, the SQL in the process box will be used rather than the SQL you enter here.
- Default value
None
SQL
- Configuration category
- Interact | profile | Audience Levels | [AudienceLevelName] | Offers by Raw SQL | (SQL Templates)
- Description
Contains the SQL query to be called by this template. The SQL query may contain references to variable names that are part of the visitor's session data (profile). For example,
select * from MyOffers where category = ${preferredCategory}would rely on the session containing a variable namedpreferredCategory.You should configure the SQL to query the specific offer tables you created during design time for use by this feature. Note that stored procedures are not supported here.
- Default value
None