nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find the projects in a project catergory.

Shreyance Shaw1

Can someone let me know in which table do i find the projects associated with a project category so that i can form a SQL Query.

Also if its possible to do the same via the soap service i would be much happier

Accepted answers

Shreyance Shaw1

select cname Category, project.id as ProjectID, pname ProjectName, pkey ProjectKey, vname VersionName, projectversion.id VersionID
from jirauser.project, jirauser.nodeassociation, jirauser.projectcategory, jirauser.projectversion
where association_type = 'ProjectCategory'
and sink_node_id = projectcategory.id
and project.id = source_node_id
and project.id = projectversion.project

All comments

Zul NS [Atlassian]

You can check the project table and the projectcategory table, connected by the project ID. Furthermore, the following might help

https://developer.atlassian.com/display/JIRADEV/Database+Schema

Shreyance Shaw1

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud