Query

Use SQL language to create complex formulas and analyze data

682

Leverage SQL to add advanced functions to your table.

  • Built-in IDE for fast development.
  • Use data from any table in Jestor.
  • Validate and test your code before implementing it.
800

How to create

To create a Query field:

  • On table mode, go to the last table header with a "+", press (F) or click on the "+" on the upper right and this will open the field creation page
1150
  • Just look for the "Query" option and click on it
  • Choose the name of your field
  • Select a return type
584
  • Enable or disable Dark mode
  • Expand the box and type your function
  • Then click on Run to test your query
584

📘

You can delete or edit by clicking on the table header name and choosing one of the options