ERQL to select applications with a defined retirement date

[DLawrie]

Please would someone share the ERQL to select all applications with a retirement set to a specific date using the default artifact lifecycle. Thank you.

[DLawrie · Accepted solution]

Need to double check the names of the different states in the state machine life cycle model and replace the retirement word if you are not using the default life cycle.

/* To query the retirement date of an application */
/* Date format is mm/dd/yyyy */

Select application where [period of validity].[Short Name] like "#retirement#"
and [period of validity].[Absolute End Date] = "01/16/1986"