{% extends "_layout.html" %} {% set active_page = 'query' %} {% set show_filters = False %} {% block javascript %}{% include "javascript/_editor.html" %}{% endblock %} {% block content %}

Custom Query (via bean-query)

You can run custom querys (BQL) like with the bean-query tool. For a detailed explanation of how queries can be created see the Beancount Query Lanugage Reference, or more generally, the Beancount Documentation Overview. Sample queries can be found here (please submit your own queries if they might be useful for others).

{% if api.queries()|length == 0 %}

If add query-Directives to your Source these stored queries will be displayed as a dropdown to quickly select them.

{% else %}
{% endif %}
{{ query or '' }}
{% if not error and not result %}

Sample Queries:

{% endif %} {% if error %}

Result

{{ error }}

{% endif %} {% if result %}

Result

Download as CSV, XLS, XLSX or ODS

{% for name, type in result.0 %} {% endfor %} {% for row in result.1 %} {% for name, type in result.0 %} {% with value = row[name] %} {% include "queryresults/_querycell.html" %} {% endwith %} {% endfor %} {% endfor %}
{{ name }}
{% endif %} {% endblock %}