Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi folks, quick API question — in this query I can grab a particular parameter (awesome) but would love to be able to filter on a particular value, e.g. “company_slug=acmecorp” — is this possible today? Thanks :pray:
```query {
  flow_run {
    name
    parameters(path: "company_slug")
  }
}```

Hey Jeff! You can definitely filter your query to a particular value, it would probably look something like this:
```query {
  flow_run(where: {parameters: {_contains: "table"}}) {
    id
    name
  }
}```


Screen Shot 2020-03-26 at 3.12.29 PM.png

Thanks Kyle! I think I am close… I can create a query like that (substituting “table” for a value I know exists) and the query is syntactically correct but does not bring back any flow runs (even though I know some exist). I might not be understanding what “_contains” actually does — the help is almost helpful but I can’t actually see what is says… anyway I’ll keep digging, thanks again.

Of course! You may find some more helpful information here:
<https://hasura.io/docs/1.0/graphql/manual/queries/query-filters.html#jsonb-operators-contains-has-key-etc>

Just to close the loop, here’s the final query:
```        query {
          flow_run(where: {
            _and: {
                flow: {
                    name: { _eq: "jf_data_pipeline" }
                    version_group_id: { _eq: "staging"},
                    archived: { _eq: false }     
                  }
                state: { _eq: "Running" },
                parameters: { _contains: { company_slug: "acmecorp" } },
            }
          }) {
            flow_id
            state
          }
        }```
Loving the GraphQL API!