Query View

    • Editor
    • Running Queries

    The web interface offers a AQL Query Editor:

    The editor is split into two parts, the query editor pane and the bind parameter pane.

    The left pane is your regular query input field, where you can edit and then execute or explain your queries. By default, the entered bind parameter will automatically be recognized and shown in the bind parameter table in the right pane, where you can easily edit them.

    The input fields are equipped with type detection. This means you don’t have to use quote marks around string, just write them as-is. Numbers will be treated as numbers, true and false as booleans, null as null-type value. Square brackets can be used to define arrays, and curly braces for objects (keys and values have to be surrounded by double quotes). This will mostly be what you want. But if you want to force something to be treated as string, use quotation marks for the value:

    If you are used to work with JSON, you may want to switch the bind parameter editor to JSON mode by clicking on the upper right toggle button. You can then edit the bind parameters in raw JSON format.

    Custom Queries

    By pressing the Queries button in the top left corner of the editor you activate the custom queries view. Here you can select a previously stored custom query or one of our query examples.

    Click on a query title to get a code preview. In addition, there are action buttons to:

    • Copy to editor
    • Explain query
    • Run query
    • Delete query

    For the built-in example queries, there is only Copy to editor available.

    To export or import queries to and from JSON you can use the buttons on the right-hand side.

    Spotlight

    The spotlight feature opens up a modal view. There you can find all AQL keywords, AQL functions and collections (filtered by their type) to help you to be more productive in writing your queries. Spotlight can be opened by the magic wand icon in the toolbar or via shortcut (see below).

    The Running Queries tab gives you a compact overview of all running queries. By clicking the red minus button, you can abort the execution of a running query.

    Slow Queries

    The Slow Query History tab gives you a compact overview of all past slow queries.