{% set result_only = request.args.get('result_only', False) %}{% if not result_only %}{% extends "_layout.html" %}{% endif %} {% set active_page = 'query' %} {% import '_query_table.html' as querytable with context %} {% set query = request.args.get('query_string', '') %} {% set query_shell_history = ledger.query_shell.get_history(20)|reverse %} {% set contents, result_types, result_rows = ledger.query_shell.execute_query(query, add_to_history=True) %} {% block content %} {% if not result_only %}
{{ query }}
{% if result_types %}
{{ _('Download as') }}
CSV{% if config['HAVE_EXCEL'] %},
XLS,
XLSX or
ODS
{% endif %}
{% endif %}
{{ contents }}
{% elif result_types %}
{{ querytable.querytable(result_types, result_rows) }}
{% endif %}
{{ history_item }}