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