Sorting Deep Nested Arrays
Brahmanathswami
brahma at hindu.org
Tue Dec 3 21:19:24 EST 2013
I have a deep nested array that I want to push out to a table.
It needs to be ordered/sorted by the "start_date" which is data the
lies "deep down" at the "end" of the levels.
The incoming data is from MySQL and my query sorts the data, but then
after poking this into an array the sort is lost.
This is actually being done in RevIgniter, but I still think it's a
generic LiveCode use case regardless of context.
put empty into tBuf
repeat for each key tE in gData["task-hours"]["entries"]
put gData["task-hours "]["entries"][tE] into tR
put "<tr><td class='border'>"&tR["start_time"]&"</td><td
class='border'>"&tR["project"]&"</td><td
class='border'>"&tR["task"]&"</td><td class='description
border'>"&tR["description"]&"</td><td
class='border'>"&tR["budget"]&"</td><td class='aRight
border'>"&tR["amount"]&"</td></tr>" after tBuf
end repeat
return tBuf
OK... let's forget about the mark up...
For each key "tE" in this array
gData["payment"]["entries"][tE]
We have a value that is another array with keys
start time
project
task
description
budget
amount
real data/values looks like
2013-07-01 06:00:00 some task A description GKWeb 12:04:00*
*I want to sort these from the outset by the start date.
Is there a way?
Multi-level arrays are very cool, but a bit labyrinthine to the
point of being so opaque they start to be black boxes!
Swasti Astu, Be Well!
Brahmanathaswami
More information about the use-livecode
mailing list