I would like to know whether document caches support range lookups or not?
i.e. if I index a cache on start and end date fields will I be able to do a range lookup via the index or does it only support exact value matches
Correct. Date range lookups are not supported. Thank you for the suggestion on incorporating decision shapes but for what I want to achieve I think I'll move the lookup to a database stored procedure.
it supports only index. You can definitely create a solution for this. For example: load from cache -> decision shape, to check for start data -> another decision to check end date. ANd from there on you can push it to a map shape or use another cache. and reference that in the map or persist the data in a queue and use it later in the process. Just putting some ideas out there.
It is possible a workaround.
Document cache return several records with the same index in case that more than one document with the same key were saved in cache
You can include a low and high field to filter your value in a business rule or decision after loading data in a document cache
Retrieving data ...