ODBC guide

Read issues with all columns (including SLA / nested custom fields)


Gets issues with all columns exposed, including SLA and nested custom fields, without defining a META parameter. Set the connector’s Metadata Mode to MergeStaticDynamic so the driver scans sample data and merges static and dynamic columns. This approach is simpler but slower because of the extra requests used to infer column types from data.

-- No META needed. Set MetaDetectionOrder to MergeStaticDynamic so nested/SLA columns are discovered automatically.
-- Slower: driver makes extra requests to scan data and merge with static metadata.

SELECT *
FROM Issues
WITH(
	  JQL='project IN(SUP)'
	  ,MetaDetectionOrder='MergeStaticDynamic'
)