Stages
This call gives you a specific stage defined in a pipeline.
Table Specific Information
Select
Streak 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 = comparision. The available columns for Stages are PipelineKey and StageKey. For example:
SELECT * FROM Stages WHERE PipelineKey='agxzfm1haWxmb29nYWVyMAsSab9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSCFdvcmtmbG93GICArJ_i0_EIDA' SELECT * FROM Stages WHERE PipelineKey='agxzfm1haWxmb29nYWVyMAsSDE9yZ2FuaXphdGlvbiIJabRhdGEuY29tDAsSCFdvcmtmbG93GICArJ_i0_EIDA' AND StageKey='5001'
Columns
| Name | Type | References | Description |
| StageKey [KEY] | String | Key of the stage. | |
| PipelineKey | String |
Pipelines.PipelineKey | The key of the pipeline. |
| Name | String | Name of the stage. | |
| ForegroundColor | String | Foreground color of the stage. | |
| BackgroundColor | String | Background color of the stage. | |
| BoxCount | Integer | Number of boxes this stage is applied to. | |
| IsColorFromTheme | Boolean | Whether the color is from a theme. |