Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

ShopifyQL data from today not working

ShopifyQL data from today not working

KevinSchade
Shopify Partner
8 0 0

The following ShopifyQL query is not working properly:

FROM products
SHOW sum(ordered_product_quantity) as total_quantity
GROUP BY product_id
SINCE today
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

 

Reply 1 (1)