The Map gello looks similar to standard query with the result being Key Value pairs.

The keys are customisable. 

The Maps are run on the whole population to produce a map cache. This example of the indications for endoscopy for a gastroenterology practice shows the map stage took about 20 minutes for 113000 nested and at times complex patient records as VMRs.

Some Reduce gello is shown here; again its a fairly simple worked example. The loop is just to help the output strings be unique and somewhat cleaned.:

The actual result for the combined MapReduce:

The result can be saved into various formats with a right click on the result element, in this case 'b':

A clinical use case is for audit and research. The auditable and researchable Map cache could be updated on a regular basis to surface population clinical data of interest for bespoke Reduce gello queries. 

In a gastroenterology practice doing colonoscopies, this includes the 'To caecum' rate ( an assessment of the quality of the scope procedure) and an Adenoma rate ( the number of adenomas on subsequent biopsy for biopsies performed with endoscopy). The example above is for upper endoscopies. Different clinical queries would be desired.