| ... | @@ -11,7 +11,7 @@ The IronAPI supports these options: |
... | @@ -11,7 +11,7 @@ The IronAPI supports these options: |
|
|
- [(+)select](#select-and-as)
|
|
- [(+)select](#select-and-as)
|
|
|
- [(+)as](#select-and-as)
|
|
- [(+)as](#select-and-as)
|
|
|
- [order_by](#ordering)
|
|
- [order_by](#ordering)
|
|
|
- group_by
|
|
- [group_by](#group-by)
|
|
|
- collapse
|
|
- collapse
|
|
|
- having
|
|
- having
|
|
|
|
|
|
| ... | @@ -267,6 +267,19 @@ Use another function: |
... | @@ -267,6 +267,19 @@ Use another function: |
|
|
}
|
|
}
|
|
|
```
|
|
```
|
|
|
|
|
|
|
|
|
### json
|
|
|
|
|
|
|
|
`POST /data/extensions/client_meta_data/query`
|
|
|
|
|
|
|
|
```json
|
|
|
|
{
|
|
|
|
"attrs" : {
|
|
|
|
"select" : "settings->>'login_name'",
|
|
|
|
"as" : "login_name"
|
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
"+select" and "+as" are also available.
|
|
"+select" and "+as" are also available.
|
|
|
|
|
|
|
|
<https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/ResultSet.pm#select>
|
|
<https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/ResultSet.pm#select>
|
| ... | @@ -379,6 +392,9 @@ A column defined by select and as: |
... | @@ -379,6 +392,9 @@ A column defined by select and as: |
|
|
}
|
|
}
|
|
|
```
|
|
```
|
|
|
|
|
|
|
|
|
# Group By
|
|
|
|
|
|
|
|
|
|
|
# Collapse
|
|
# Collapse
|
|
|
|
|
|
|
|
When "collape" is set to a true value, indicates that any rows fetched from joined has_many relationships
|
|
When "collape" is set to a true value, indicates that any rows fetched from joined has_many relationships
|
| ... | @@ -482,7 +498,7 @@ https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/ResultSet.pm#col |
... | @@ -482,7 +498,7 @@ https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/ResultSet.pm#col |
|
|
# Permitted Column Names
|
|
# Permitted Column Names
|
|
|
|
|
|
|
|
Wherever a column is defined, it may be a simple name if it's unique e.g. `id`, or with the entity prefix `me.id`.
|
|
Wherever a column is defined, it may be a simple name if it's unique e.g. `id`, or with the entity prefix `me.id`.
|
|
|
For json columns, a selector may be defined: `data->>'ident'` or `me.data->>'ident'.
|
|
For json(b) columns, a selector may be defined: `data->>'ident'` or `me.data->>'ident'.
|
|
|
|
|
|
|
|
# Permitted functions
|
|
# Permitted functions
|
|
|
|
|
|
| ... | | ... | |