Skip to main content

Quick means of extracting all records for where a particular field which satisfies a list of values

Hello Group Members,

We often need to extract / filter out a list of values from a Field in an active database within IDEA for further analysis or reporting.
 
Let us take an example. You have a field PROD CODE in your database in IDEA which has over 50 Product Codes listed. Now your requirement is to capture PROD CODE - A01, B04, C09, D13, E17 and F29
 
One way you can set about accomplishing this in IDEA is to apply a criteria through a Direct Extraction as ~
 
PROD CODE = "A01" .OR. PROD CODE = "B04" .OR. PROD CODE = "C09" .OR. PROD CODE = "D13" .OR. PROD CODE = "E17" .OR. PROD CODE = "F29"
 
While the above criteria would work and give you the desired result, an optimal way of achieving the same result would be to use the criteria through the Direct Extraction as ~
 
@match(PROD CODE, "A01", "B04", "C09", "D13", "E17", "F29")
 
Now it is important to note that @match or even @List (which serves the same purpose) is case sensitive. So if your data contains a01 or d13 (lower case) and E17 and F29 (upper case), then @match() will work with reference to the case provided in your criteria.
 
So to ensure you capture all case iterations correctly tweak your criteria to ~
 
@match(@upper(PROD CODE), "A01", "B04", "C09", "D13", "E17", "F29")
 
Can any member visualize another functionality in IDEA which can help extract all records for a particular field which satisfies a list of values without using a criteria or expression.
 
Best Regards
 
Group Admin Team