get array of unique field values using ComposeRecordSearch

[nahiyan-yasaar-selise]

To generate certain reports we are generating an html table but have to rely on triple nested loops. The generation involves both user input (multivalue) and checking the data source for whether records exist for that selection. For example: User selects in a prompt values A to P, but in the data source module, what exists are only records with values G to Z. Because of this, the nested loop still has to loop A to F just to check if data exists or not. This is unoptimal.

The solution involves two independent steps:

1. Find the array of unique values from the data source (i.e. G to Z)
2. Find intersection between this array and selection array (feature request here)

Proposed solution: In ComposeRecordSearch function,

• Add another toggle, similar to 'incTotal' named 'findUnique'
• Add an optional parameter similar to 'sort' named 'uniqueField'
• Add a result array named 'fieldUniques' which will have an output only when 'findUnique' is on.
• Add a 'totalUnique' result that outputs the size of 'fieldUniques'