Can someone help me with the SQL that basically does the below JQL...
issuetype = "B05" AND updated >= -4h
In the SQL i need to pull off certain custom fields as well.
Thanks
I'd strongly recommend you stop looking at the database for this.
There are at least five separate tables and conditional reads you'll need to understand the usage of in order to construct some (likely to be non-performant) SQL to replicate the JQL.
What problem are you trying to solve by doing this?
Its been done before - Im sending a report out (SQL) via email using powershell and task scheduler.
What a horrid thing to have to do! Why don't you do the reporting properly by writing a simple REST call to get what people say they need?
Wow thanks for that lovely reply Nic! My company normally have a good relationship with adaptavist. Shame.
It looks like you're new here. Sign in or register to get started.
