AssetStatusesNames
The language-specific strings used for localization of fields.
Table-Specific Information
SELECT
The adapter will use the 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 adapter.
SELECT * FROM AssetStatusesNames WHERE assetStatusesId = 12 SELECT * FROM AssetStatusesNames WHERE assetStatusesId > 15 SELECT * FROM AssetStatusesNames WHERE labeltext LIKE '%test' SELECT * FROM AssetStatusesNames WHERE assetStatusesId IN (12,23,123) SELECT * FROM AssetStatusesNames WHERE labeltext IS NOT NULL
Columns
| Name | Type | Description |
| AssetStatusesId | Long | The unique identifier of the asset statuses version. |
| 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. |