JDBC Driver for Highrise

Build 22.0.8462

Deals

Create, update, delete, and query Highrise Deals. This table is dynamic.

Table Specific Information

Select

For datetime columns only the '>' and '>=' operators are supported in the WHERE clause. The following query selects Deals that were updated after a given date.

SELECT * FROM Deals WHERE UpdatedAt > '2012-01-12'

Insert

Name, CategoryId, Background, Currency, Price, PriceType, Duration, and PartyId are required to create a new Deal.

INSERT INTO Deals(Name, CategoryId, Background, Currency, Price, PriceType, Duration, PartyId) VALUES('deal with someone', 4195389, 'black', 'usd', 500, 'fixed', 123545, 149760370)  

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The Id column for the table Deals.

Name String False

The Name column for the table Deals.

AccountId String False

The AccountId column for the table Deals.

AuthorId String False

The AuthorId column for the table Deals.

Background String False

The Background column for the table Deals.

CategoryId String False

The CategoryId column for the table Deals.

Currency String False

The Currency column for the table Deals.

Duration String False

The Duration column for the table Deals.

VisibleTo String False

The VisibleTo column for the table Deals.

GroupId String False

The GroupId column for the table Deals.

OwnerId String False

The OwnerId column for the table Deals.

PartyId String False

The PartyId column for the table Deals.

Price String False

The Price column for the table Deals.

PriceType String False

The PriceType column for the table Deals.

ResponsiblePartyId String False

The ResponsiblePartyId column for the table Deals.

Status String False

The Status column for the table Deals.

StatusChangedOn String True

The StatusChangedOn column for the table Deals.

CreatedAt String True

The CreatedAt column for the table Deals.

UpdatedAt String True

The UpdatedAt column for the table Deals.

DealCustomField1 String False

A Custom Field of type deal.

DealCustomField2 String False

A Custom Field of type deal.

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