Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: Search Services 2.0
    • Labels:
      None

      Description

      Currently the dates are stored as TrieDate fields in Solr, then they are converted from java.util.Date to strings and passed through calcite. This causes problems with the BI tool integration as those values are treated as strings instead of dates. Also the dates in Solr are in UTC and always have time attached to a date, which is equivalent to TIMESTAMP type in SQL. After the work is done, the format of dates "yyyy-mm-ddThh:mm:ssZ" in queries will not be supported. Also the Solr Date Math expressions (for example "NOW-1MONTH/DAY") will not be supported.

      Acceptance criteria:

      • Change the supported date format in queries from "yyyy-mm-ddThh:mm:ssZ" to "yyyy-mm-dd hh:mm:ss"
      • Remove org.alfresco.solr.transformer.DateFormatDocTransformerFactory
      • Change org.alfresco.solr.sql.SolrSchema to present all "solr.TrieDateField" as java.sql.Timestamp
      • It may be also required to change org.alfresco.solr.stream.JDBCStream and org.apache.solr.client.solrj.io.sql.ResultSetImpl
      • Fix e2e tests that use "yyyy-mm-ddThh:mm:ssZ" date format
      • Fix integration tests that use "yyyy-mm-ddThh:mm:ssZ" date format
      • Create DOCS ticket to change the documentation

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  amukha Alex Mukha
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel