Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • A api
  • Project information
    • Project information
    • Activity
    • Members
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Container Registry
    • Infrastructure Registry
  • Wiki
    • Wiki
  • Activity
Collapse sidebar
  • ironapi
  • api
  • Wiki
  • Api
  • Queries
  • Query Examples

Last edited by Andrea Pavlovic May 25, 2021
Page history

Query Examples

  • Instance State

Instance State

Count the number of instances per state in an entity. This will only work if there is a state/workflow defined on an entity.

Example for extensions.query:

#/data/extensions/query/query
{
     "join"     : "instance_state",
     "group_by" : "instance_state.name",
     "select"   : ["instance_state.name",{"count":"me.id"}],
     "as"       : ["name"               ,"count"]
}
Clone repository
  • API
    • Available Endpoints
    • Changing Passwords
    • Form Input Types
    • Introduction
    • Logout
    • Plugins
    • Queries
    • Queries
      • Attributes
      • Context
      • Query Examples
      • Query Search Options
      • Referenced Instances
      • Saved Queries
    • Schema_Changes
    • Storing Files
View All Pages