SQL query showing issues custom field values

[Rob B]

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

[Nic Brough -Adaptavist-]

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?

[Rob B]

Its been done before - Im sending a report out (SQL) via email using powershell and task scheduler.

[Nic Brough -Adaptavist-]

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?

[Rob B]

Wow thanks for that lovely reply Nic! My company normally have a good relationship with adaptavist. Shame.