Bug 1306641 - Use of Format property in Properties window in source model doesn't seem to work
Use of Format property in Properties window in source model doesn't seem to work
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid Designer (Show other bugs)
All All
unspecified Severity low
: ---
: ---
Assigned To: Barry LaFond
Matus Makovy
Depends On:
  Show dependency treegraph
Reported: 2016-02-11 09:02 EST by Cojan van Ballegooijen
Modified: 2016-02-15 08:47 EST (History)
5 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2016-02-11 11:54:37 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

External Trackers
Tracker ID Priority Status Summary Last Updated
JBoss Issue Tracker TEIIDDES-2780 Minor Open Use of Format property in Properties window in source model doesn't seem to work 2016-02-15 08:46 EST

  None (edit)
Description Cojan van Ballegooijen 2016-02-11 09:02:03 EST
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):

How reproducible:

Steps to Reproduce:
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

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

Additional info:
Workaround is to create a view model on top of it and do the transformation there.
Comment 2 Matus Makovy 2016-02-11 10:24:26 EST
Can you specify the version of desinger you are using ?

Also, we are tracking Teiid Designer issues in JIRA. I created new JIRA and attached it. I will close this BZ later.
Comment 3 Cojan van Ballegooijen 2016-02-11 10:48:02 EST
8.0.5 the latest
Comment 4 Cojan van Ballegooijen 2016-02-11 10:48:49 EST
JBoss Developer Studio 8.1.0GA
Integration Stack including the Teiid Designer plugins 8.0.5
Comment 5 Matus Makovy 2016-02-11 11:54:37 EST
Thank you, I'll close this BZ, I updated the JIRA and this issue will be tracked there.

Note You need to log in before you can comment on or make changes to this bug.