in jira command line tool can we get project name and used workflow list

Question

--category

Bob Swift · Answer

Ditto Renjith's comment: No, not currently. There are more workflow related REST APIs now, so something more could be added in the future. Open an issue with more details. In the meantime, something similar to the following query may help:

select 
(select pname from project where id = source_node_id) as "Project",
(select name from workflowscheme where id = sink_node_id) as "Workflow Scheme",
Array((select workflow from workflowschemeentity where scheme = sink_node_id)) as "Workflows"
from nodeassociation 
where source_node_entity = 'Project' and sink_node_entity = 'WorkflowScheme'

Renjith Pillai · Answer

Mostly no. Can you let us know what you are trying to achieve?