Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2780

Use of Format property in Properties window in source model doesn't seem to work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Minor
    • None
    • 10.0, 9.0.5
    • None
    • None
    • Hide

      1. Create a table with a date field (I was using MySQL in the above example)
      2. Create a connection profile to the database
      3. Import tabel as a source model in Teiid Designer using the connection profile created before
      4. select the date field in the source model
      5. Change Datatype property from date to string
      6. Change Format property to dd-MM-yyyy

      Show
      1. Create a table with a date field (I was using MySQL in the above example) 2. Create a connection profile to the database 3. Import tabel as a source model in Teiid Designer using the connection profile created before 4. select the date field in the source model 5. Change Datatype property from date to string 6. Change Format property to dd-MM-yyyy
    • Workaround Exists
    • Hide

      Create view model and transform date there

      Show
      Create view model and transform date there

    Description

      Issue copied from BZ, original reporter is cvanball@redhat.com.

      Description of problem:
      We have a use case where we have to replace datatypes with alternate

      For example
      SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.

      Version-Release number of selected component (if applicable):
      N/A

      Actual results:
      Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in

      Expected results:
      Date transformation to dd-MM-yyyy

      mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mmakovy@redhat.com Matus Makovy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: