Error while creating complex-alias in view entity

[su2]

Hello Friends,

I am trying to create a view entity with complex alias using two view-entities.

I have view entity A, View entity B and trying to create a new view entity C from View Entity A & View Entity B.

When I add complex-alias with '+' operator I get the error message.

It shows error for SELECT (C.A.field1 + C.B.field2)..
(the correct syntax is: SELECT (C.A_field1 + C.b_field2))

Does anybody has idea?

I really appreciate the help in advance.

Thank you.
Su-

[David E. Jones-2]

This sounds like a bug where the complex alias code isn't calling the  
column name rewriting code and so isn't replacing the dot with an  
underscore.

I won't be able to look into this today, but maybe later in the  
week... so if anyone beats me to the fun I won't be offended. ;)

-David


On Sep 28, 2009, at 12:04 PM, su2 wrote:

>
> Hello Friends,
>
> I am trying to create a view entity with complex alias using two
> view-entities.
>
> I have view entity A, View entity B and trying to create a new view  
> entity C
> from View Entity A & View Entity B.
>
> When I add complex-alias with '+' operator I get the error message.
>
> It shows error for SELECT (C.A.field1 + C.B.field2)..
> (the correct syntax is: SELECT (C.A_field1 + C.b_field2))
>
> Does anybody has idea?
>
> I really appreciate the help in advance.
>
> Thank you.
> Su-
> --
> View this message in context: http://www.nabble.com/Error-while-creating-complex-alias-in-view-entity-tp25650044p25650044.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[su2]

If its a bug, than is there any other way to add two columns at entity level or in .bsh file?

David E Jones-4 wrote

This sounds like a bug where the complex alias code isn't calling the  
column name rewriting code and so isn't replacing the dot with an  
underscore.

I won't be able to look into this today, but maybe later in the  
week... so if anyone beats me to the fun I won't be offended. ;)

-David


On Sep 28, 2009, at 12:04 PM, su2 wrote:

>
> Hello Friends,
>
> I am trying to create a view entity with complex alias using two
> view-entities.
>
> I have view entity A, View entity B and trying to create a new view  
> entity C
> from View Entity A & View Entity B.
>
> When I add complex-alias with '+' operator I get the error message.
>
> It shows error for SELECT (C.A.field1 + C.B.field2)..
> (the correct syntax is: SELECT (C.A_field1 + C.b_field2))
>
> Does anybody has idea?
>
> I really appreciate the help in advance.
>
> Thank you.
> Su-
> --
> View this message in context: http://www.nabble.com/Error-while-creating-complex-alias-in-view-entity-tp25650044p25650044.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>