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
  • Query Search Options

Query Search Options · Changes

Page history
attrs docu authored Jan 26, 2022 by Andrea Pavlovic's avatar Andrea Pavlovic
Show whitespace changes
Inline Side-by-side
API/Queries/Query-Search-Options.md
View page @ 1e58c2c3
...@@ -167,18 +167,25 @@ will be translated to ...@@ -167,18 +167,25 @@ will be translated to
If a column on a big table is not indexed correctly, this search option will not be allowed. If a column on a big table is not indexed correctly, this search option will not be allowed.
# JSONB contains (@>) ## JSONB contains (@>)
This is an extension for IronAPI. Does the left JSONB value contain the right JSONB path/value entries at the top level? This is an extension for IronAPI. Does the left JSONB value contain the right JSONB path/value entries at the top level?
`POST /data/extensions/client_meta_data/query`
```json ```json
#/data/core/customer/query
{ {
"conds" : {"me.phonenumbers" : {"@>" : {"mobile": "+4354359"} } } "conds": {
"me.settings": {
"@>": {
"login_name": "test"
}
}
}
} }
``` ```
# Subtree ## -subtree
This is an extension for IronAPI. This is an extension for IronAPI.
...@@ -192,7 +199,6 @@ For entities which represent a tree structure ("isTree": true in the universe), ...@@ -192,7 +199,6 @@ For entities which represent a tree structure ("isTree": true in the universe),
The search may be limited to a certain depth, in this example it's "2", so only the main entry (with id "1") and it's direct children will be returned: The search may be limited to a certain depth, in this example it's "2", so only the main entry (with id "1") and it's direct children will be returned:
```json ```json
{ {
"conds": {"me.id": {"-subtree": [1, 2] } "conds": {"me.id": {"-subtree": [1, 2] }
...@@ -222,7 +228,7 @@ with "and": ...@@ -222,7 +228,7 @@ with "and":
} }
``` ```
# Parents ## -parents
This is an extension for IronAPI. This is an extension for IronAPI.
......
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