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
STRING - from multiple attributes
STRING - from multiple attributes
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Re: STRING - from multiple attributes
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
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
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
[SOLVED] STRING - from multiple attributes
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
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
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42