| ... | ... | @@ -573,6 +573,38 @@ List only those modules which have entites attached: |
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
# Distinct
|
|
|
|
|
|
|
|
Set to 1 to automatically generate a "group_by" clause based on the selection.
|
|
|
|
|
|
|
|
## Restrictions
|
|
|
|
|
|
|
|
The only values allowed are `0` or `1`.
|
|
|
|
|
|
|
|
## Examples
|
|
|
|
|
|
|
|
`POST /data/system/module/query`
|
|
|
|
|
|
|
|
```json
|
|
|
|
{
|
|
|
|
"attrs": {
|
|
|
|
"join": "system__entity__module",
|
|
|
|
"columns": "me.name",
|
|
|
|
"+select": [
|
|
|
|
{
|
|
|
|
"count": "system__entity__module.id",
|
|
|
|
"-as" : "entity_count"
|
|
|
|
}
|
|
|
|
],
|
|
|
|
"+as": [
|
|
|
|
"entity_count"
|
|
|
|
],
|
|
|
|
"distinct" : 1
|
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
This will add `GROUP BY me.name` to the query.
|
|
|
|
|
|
|
|
# Permitted Column Names
|
|
|
|
|
| ... | ... | |