![]() ![]() ![]() SDE | Team | Jira Service Management Pending Reason screen - 3 | Change | Workflow Scheme | Jira Service Management IT Support Workflow Scheme generated for Project SDE SDE | Change type | SDE: Jira Service Management: Change View/Edit Screen | Change | Screen Scheme | SDE: Jira Service Management Issue Type Screen Scheme SDE | Change start date | SDE: Jira Service Management: Change Create Issue Screen | Change | Screen Scheme | SDE: Jira Service Management Issue Type Screen Scheme ![]() PROJ | priority | PROJ: Scrum Bug Screen | Bug | Screen Scheme | PROJ: Scrum Issue Type Screen Scheme PROJ | labels | PROJ: Scrum Bug Screen | Bug | Screen Scheme | PROJ: Scrum Issue Type Screen Scheme Project Key | Custom Field Name | Screen Name | Issue Type | Source | Scheme Name The query above is an example based off Postgres syntax and lists all fields configured either in Screen Schemes or Workflow schemes. SELECT w."Project Key", w."Custom Field Name", w."Screen Name", w."Issue Type", 'Workflow Scheme' as "Source", w."Scheme Name" SELECT s."Project Key", s."Custom Field Name", s."Screen Name", s."Issue Type", 'Screen Scheme' as "Source", s."Scheme Name" Left join issuetype it on it.id = wfse.issuetype Join fieldscreen fs on wf.descriptor like concat('%', fs.id, '%') Join jiraworkflows wf on wf.workflowname = wfse.workflow Join workflowschemeentity wfse on wfse.scheme = wfs.id Join workflowscheme wfs on wfs.id = na.sink_node_id Join nodeassociation na on na.source_node_id = p.id and na.sink_node_entity = 'WorkflowScheme' Select distinct p.pkey as "Project Key", coalesce(cf.cfname, fsli.fieldidentifier) as "Custom Field Name", fs.name as "Screen Name", coalesce(it.pname, 'DEFAULT') as "Issue Type", wfs.name as "Scheme Name" Left join issuetype it on it.id = itsse.issuetype Left join customfield cf on concat('customfield_', cf.id) = fsli.fieldidentifier Join fieldscreenlayoutitem fsli on fsli.fieldscreentab = fst.id Join fieldscreentab fst on fst.fieldscreen = fs.id Join fieldscreen fs on fs.id = fssi.fieldscreen Join fieldscreenschemeitem fssi on fssi.fieldscreenscheme = fss.id Join fieldscreenscheme fss on fss.id = itsse.fieldscreenscheme Join issuetypescreenschemeentity itsse on itsse.scheme = itss.id Join issuetypescreenscheme itss on itss.id = na.sink_node_id Join nodeassociation na on na.source_node_id = p.id and na.sink_node_entity = 'IssueTypeScreenScheme' Select distinct p.pkey as "Project Key", coalesce(cf.cfname, fsli.fieldidentifier) as "Custom Field Name", fs.name as "Screen Name", coalesce(it.pname, 'DEFAULT') as "Issue Type", itss.name as "Scheme Name" ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |