Batch Detail Page Error

Question

Originally posted by Unknown

After upgrading I get a query error when I click on a Batch from the new Obsidian batch list block. How do I fix this?

Answer 1

Originally posted by Unknown

Post this lava at the top of the query in the dynamic data block. The batch page now uses a hashed version of the batch id in the URL instead of the numeric Id.

{% assign batchId = PageParameter.BatchId | AsInteger %}
{% if batchId > 0 %}
    DECLARE @BatchId INT = {{ batchId }};
{% else %}
    DECLARE @BatchId int = {{ PageParameter.BatchId | FromIdHash | Default:'0' | AsInteger }};
{% endif %}