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
  • Attributes

Attributes · Changes

Page history
attrs docu authored Jan 25, 2022 by Andrea Pavlovic's avatar Andrea Pavlovic
Hide whitespace changes
Inline Side-by-side
API/Queries/Attributes.md
View page @ f95eb6ca
...@@ -589,7 +589,6 @@ The only values allowed are `0` or `1`. ...@@ -589,7 +589,6 @@ The only values allowed are `0` or `1`.
{ {
"attrs": { "attrs": {
"join": "system__entity__module", "join": "system__entity__module",
"columns": "me.name",
"+select": [ "+select": [
{ {
"count": "system__entity__module.id", "count": "system__entity__module.id",
...@@ -604,7 +603,15 @@ The only values allowed are `0` or `1`. ...@@ -604,7 +603,15 @@ The only values allowed are `0` or `1`.
} }
``` ```
This will add `GROUP BY me.name` to the query. This will add a group by all column names of system.module to the query:
```sql
SELECT
me.id, me.name, me.label, me.description, me.modifying_action, me.modifying_client, me.modification_time, me.instance_entity, me.successor,
COUNT( system__entity__module.id ) AS entity_count
FROM system.module() me
LEFT JOIN system.entity system__entity__module ON system__entity__module.module = me.id
GROUP BY me.id, me.name, me.label, me.description, me.modifying_action, me.modifying_client, me.modification_time, me.instance_entity, me.successor
```
# Permitted Column Names # Permitted Column Names
......
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