| ... | @@ -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
|
|
|
|
|
|
| ... | | ... | |