JDBC Driver for Highrise

Build 22.0.8462

Cases

Create, update, delete, and query Cases that are visible to the authenticated user.

Table Specific Information

Insert

To insert a new Case, provide at least the Name:

INSERT INTO Cases (Name) values ('my case') 

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier for the case.

Name String False

The name of the case.

IsClosed Boolean True

Whether the case is closed. The default is open.

ClosedAt Datetime False

The date and time when the case was closed.

VisibleTo String False

Who the case is visible to: Everyone, Owner, or NamedGroup.

OwnerId Integer False

The unique identifier of the owner.

GroupId Integer False

The unique identifier of the group.

AuthorId Integer False

The unique identifier of the author.

CreatedAt Datetime True

The date and time when the case was created.

UpdatedAt Datetime True

The date and time when the case was last updated.

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