STRING - from multiple attributes

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

STRING - from multiple attributes

Post by 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
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: STRING - from multiple attributes

Post by 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
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

[SOLVED] STRING - from multiple attributes

Post by 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
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Post Reply