Time Tracking Required for Certain Users?

[Katelyn Withers]

Is there a way to make time tracking required for certain users/user groups?

[Faisal · Accepted solution]

Hi there,

Since you would like to query the projects that doesn't have any issue created under it, then I believe that we may combine the project and jiraissue table in order to get the desire results. Kindly note that in jiraissue table, there's a project column which stores the ID of the project in project table.

Hence, I believe that you may run the following SQL statement to retrieve the projects:

select * from project where id not in (select project from jiraissue);

I hope that this will help!

[Deleted user]

Great stuff Ahmad. This answers my question!