O que é o Reporter?

{{ base.table_or_collection.field_or_document }}

{{ base:schema.table.field }}

{{ external_db:sales.orders.total }}
{{ external_db:inventory.items.quantity }}

{% for <item> in <list> %}
  ...
{% endfor %}

{% for order in external_db:sales.orders %}
  {{ order.id }} - {{ order.total }}
{% endfor %}

{% if value_a == value_b %}
  ...
{% endif %}

{% with <object> as <alias> %}
  ...
{% endwith %}

{{ field_name | floatformat:2 }}   --> renderiza 123.45

{% sum_by <collection> by <field> %}
{% sum_by <collection> by <field> if <condition> %}

<Sum>
  {% sum_by transaction.operation by "amount" if accountAlias != "@external/BRL" %}
</Sum>

{% count_by <collection> %}
{% count_by <collection> if <condition> %}

<Count>
  {% count_by transaction.operation if accountAlias != "@external/BRL" %}
</Count>

{% avg_by <collection> by <field> %}
{% avg_by <collection> by <field> if <condition> %}

{% min_by <collection> by <field> %}
{% min_by <collection> by <field> if <condition> %}

{% max_by <collection> by <field> %}
{% max_by <collection> by <field> if <condition> %}

{% date_time "<format>" %}

{% date_time "YYYY-MM-dd" %}           --> 2025-02-06
{% date_time "dd/MM/YYYY HH:mm:ss" %} --> 06/02/2025 14:30:45

{% calc <expression> %}

{% calc 100 + 50 %}                                --> 150
{% calc balance.available * 0.5 %}                 --> valor calculado
{% calc (balance.available + 1.2) * balance.on_hold - balance.available / 2 %}

{% aggregate_balance <collection> by "<balance_field>" group_by "<group_field>" order_by "<date_field>" [if <condition>] as <result_var> %}

{% aggregate_balance accounts by "balance" group_by "cosif_code" order_by "created_at" as balances %}
{% for b in balances %}
  {{ b.group_value }}: {{ b.balance }} ({{ b.count }} contas)
{% endfor %}

{% counter "<counter_name>" %}

{% counter_show "<name1>" %}
{% counter_show "<name1>" "<name2>" "<name3>" %}

{% for tx in ledger.transactions %}
  {% counter tx.type %}
{% endfor %}
Total créditos: {% counter_show "credit" %}
Total débitos: {% counter_show "debit" %}
Combinado: {% counter_show "credit" "debit" %}

{{ value | percent_of: total }}

{{ category.amount | percent_of: total.expenses }}  --> 30.00%

{{ number | strip_zeros }}

{{ "100.50000" | strip_zeros }}  --> 100.5
{{ "100.00" | strip_zeros }}     --> 100
{{ "99.990" | strip_zeros }}     --> 99.99

{{ string | slice:"start:end" }}

{{ "hello" | slice:"0:3" }}  --> hel
{{ "12345" | slice:"1:4" }}  --> 234

{{ string | replace:"search:replacement" }}

{{ "01310-100" | replace:"-:" }}      --> 01310100   (remove hifens)
{{ "1234.56" | replace:".:," }}       --> 1234,56    (ponto para vírgula)
{{ "12.345.678/0001-99" | replace:".:" }}  --> 12345678/0001-99

{{ array | where:"field:value" }}

{{ holders | where:"state:SP" }}
{{ holders | where:"address.state:SP" }}

{% for holder in holders|where:"state:SP" %}
  {{ holder.name }}
{% endfor %}

{{ array | sum:"field" }}

{{ operations | sum:"amount" }}
{{ items | sum:"price.value" }}

{{ array | count:"field:value" }}

{{ operations | count:"nat_oper:6" }}
{{ holders | count:"address.state:SP" }}

{% if contains(source_field, target_field) %}

{
  "templateId": "00000000-0000-0000-0000-000000000000",
  "filters": {
    "midaz_onboarding": {
      "account": {
        "id": { "eq": ["123", "456"] },
        "createdAt": { "between": ["2023-01-01", "2023-01-31"] },
        "status": { "in": ["active", "pending"] }
      }
    }
  }
}

{
  "templateId": "00000000-0000-0000-0000-000000000000",
  "filters": {
    "external_db": {
      "sales.orders": {
        "total": { "gt": [100] },
        "created_at": { "gte": ["2025-01-01"] }
      },
      "finance.invoices": {
        "status": { "eq": ["paid"] }
      }
    }
  }
}