Trackers
Create, update, delete, and query the created trackers.
Table Specific Information
Select
You can query the Trackers table using any criteria in the WHERE clause. The add-in will use the SuiteCRM API to filter the results.
SELECT * FROM Trackers WHERE [Date of Last Action] <= '2015-04-01'
Insert
Create a Tracker by specifying any writable column.
INSERT INTO Trackers (Action, [Item Id], [Item Summary], Trackers) VALUES ('Detection', 'recordId3', 'Goal is to find inconsistencies', 'Leads')
Update
You can update any Tracker column that is writable, by specifying the Id.
UPDATE Trackers SET [Record Visible] = false WHERE Id = 'Test123'
Delete
Delete a Tracker by specifying the Id.
DELETE FROM Trackers WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Int | False |
The unique identifier of the tracker. |
| Action | String | False |
The type of action being tracked |
| DateofLastAction | Datetime | True |
Date when the action last took place |
| Deleted | Bool | False |
The record deletion indicator. |
| ItemId | String | True |
Id of the record being tracked |
| ItemSummary | String | True |
Name of the record being tracked |
| MonitorId | String | True |
Id of the tracker monitor |
| RecordVisible | Bool | True |
Whether the record is visible |
| SessionId | String | True |
Which session Id made the change |
| Trackers | String | False |
The module being tracked |
| UserId | String | True |
User Id that made the change |
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 |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |