A space to discuss GraphQL queries, mutations, troubleshooting, throttling, and best practices.
The following ShopifyQL query is not working properly:
SHOW sum(ordered_product_quantity) as total_quantity
GROUP BY product_id
ORDER BY total_quantity DESC LIMIT 20"
However, everything is working properly when I use "yesterday" instead of "today". This was my original query from two days ago, which stopped working yesterday. Was there any change to the ShopifyQL system?
FROM sales SHOW net_quantity GROUP BY product_id WHERE sale_line_type='product' SINCE today UNTIL today ORDER BY net_quantity DESC LIMIT 20
See this thread: https://community.shopify.com/c/shopify-apis-and-sdks/shopifyql-query-stopped-working-sales-is-no-lo...