Bug 1306641 - Use of Format property in Properties window in source model doesn't seem to work
Summary: Use of Format property in Properties window in source model doesn't seem to work
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid Designer
Version: 6.2.0
Hardware: All
OS: All
unspecified
low
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Matus Makovy
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-02-11 14:02 UTC by Cojan van Ballegooijen
Modified: 2016-02-15 13:47 UTC (History)
5 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2016-02-11 16:54:37 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2780 0 Minor Open Use of Format property in Properties window in source model doesn't seem to work 2016-02-15 13:46:59 UTC

Description Cojan van Ballegooijen 2016-02-11 14:02:03 UTC
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

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 15:24:26 UTC
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 15:48:02 UTC
8.0.5 the latest

Comment 4 Cojan van Ballegooijen 2016-02-11 15:48:49 UTC
JBoss Developer Studio 8.1.0GA
Integration Stack including the Teiid Designer plugins 8.0.5

Comment 5 Matus Makovy 2016-02-11 16:54:37 UTC
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.