CountriesProvinces
The information about the provinces in the Countries/Provinces customizable menu.
Table-Specific Information
SELECT
The connector will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the connector.
SELECT * FROM CountriesProvinces WHERE id = 12 SELECT * FROM CountriesProvinces WHERE id > 15 SELECT * FROM CountriesProvinces WHERE name LIKE '%test' SELECT * FROM CountriesProvinces WHERE id IN (12, 23, 123) SELECT * FROM CountriesProvinces WHERE name IS NOT NULL
Columns
| Name | Type | Description |
| CountriesId | Long | The unique identifier of the country. |
| DisplayOrder | Int | The display position relative to other provinces associated with the same country. |
| Id [KEY] | Long | The unique identifier of the province. |
| Name | String | The name of the province in the language of the current interface. This attribute is read-only. |
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 |
| names | String | The list of names or labels for the province for each available language. |