Add custom field as a column in the jira_issue table

[Chris Garstin]

To use the date slider feature on a dashboard, it looks for a date field in the data schema.

We have a custom field that is not in the jira_issue table, and I want to add it as a column so it becomes available to the date slider control.

What query (if possible) do I use when creating a custom field to lookup this date customer field.

I want to add a column to jira_issue that is a date field in jira_issue_field. I can't do this in the visual editor because the date slider only accepts fields from the data schema.

[Inder Singh]

@Chris Garstin Is there a particular reason you want to use a Date slider instead of a Calendar control?

For your case, you might be able to use date slider by typecasting the field value as DATE(). See the screenshot below: