Yes, here you could see I had some issue with sample workflow step and workflow execution got failed and now the failed workflow instance is available in Failure now - JCR_SQL2 query to get workflow instance with ABORTED status -SELECT * FROM [cq:Workflow] AS s WHERE ISDESCENDANTNODE([/var/workflow/...