cancel
Showing results for 
Search instead for 
Did you mean: 

ERQL to select applications with a defined retirement date

SOLVED
Occasional Contributor

ERQL to select applications with a defined retirement date

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.

1 REPLY
Occasional Contributor

Re: ERQL to select applications with a defined retirement date

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"