Code: Select all
<<LIST_LINE(Client.Children,’ORDER BY Child.FirstName DESC‘,‘ ‘,’,’,‘FirstName’, ‘LastName’, ‘Age,#’)>>
Code: Select all
LIST_LINE(Client.Children,'ORDER BY Client.Name DESC',',',', ','FirstName', 'LastName','Age')
1. part of the problem is that the Docs tradiationally have bad Typos - which cause frustration when you copy/paste code and it won't event syntax check. then there's the issue with the ` marks vs '
2. I don't think thats an issue here. I was using the online tool hint (tap F4) - this example doesn't even make sense. Why would you generate this long string of each of the kids, sorted by the name of mother or father (Client.Name is not even a field in the Client.Children table_? UNLESS, the word Children is meant to mean "child recs of a parent record" and not actual biological units and its not meant to be a real example, only figurative. I dunno.
In either case this is wrong... and I can't figure it out.
This example is supposed to print a list of kids... all the kids that are in a reference table (Children) for a given Client record.
3. this COULD be a possibility:
Code: Select all
LIST_LINE(Client.pm_Children,'ORDER BY Client.pm_Children.FirstName DESC',',',', ','FirstName', 'LastName','Age')
b) changed to Client.pm_Children.FirstName because you want the list of kids' names sorted
4. This works, but the customer is going to ask "Why are they not in order?"
My list came out: SALT LAKE CITY, MACON, ATLANTA, PITTSBURGH, PHILADELPHIA
Code: Select all
RegularUser.CanOrderFor = LIST_LINE(RegularUser.pm_OrderAffils ,',',', ','ShortName')
Code: Select all
RegularUser.CanOrderFor = LIST_LINE(RegularUser.pm_OrderAffils, 'ORDER BY RegularUser.pm_OrderAffils.ShortName ASC' ,',',', ','ShortName')
Which isn't even sorted by ID. this is from Tomcat output after the SAVE: Mast_Cust:200078@PHILADELPHIA|Mast_Cust:200079@PITTSBURGH|Mast_Cust:200068@MACON|Mast_Cust:200086@SALT LAKE CITY|Mast_Cust:200083@RICHMOND
Macon shud be in front if its by ID, and its not Alpha sort. Doesn't really matter what it is, its NOT what was specified.
5. So, last resort, try the QUERY option... because in the Query I could specify an ORDER BY - I'll get this sucker !!!!
<testing now>
jaymer...