STRING - from multiple attributes

weblike

Hi,

I have BO.Orders and BO.OrdersLineItems (BO.Orders is owner of BO.OrderLineItems)

Inside BO.OrdersLineItems I have these attributes:

OperationType=Plain Text (options="Loading", "Unloading")
OperationNumber=Number (choices=1,2,3,4)
OperationFull=Plain text, calculated with this rule ->AS_STRING(OperationType+' '+OperationNumber)

As result I will have:
OperationType OperationNumber OperationFull
Loading 1 Loading 1
Loading 2 Loading 2
Loading 3 Loading 3
Loading 4 Loading 4
Unloading 1 Unloading 1
Unloading 2 Unloading 2
Unloading 3 Unloading 3

The result I want is:
In BO.Orders I want to have this attribute "Route" as type text, calculated based on table above:
BOorders.Route = " Loading 1, Loading 2, Loading 3, Loading 4, Unloading 1, Unloading 2, Unloading 3"

I don't know how to put those line items in one row, one after other.
Can anyone give a hint?

Thank you

weblike

I have found this function in USER_GUIDE:

LIST_LINE

Does anyone used it?

Could be used as bellow ?

Attribute = LIST_LINE(BO.Lines,' ', ' ','OperationFull')

Thank you

weblike

Figure it out....
Yes I can confirm that LIST_LINE works.

So. If you have several attributes and you want to put them in one attribute you can use this function.

cheers