AccountGroups
The language-specific strings used for localization of fields.
Table-Specific Information
SELECT
The driver 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 driver.
SELECT * FROM AccountGroups id = 12 SELECT * FROM AccountGroups id > 15 SELECT * FROM AccountGroups lookUpName LIKE '%test' SELECT * FROM AccountGroups id IN (12, 23, 123) SELECT * FROM AccountGroups lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the acceptCount,respondCount and names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO AccountGroupsNames#TEMP (languageId, labeltext) VALUES ('1', 'Smartly Maestro') INSERT INTO AccountGroups(LookupName, Name, names) VALUES ('test', 'test', AccountGroupsNames#TEMP)
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE AccountGroups SET Name = 'SV100D' WHERE Id = 12
DELETE
Following is an example of how to Delete a record in this table.
For example:
DELETE FROM AccountGroups WHERE Id = 12
Columns
Name | Type | ReadOnly | Description |
Id | Long | False |
The unique identifier of the account group . |
LookupName | String | False |
The name used to look up the account group. |
Name | Long | False |
The name of the account group in the language of the current interface. |
DisplayOrder | Long | False |
The order in which this account group is displayed relative to other members of the same group. |
UpdatedTime | String | False |
The date and time when the account group was last updated. |
CreatedTime | String | False |
The date and time when the account group was created |
AttributesCustomerCareAccess | Boolean | False |
The customer care access group. |
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 |
Descriptions | String |
The list of descriptions, one for each supported language. |
Names | String |
The list of names, one for each supported language. |