Uploaded image for project: 'Search and Discovery'
  1. Search and Discovery
  2. SEARCH-2297

Fields in a custom model defined as a DATE can get recognised as a STRING


    • Type: Story
    • Status: In Progress
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Sprint:
      Team Ninja-King - S&I 42
    • Story Points:


      When importing a custom model and running a DATE function against it on table for example:

      select expense_ExpenseDate from alfresco

      tableau recognised the expense_ExpenseDate field as a string. 

      When we use cm_modified and cm_created for example which are DateTime fields, tableau recognises these fields as DATES.

      for example: select cm_created from alfresco

      Acceptance Criteria:

      • Understand why the fields in a custom model, although defined as a DATE/DATETIME don't get recognised as a DATE/DATETIME field on tableau 
      • Implement a fix so that when fields are added to a custom model as a DATE or DATETIME data type they get recognised as a DATE or DATETIME and not a string
      • Test the fix, with fields from a custom model definied as a DATE or DATETIME are recognised as a DATE/DATETIME on tableau 

      Update 20/08/2020

      Updated driver provided by Cdata has partially resolved the issue, in that custom date fields are correctly recognized as dates by Tableau in the following circumstances:

      • The query used by Tableau to generate the data source must contain a non-NULL date value for the custom date field within the first 1000 returned rows

      Therefore this issue is limited to custom dates where large numbers of records are likely to have a NULL value.

      Work done for this ticket so far was expected to resolve this issue, but appears to have been ineffective. Further investigation required.


          Issue Links




                • Assignee:
                  agazzarini Andrea Gazzarini
                  klalia Keerat Lalia
                • Votes:
                  0 Vote for this issue
                  3 Start watching this issue


                  • Created:

                    Structure Helper Panel