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
x authored Jan 21, 2022 by Andrea Pavlovic's avatar Andrea Pavlovic
Show whitespace changes
Inline Side-by-side
API/Queries/Query-Search-Options.md
View page @ 48204178
...@@ -101,9 +101,22 @@ If a column on a big table is not indexed correctly, this search option will not ...@@ -101,9 +101,22 @@ If a column on a big table is not indexed correctly, this search option will not
This is an extension for IronAPI. This is an extension for IronAPI.
This sorts the result by how "close" it is to the supplied text. See the [Similarity Postgres Documentation](https://www.postgresql.org/docs/9.6/static/pgtrgm.html).
`POST /data/system/entity/query`
```json ```json
{"attrs" : {"order_by" : {"-similarity" : ["me.name","constant"]}, "columns" : "me.name"}} {
"attrs": {
"order_by": {
"-similarity": [
"me.name",
"constant"
]
},
"columns": "me.name"
}
}
``` ```
This will be translated to sql `ORDER BY me.name <-> ? : "constant"`. This will be translated to sql `ORDER BY me.name <-> ? : "constant"`.
......
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