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