Hello,
In rundeck I want to run a database query given a job ID for a parent job and option value used.
Give me all the exeuction IDs, start and end time, status of exeuction and option value that was selected.
The job depends on the option value passed to it, so its important that I can get results grouped this way.
The job ID has has steps to execute other jobs, so it would be great if I can get something like this, where option.X is shared/common between parent and child
Job ID (Parent) - Exeuction ID - Start Time - End Time - status - option.X.valueA
Child Job A - Exeuction ID - start Time - end time - status - option.X.valueA
Child job X - Exeuction ID - start Time - end time - status - option.X.valueA
...
Job ID (Parent) - Exeuction ID - Start Time - End Time - status - option.X.valueB
Child Job A - Exeuction ID - start Time - end time - status - option.X.valueB
Child job X - Exeuction ID - start Time - end time - status - option.X.valueB