E06: MEI Threshold and TAs Query

This article is one of the worked examples for RCM Queries. It shows how to list MEI thresholds and TA dates and intervals that are stored at the Unit level, using a Query. For when and why to use a query in RCM, see RCM Queries – Background; for day-to-day query tips, see Working with Queries.

Setting Up the Query

MEI Thresholds and TA dates and intervals are stored on Unit level, and can be cumbersome to retrieve in a list.
RCM Query overview showing where MEI threshold and TA fields sit at Unit level.

This Query has the Base view: "FLOC", and uses the fields vwRCMSitePlantUnit and Location type. To retrieve the data from the Units only, add a criterion where Location type equals "UNIT":

Query criteria panel with the Location type filter set to UNIT.

Query Result

The result looks like this:

Example query result listing MEI thresholds and TA dates per Unit.

To see how a query can be created, see the video: RCM Analyses Changes - Query.