Inventory Movements? GraphQL query?

[ChrisBradley]

Dame

@KyleG-Shopify

{
  shopifyqlQuery(query: """
    FROM inventory_adjustment_history
    SHOW inventory_adjustment_change, inventory_adjustment_count
    GROUP BY product_variant_sku, day, reference_document_type
    HAVING inventory_adjustment_change != 0
    SINCE -1d
    UNTIL today
    ORDER BY day DESC
    LIMIT 100
  """) {
    tableData {
      columns { name dataType displayName }
      rows
    }
    parseErrors
  }
}

Thanks @KyleG-Shopify

Damn that is really useful. I must have missed this changelog over the christmas period.

have tested this out, and I was kind of assuming there would be a 3 lines within the report for a specific GID, but I have 10?

I kind of understand why there is a Purchase (to move inventory from Available to Committed), then the order fulfilled (from Commited to dispatched)

what I dont understand is why there is a None and they there are more that lineitems in the purchase?

GID is this gid://shopify/Order/6064403185819