DB Query to fetch Zephyr Test Step and other JIRA custom fields

[murthy manjunath]

Hello,

Can anybody help me share the DB query to fetch "Zephyr Test Step" along with other JIRA Custom fields?

Zephyr has challenge in UI, which will not allow me to export Zephyr Test Step through normal JQL. We have to got ot test executions to export Zephyr Test Step, but the problem here is we cannot export JIRA Custom fields in this search.

I am looking for one stop to export/fetch both JIRA custom field values and Zephyr Test Step value for issues.

Regard,

Murthy

[Nic Brough -Adaptavist-]

SQL is by far the worst possible option for doing this.  Just fetching the custom fields alone is a nightmare unless your custom fields are all of very similar types.

I would very strongly recommend you look at the Zephyr and Jira remote APIs instead of trying to take your database down with hideously complex queries.