RQL Non common queries and opperations

Here is a list of non common rql commands you can use, since this is a gist will be updated with more examples, so feel free to bookmark this.

	<!--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"/>

Obed's Tech Blog