There are a bunch of SQL queries here https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA we would like to run. Is the available for OnDemand or do we need to use the API?
OnDemand does not allow you access to the database. You'll need to use REST to get the information.
See https://answers.atlassian.com/questions/39171/does-hosted-jira-ondemand-provide-read-only-access-to-the-jira-db-so-that-i-can-run-sql-statements-for-reporting-purposes
It looks like you're new here. Sign in or register to get started.