Query

Generated from --help output of fob-actual 0.1.0. Every command also accepts the global options --profile <name>, --help and --version.

query#

query run#

fob-actual query run

Run an ActualQL query

Options:
      --table     Table to query (transactions, accounts, …)                                [string]
      --select    Columns to select, comma-separated                                        [string]
      --filter    Filter as JSON, e.g. '{"amount":{"$lt":0}}' (repeatable)                   [array]
      --order-by  Order by this field                                                       [string]
      --desc      Order descending                                                         [boolean]
      --limit     Maximum rows                                                              [number]
      --query     A full serialized query as JSON                                           [string]
      --file      Read the serialized query from a file                                     [string]
      --format    Output format                                   [string] [choices: "table", "csv"]
      --json      Output the raw result envelope                                           [boolean]