Hi,
This is a repost of : http://www.awareim.com/forum/viewtopic.php?f=1&t=7931
Basically if you want to have a string composed from multiple attributes you can use LIST_LINE function (find in user guide)
From this:
you can have this:
attribute = " Loading 1, Loading 2, Loading 3, Loading 4, Unloading 1, Unloading 2, Unloading 3"
cheers,
ONE String from multiple attributes
ONE 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: ONE String from multiple attributes
Hi,
@Support
How LIST_LINE selects the order of displaying attributes? Can we select the order ?
thank you
@Support
How LIST_LINE selects the order of displaying attributes? Can we select the order ?
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
Re: ONE String from multiple attributes
From the User Gide:How LIST_LINE selects the order of displaying attributes? Can we select the order ?
1) Identifier of the list or a string identifying the query (either Rule Language string or the name of the existing query).
So all you have to do is specify a query that has sort criteria included.
Tom - V8.8 build 3137 - MySql / PostGres