[SEARCH-2296] Support for QUARTER function Created: 10-Jun-20  Updated: 24-Aug-20  Resolved: 16-Jun-20

Status: Done
Project: Search and Discovery
Component/s: None
Affects Version/s: None
Fix Version/s: Search Services 2.0

Type: Story
Reporter: Keerat Lalia Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File tableau-quarter.png    
Issue Links:
is related to by SEARCH-2304 Support for CAST AS TIMESTAMP functio... Done
Epic Link: BI Tool integration via CData - Must Have
Sprint: Team Ninja-King - S&I 34
Release Train: Southall
Delivery Team: Search
Story Points: 8


When testing the DATE functions and using YEAR, we want to go onto the next date type and that links to QUARTER on tableau. This results in an error as there is currently no support for the QUARTER function.

An investigation is required to see if we can compute the QUARTER function at runtime. The implementation may require a change to the schema. 

Acceptance Criteria:

  • Add support for the QUARTER function
  • Test the QUARTER function is working with custom sql queries using the DATE function on tableau

Comment by Angel Borroy [ 16-Jun-20 ]

Tested successfully with Tableau.

Generated at Tue May 18 06:59:13 BST 2021 using Jira 7.13.15#713015-sha1:7c5ddd2c3e1709974ae9c48c17df8edd3919fe2c.