OpportunityStages
The stage an opportunity is in.
Select
The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- Id supports the '=,IN,>=,<=,>,<' operators.
- CreatedAt supports the '=,>=,<=,>,<' operators.
- Name supports the '=,IN' operators.
- OrderValue supports the '=' operator.
- UpdatedAt supports the '=,>=,<=,>,<' operators.
SELECT * FROM OpportunityStages WHERE Id = 1 SELECT * FROM OpportunityStages WHERE Id IN (1,2) SELECT * FROM OpportunityStages WHERE Id >= 1 SELECT * FROM OpportunityStages WHERE Id <= 1 SELECT * FROM OpportunityStages WHERE Id > 1 SELECT * FROM OpportunityStages WHERE Id < 2 SELECT * FROM OpportunityStages WHERE CreatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE CreatedAt >= '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE CreatedAt = '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE CreatedAt < '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE CreatedAt > '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE UpdatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM OpportunityStages WHERE Name = 'Prospecting' SELECT * FROM OpportunityStages WHERE OrderValue = 0
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of opportunity stage. |
| CreatedAt | Datetime | The date and time the opportunity stage was created. |
| Color | String | The color used to label and highlight the opportunity stage. |
| Name | String | The name of the opportunity stage. |
| OrderValue | Integer | The Order Value of the opportunity stage. |
| UpdatedAt | Datetime | The date and time the opportunity stage was last updated. |
| CreatorId | Integer | Creator Id. |
| OpportunityLinks | String | The opportunities currently associated with the opportunity stage. |