alphagov / paas-steampipe-dashboard

a steampipe.io based dashboard for GOV.UK PaaS and related things
MIT License
13 stars 0 forks source link

Create input selectors #40

Closed pauldougan closed 2 years ago

pauldougan commented 2 years ago

https://steampipe.io/docs/reference/mod-resources/input

pauldougan commented 2 years ago

input "regions" {
  title = "regions"
  type  = "select"
  width = 2

  sql  = <<-EOQ
    select
      distinct region as value
    from
      organisations;
  EOQ
}
pauldougan commented 2 years ago

input "departments" {
  title = "departments"
  type  = "select"
  width = 2

  sql  = <<-EOQ
    select
      distinct owner as department
    from
      organisations
     order by
       owner
  EOQ
}