JobNotes
Return a list of all notes of a job
Select
The adapter will process all filters client side.
Insert
JobID, Title, Text are required to insert. The following query creates a new JobNote:
INSERT INTO JobNotes (JobID, Title, Text) VALUES ('J000001', '133193699', 'some notes')
Columns
Name | Type | ReadOnly | Description |
JobID | String | False |
The ID of the job which has the note. |
UUID [KEY] | String | True |
The note identifier. |
Title | String | False |
The title of the note. |
Text | String | False |
The text of the note. |
Folder | String | False |
The folder where the note is. |
Date | Datetime | True |
The date on which the note was created. |
CreatedBy | String | True |
The name of the staff who created the note. |
Comments | String | True |
All comments in a note in xml format. |
Public | String | False |
Determines if the note is public to staff members. True | False |