CountriesProvincesNames
The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
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 languageId = 12 SELECT * FROM CountriesProvinces WHERE languageId > 15 SELECT * FROM CountriesProvinces WHERE labelText LIKE '%test' SELECT * FROM CountriesProvinces WHERE languageId IN (12, 23, 123) SELECT * FROM CountriesProvinces WHERE labelText IS NOT NULL
Columns
| Name | Type | Description |
| CountriesId | Long | The unique identifier of the country. |
| ProvincesId | Long | The unique identifier of the province. |
| LabelText | String | The language-specific label text. The value cannot be null or empty. |
| LanguageId | Long | Id of language. The ID of the language. This is the key for the list entry. |
| LanguagelookUpName | String | LookUpName of language. The ID of the language. This is the key for the list entry. |