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

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Minor 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

      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.

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

                Created:
                Updated:
                Resolved: