LocationCriterion
Represents data that encapsulates a location criterion.
Table Specific Information
Select
There is only one way you can query Location Criterions. The LocationName column is required and should be always specified!
The following query returns all location criterions that fulfill the condition.\
SELECT * FROM [LocationCriterion] WHERE LocationName='Ontario'
Columns
Name | Type | Behavior | DisplayName | Description |
CriterionId | String | ID of this criterion. | ||
CriterionType | String | Indicates that this instance is a subtype of Criterion. | ||
DisplayType | String | Display type of the location criterion. | ||
TargetingStatus | String | The targeting status of the location criterion. | ||
CanonicalName | String | Canonical name of the location criterion. | ||
Reach | Long | Approximate user population that will be targeted, rounded to the nearest 100. | ||
SearchTerm | String | Original search term, as specified in the input request for search by name. | ||
CountryCode | String | This is used as a hint and suggestions are restricted to this country when applicable. | ||
Locale | String | Preferred locale to be used as a hint for determining the list of locations to return. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
LocationName | String | Name of the location criterion. |
Last updated