select state_id, short_name, pretty_name from workflow_fsm_states where workflow_id=:workflow_id order by short_name select a.action_id, short_name, pretty_name, new_state from workflow_actions a, workflow_fsm_actions fa where workflow_id=:workflow_id and a.action_id=fa.action_id order by short_name select role_id, pretty_name from workflow_roles where workflow_id=:workflow_id