Add resolution_date column to jira_issue table closes #55

[misraved]

Example query results

Results

``` select title, resolution_date, status from jira_issue +--------------+---------------------------+----------------------+ | title | resolution_date | status | +--------------+---------------------------+----------------------+ | SSP-19 | 2021-05-15T02:42:57+05:30 | Done | | SSP-23 | 2021-05-23T14:53:57+05:30 | Done | | SSP-17 | 2021-05-29T00:04:57+05:30 | Done | | SSP-13 | 0001-01-01T05:53:28+05:53 | To Do | | SSP-16 | 2021-05-26T14:00:57+05:30 | Done | | TEST6-8 | 2021-07-20T18:23:32+05:30 | Open | | SSP-18 | 2021-05-12T02:48:57+05:30 | Done | | SSP-15 | 2021-05-29T22:04:57+05:30 | Done | | TEST6-9 | 0001-01-01T05:53:28+05:53 | Open | | TEST-3 | 2021-06-23T16:24:21+05:30 | Done | ``` ``` > select title, status, resolution_date from jira_issue where resolution_date > '2021-06-20' +--------------+--------+---------------------------+ | title | status | resolution_date | +--------------+--------+---------------------------+ | PLUGINJIRA-6 | Done | 2021-07-20T18:54:55+05:30 | | TEST6-7 | Closed | 2021-07-20T18:31:53+05:30 | | TEST-2 | Done | 2021-06-23T16:23:23+05:30 | | TEST-3 | Done | 2021-06-23T16:24:21+05:30 | | TEST6-8 | Open | 2021-07-20T18:23:32+05:30 | +--------------+--------+---------------------------+ > select title, status, resolution_date from jira_issue where resolution_date < '2021-06-20' +--------------+----------------------+---------------------------+ | title | status | resolution_date | +--------------+----------------------+---------------------------+ | PLUGINJIRA-3 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-11 | In Progress | 0001-01-01T05:53:28+05:53 | | PLUGINJIRA-5 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-1 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-12 | In Progress | 0001-01-01T05:53:28+05:53 | | SSP-14 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-2 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-24 | To Do | 0001-01-01T05:53:28+05:53 | | TEST6-3 | Open | 0001-01-01T05:53:28+05:53 | | SSP-13 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-1 | Waiting for support | 0001-01-01T05:53:28+05:53 | | PLUGINJIRA-2 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-6 | Waiting for support | 0001-01-01T05:53:28+05:53 | | SSP-15 | Done | 2021-05-29T22:04:57+05:30 | | SSP-7 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-21 | Done | 2021-05-18T21:55:57+05:30 | | SSP-8 | To Do | 0001-01-01T05:53:28+05:53 | | TEST-1 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-16 | Done | 2021-05-26T14:00:57+05:30 | | TEST6-9 | Open | 0001-01-01T05:53:28+05:53 | | SSP-20 | Done | 2021-05-16T15:17:57+05:30 | | SSP-10 | In Progress | 0001-01-01T05:53:28+05:53 | | SSP-18 | Done | 2021-05-12T02:48:57+05:30 | | SSP-23 | Done | 2021-05-23T14:53:57+05:30 | | SSP-3 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-9 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-4 | Waiting for approval | 0001-01-01T05:53:28+05:53 | | SSP-5 | To Do | 0001-01-01T05:53:28+05:53 | | SSP-22 | Done | 2021-05-21T13:15:57+05:30 | | PLUGINJIRA-1 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-2 | Waiting for support | 0001-01-01T05:53:28+05:53 | | SSP-6 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-3 | Waiting for support | 0001-01-01T05:53:28+05:53 | | SSP-19 | Done | 2021-05-15T02:42:57+05:30 | | SSP-25 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-7 | Waiting for support | 0001-01-01T05:53:28+05:53 | | SSP-4 | To Do | 0001-01-01T05:53:28+05:53 | | DEMO-5 | Resolved | 2021-06-11T16:31:28+05:30 | | SSP-17 | Done | 2021-05-29T00:04:57+05:30 | +--------------+----------------------+---------------------------+ ```

[ParthaI]

@misraved can you add more example queries with resolution_date optional quals column? Just to confirm the resolution_date is working fine as an optional qual.

[misraved]

Thanks @ParthaI for the feedback. I have added a few queries in the results section of the PR, could you please verify if they are sufficient?