Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AcceptLanguage | Set this Property to send the Accept-Language request header. The accepted values follow the IETF BCP 47 standard for language tags and if is set to a unknown locale it will be ignored. |
| DirectQueryLimit | Limits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| IncludeCustomFields | A boolean indicating whether custom fields should be included in the column listing of the Issues table. |
| IncludeMetadataDescription | Set this property to Columns to retrieve descriptions for custom fields. If retrieval of descriptions for custom fields fails (e.g., due to permission restrictions), the driver will revert to the default behavior (Descriptions will be null) and log the reason for failure. |
| KeyColumnOperators | Specifies how to handle logical and comparison operators applied to Id and Key columns when constructing JQL filters. This property helps manage cases where invalid Id or Key values in JQL filters might otherwise lead to errors or unexpected results, particularly when paired with the UseJqlSearchEndpoint connection property on Jira Cloud. |
| MaximumColumnSize | The maximum column size. |
| MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
| MaxThreads | Specifies the number of concurrent requests. |
| Other | Specifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties. |
| Pagesize | Specifies the maximum number of results to return from Jira, per page. This setting overrides the default page size set by the datasource, which is optimized for most use cases. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns. Use the format 'TableName=ColumnName;TableName=ColumnName'. The default is an empty string, which disables this property. |
| Readonly | Toggles read-only access to Jira from the provider. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. The default is 60 seconds. Set to 0 to disable the timeout. |
| Timezone | Specify the timezone of the Jira instance in order to use the datetime filters accordingly and retrieve the results according to your timezone. An example of a timezone would be America/New_York. |
| UseDefaultOrderBy | Indicates if a default order by should be applied if none is specified in the query. |
| UseDisplayNames | Boolean determining if the display names for custom fields should be used instead of the API names. |
| UseJqlSearchEndpoint | Enables the use of the new /rest/api/2/search/jql endpoint for querying issues and related entities in Jira Cloud. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |