Re: [Wonder-disc] Derived attribute table alias

[Kieran K. <kel...@gm...>]

IIRC, I didn't find a solution the last time I tried to use a derived attribute in a related table qualifier or a raw row keypath to a related table derived attribute. (with WO 5.3.3 anyway) ......... a quick ugly workround might be to convert your fetch spec to SQL, write some logic to modify the SQL to be correct and stick it in the Hints dictionary so that it gets used instead of the auto-generated SQL.


On Jan 25, 2011, at 12:33 PM, Edward Merry wrote:

> When using a Derived Attribute in Entity Modeler, is there a way to include a placeholder in the SQL snippet that would represent the Modeler's generated table alias?
> 
> I am using
> 
> CAST(\"RECEIVED_DTTM\" AS DATE)
> 
> but I wish to have Entity Modeler include the table alias so that
> 
> CAST(<placeholder to indicate this table alias>.\"RECEIVED_DTTM\" AS DATE)
> 
> becomes
> 
> CAST(t1.\"RECEIVED_DTTM\" AS DATE)
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
> February 28th, so secure your free ArcSight Logger TODAY! 
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> Wonder-disc mailing list
> Won...@li...
> https://lists.sourceforge.net/lists/listinfo/wonder-disc