ServiceProductsDispositionLinks
The disposition linking for a product.
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 ServiceProductsDispositionLinks WHERE servicedispositionId = 12 SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionId > 15 SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionlookUpName LIKE '%test' SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionId IN (12, 23, 123) SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionlookUpName IS NOT NULL
Columns
| Name | Type | Description |
| ServiceProductsId | Long | Id of ServiceProducts. |
| ServiceDispositionId | Long | Id of serviceDisposition. The ID of the service disposition. This is the key for the list entry. |
| ServiceDispositionlookUpName | String | LookUpName of serviceDisposition. The ID of the service disposition. This is the key for the list entry. |