Skip to content

Instantly share code, notes, and snippets.

@obedmhg
Created March 11, 2020 19:02
Show Gist options
  • Save obedmhg/b289f9b1f4e25cd4aa80d0fd3062b77b to your computer and use it in GitHub Desktop.
Save obedmhg/b289f9b1f4e25cd4aa80d0fd3062b77b to your computer and use it in GitHub Desktop.
<!--Query by date -->
<query-items item-descriptor="sku-link" id-only="false">
creationDate > date("2018-01-01")
</query-items>
<!--Query with INCLUDES ITEM this checks on list of sg items -->
<query-items item-descriptor="order" id-only="false">
(state = "SUBMITTED") AND shippingGroups INCLUDES ITEM (status="SUBMITTED" AND itemType="Cloths")</query-items>
<!-- Query RANGE of items -->
<query-items item-descriptor="sku" id-only="false">
ALL RANGE 20+40
</query-items>
<!-- Load items into cache -->
<load-items item-descriptor="sku">
sku992055,sku992054,sku992053
</load-items>
<!-- Load item specific properties into cache -->
<load-items item-descriptor="product" properties="displayName,description">
prod10001,prod100001,prod100002,prod100003
</load-items>
<!-- Calculates DDL for tables in the repo. This is not the exact DDL it is calculated, don't trust it 100% use it as reference -->
<print-ddl/>
<!--Dump cache stats per item-descriptor -->
<dump-caches item-descriptors="product" dump-type="both"/>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment