JDBC Driver for SuiteCRM

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462