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 cmdlet 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. |