Skip to content

Query: Qry Report Pipeline List

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • Pipelines Detail
  • Pipelines
  • ProcessStatus

Columns Selected

  • Pipelines.[Pipeline ID]
  • Pipeline
  • ProcessStatus.[Step Number]
  • Status
  • ProcessStatus.[Sort Order]

Order By

Pipelines.[Pipeline ID], ProcessStatus.[Sort Order]

SQL

SELECT Pipelines.[Pipeline ID], Pipelines.Pipeline, ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order] FROM [Pipelines], [Pipelines Detail], [ProcessStatus]