Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1306641

Summary:	Use of Format property in Properties window in source model doesn't seem to work
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Cojan van Ballegooijen <cojan>
Component:	Teiid Designer	Assignee:	Barry LaFond <blafond>
Status:	CLOSED DEFERRED	QA Contact:	Matus Makovy <mmakovy>
Severity:	low	Docs Contact:
Priority:	unspecified
Version:	6.2.0	CC:	cojan, drieden, jolee, mbaluch, vhalbert
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-02-11 16:54:37 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.