ToDo

Create, update, delete, and query Reckon To Do entries.

Table Specific Information

Select

The following filters support server-side execution. Other filters are executed client-side.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available column for ToDo is Id. All other filters are executed client-side. For example:

SELECT * FROM ToDo WHERE Id = '80000001-1234567890'

Insert

To insert a ToDo entry, specify the Notes field. For example:

INSERT INTO ToDo (Notes, IsDone) VALUES ('Follow up with customer', false)

Update

To update a ToDo entry, specify the Id and the fields to update. For example:

UPDATE ToDo SET IsDone = true WHERE ID = '80000001-1234567890'

Delete

ToDo entries may be deleted using the Id. For example:

DELETE FROM ToDo WHERE ID = '80000001-1234567890'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the vendor type.
Notes	String	False		Notes on this to do entry.
IsActive	Boolean	False		Boolean determining if the vendor type is active.
IsDone	Boolean	False		Whether or not this to do entry is complete.
ReminderDate	Datetime	True		Reminder date for this to do entry.
EditSequence	String	True		A string indicating the revision of the payment method.
TimeCreated	Datetime	True		The time the vendor type was created.
TimeModified	Datetime	True		The last time the vendor type was modified.