Skip to content

Query: JB Digital Process Status

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

Tables Referenced

  • ProcessStatus

Columns Selected

  • ProcessStatus.[Selection Type]
  • ProcessStatus.[Step Number]
  • Status
  • ProcessStatus.[Sort Order]

Where Clause

(((ProcessStatus.[Selection Type])=2))

Order By

ProcessStatus.[Sort Order]

SQL

SELECT ProcessStatus.[Selection Type], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order] FROM [ProcessStatus] WHERE (((ProcessStatus.[Selection Type])=2))