Sort order of records returned?
-
Hey Chester,
I’m wondering what the best method is for sorting a bunch of records returned in the array object, based on the value of a nested property. Been trying with usort and getting slapped on the wrist with
usort() expects parameter 1 to be array, object givenExample object to sort (want to sort based on [“Base”]:
object(AirpressCollection)#1262 (3) { ["query"]=> object(AirpressQuery)#1256 (6) { ["runtime_start":"AirpressQuery":private]=> float(1547532395.5081) ["config":"AirpressQuery":private]=> array(9) { ["name"]=> string(15) "Swellist Config" ["api_key"]=> string(17) "keymmvMkN68FT4bla" ["app_id"]=> string(17) "appuUAwDEe0TcEtwc" ["api_url"]=> string(28) "https://api.airtable.com/v0/" ["refresh"]=> string(2) "30" ["expire"]=> string(5) "86400" ["fresh"]=> string(5) "fresh" ["debug"]=> string(1) "1" ["log"]=> string(73) "/nas/content/live/meetmindfuldev/wp-content/plugins/airpress/airpress.log" } ["parameters":"AirpressQuery":private]=> array(1) { ["filterByFormula"]=> string(15) "{Status}='Live'" } ["properties":"AirpressQuery":private]=> array(1) { ["table"]=> string(10) "Gatherings" } ["relatedQueries":"AirpressQuery":private]=> NULL ["errors":"AirpressQuery":private]=> NULL } ["index":"AirpressCollection":private]=> array(0) { } ["storage":"ArrayObject":private]=> array(8) { [0]=> object(AirpressRecord)#1264 (4) { ["id":"AirpressRecord":private]=> string(17) "rec7sP3ihGHFx9Vn9" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T04:33:18.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(13) { ["Instructions"]=> string(839) "Gather at your favorite book store or library and run the swellist ceremony before continuing, using one of the nicebreaker games. Next, establish a meeting place within the book store where you will meet again in 10 minutes. Next, break out and go hunt for 3-5 of your favorite books. If your group is larger, keep it to 2-3. Meet back at the meeting place in 10 minutes and gather in a circle or at a table with your books. Next, go around the circle and introduce your favorite books one at a time, one book per person. Explain why it's memorable, inspiring, or otherwise important to you. Loop the circle until everyone has introduced their books. If you did it right—others may want to buy the books you're holding! To have this gathering at another location, each person simply brings 3-4 books of their own to the gathering." ["Group Min"]=> int(4) ["Group Max"]=> int(10) ["Teaser"]=> string(113) "Share your favorite books with your new friends, and discover some new and inspiring books to read along the way!" ["Base"]=> string(10) "Book Share" ["Locations"]=> array(5) { [0]=> string(17) "rec7DhGGiQOAa7eyQ" [1]=> string(17) "recXsyW6XJiLHpwzn" [2]=> string(17) "rectjZcT7PsvBaBum" [3]=> string(17) "recDwbkvxR0UnOeVp" [4]=> string(17) "recYmDmZwr54n2sA9" } ["Complexity"]=> int(3) ["Status"]=> string(4) "Live" ["Experiences"]=> array(1) { [0]=> string(17) "rec3dVhHbKfsXibQP" } ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Create Link"]=> string(38) "https://airtable.com/shrSuSqWZtvbDDMfl" ["Name"]=> string(21) "Book Share Gathering" ["Count Scheduled"]=> int(1) } } [1]=> object(AirpressRecord)#1263 (4) { ["id":"AirpressRecord":private]=> string(17) "rec9uyXnjVGw7mDhx" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T04:33:18.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(10) { ["Instructions"]=> string(460) "Gather at the trailhead of a local favorite trail and run the swellist ceremony before continuing. Who doesn’t love a scavenger hunt? This one is really simple: Make a list of items everyone has to find, and the first one to find them all wins! Here’s a list to get you started—but get creative! • Four different shades of green • Something blue • Heart-shaped rock • Piece of litter (Pick it up and carry it out!) • Something made by humans" ["Group Min"]=> int(4) ["Group Max"]=> int(10) ["Teaser"]=> string(37) "Who doesn’t love a scavenger hunt? " ["Base"]=> string(6) "Hiking" ["Sub Activity"]=> string(14) "Scavenger Hunt" ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(31) "Hiking Scavenger Hunt Gathering" ["Count Scheduled"]=> int(0) } } [2]=> object(AirpressRecord)#1265 (4) { ["id":"AirpressRecord":private]=> string(17) "recIe3Cs2Uwd5OA6Z" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T04:33:18.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(11) { ["Instructions"]=> string(310) "Each person bring clean goods they're prepared to give away, in gently used condition, and an extra tote bag for taking items home. The gatherer hands out tokens (use whatever you like) to each person according to how many items they brought. Sort the group in order of shopping first to last in some way. " ["Group Min"]=> int(8) ["Group Max"]=> int(16) ["Teaser"]=> string(91) "Gather friends―and their excess stuff―for this thrifty get-together, and start trading." ["Base"]=> string(13) "Clothing Swap" ["Sub Activity"]=> string(9) "For Women" ["Locations"]=> array(1) { [0]=> string(17) "recYmDmZwr54n2sA9" } ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(33) "Clothing Swap For Women Gathering" ["Count Scheduled"]=> int(0) } } [3]=> object(AirpressRecord)#1266 (4) { ["id":"AirpressRecord":private]=> string(17) "recNgp5CFmPdgoc4T" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T04:33:18.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(8) { ["Instructions"]=> string(418) "Gather at a local tea house and run the swellist ceremony before continuing. Next, order an array of teas with your group and sit, sniff, and sip! (Example activity-specific content) How to taste tea: Deep inhalations: this is when you hold the brew as close to your nose as possible and take a deep breath. Dog action: this is when you take rapid, shallow inhalations through the nose, rather like a panting dog." ["Group Min"]=> int(4) ["Group Max"]=> int(12) ["Base"]=> string(11) "Tea Tasting" ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(22) "Tea Tasting Gathering" ["Count Scheduled"]=> int(0) } } [4]=> object(AirpressRecord)#1267 (4) { ["id":"AirpressRecord":private]=> string(17) "recVoLv6lbMk9leHu" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-14T17:07:06.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(12) { ["Instructions"]=> string(615) "The idea is to complete a task at hand when you bowl a specific number. If there is 1 pin remaining after you bowl: - Introduce yourself to a new person/talk with someone you haven't yet. If you bowl 2 gutter balls: - What are you most proud of that you completed last week? last month? last year? Share with another person before your next turn. Spare: After each round of bowling (usually you will complete 2-3 rounds within several hours, gather and share the answer to the question that corresponds with your score. Round 1 0 - 50: 50-100: 100- 150: 150+: Round 2 0 - 50: 50-100: 100- 150: 150+: " ["Group Min"]=> int(5) ["Group Max"]=> int(16) ["Teaser"]=> string(37) "Get to know new friends while Bowling" ["Base"]=> string(7) "Bowling" ["Complexity"]=> int(2) ["Requires"]=> string(104) "Potentially book lanes at a bowling alley Reference the rules. Potentially have rules written on board. " ["Status"]=> string(4) "Live" ["Experiences"]=> array(1) { [0]=> string(17) "recJZaSgoJtZLlobA" } ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(18) "Bowling Gathering" ["Count Scheduled"]=> int(1) } } [5]=> object(AirpressRecord)#1268 (4) { ["id":"AirpressRecord":private]=> string(17) "recbEnaXlFZy3OcVH" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T05:00:36.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(12) { ["Instructions"]=> string(980) "Gather at the trailhead of a local favorite trail and run the swellist ceremony before continuing. • Everyone is looking to find the same objects, but only one person can claim each sighting. • If you come across a hiker wearing blue shorts (or a squirrel, a stream, etc) the player who sees the object first should say, “BINGO! Blue shorts!” You must say BINGO first! • No one else can claim those blue shorts. They must spot and call out other blue shorts. • If you find a group of something, like a group of several squirrels, that sighting counts as only one squirrel. Only one person can claim squirrels; everyone else must find another squirrel or group of squirrels. • The first person to find and call “bingo” for all of the objects chosen by the group wins. • Make sure the objects you choose are neither too rare nor too common. If you’re trying to find a tree while on a hike, the game will end instantly. Try finding a birch tree or a dead tree." ["Group Min"]=> int(4) ["Group Max"]=> int(10) ["Teaser"]=> string(32) "BinGO OUTSIDE and play, will ya?" ["Base"]=> string(6) "Hiking" ["Sub Activity"]=> string(5) "Bingo" ["Locations"]=> array(1) { [0]=> string(17) "recM8lyZR1oqbmWpe" } ["Complexity"]=> int(3) ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(22) "Hiking Bingo Gathering" ["Count Scheduled"]=> int(0) } } [6]=> object(AirpressRecord)#1269 (4) { ["id":"AirpressRecord":private]=> string(17) "recqx5kuTJB52d7mB" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T04:33:18.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(9) { ["Group Min"]=> int(4) ["Group Max"]=> int(10) ["Base"]=> string(12) "Volunteering" ["Sub Activity"]=> string(14) "At Food Pantry" ["Locations"]=> array(1) { [0]=> string(17) "recZne8dndh6jcoge" } ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(37) "Volunteering At Food Pantry Gathering" ["Count Scheduled"]=> int(0) } } [7]=> object(AirpressRecord)#1270 (4) { ["id":"AirpressRecord":private]=> string(17) "reczGNiPLQNVe7Q5z" ["createdTime":"AirpressRecord":private]=> string(24) "2019-01-11T16:14:03.000Z" ["collection":"AirpressRecord":private]=> *RECURSION* ["storage":"ArrayObject":private]=> array(8) { ["Group Min"]=> int(4) ["Group Max"]=> int(16) ["Base"]=> string(12) "Volunteering" ["Sub Activity"]=> string(17) "At Animal Shelter" ["Status"]=> string(4) "Live" ["Image"]=> array(1) { [0]=> array(6) { ["id"]=> string(17) "att8rQvA6L6C6AHJ3" ["url"]=> string(78) "https://dl.airtable.com/.attachments/e30123e67a4ca4c8cff6c2f3d2d4c4b3/52f09da8" ["filename"]=> string(40) "Screen Shot 2019-01-14 at 3.39.57 PM.png" ["size"]=> int(4628) ["type"]=> string(9) "image/png" ["thumbnails"]=> array(3) { ["small"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/c8cf0738841133d1d51191bfb143418f/fccd1102" ["width"]=> int(56) ["height"]=> int(36) } ["large"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/cf08ce1aad7e8656386e26b51c1afab0/01ae2204" ["width"]=> int(523) ["height"]=> int(334) } ["full"]=> array(3) { ["url"]=> string(87) "https://dl.airtable.com/.attachmentThumbnails/802fe18d6353f992fbfee2f6ad6d4231/7a78c719" ["width"]=> int(523) ["height"]=> int(334) } } } } ["Name"]=> string(40) "Volunteering At Animal Shelter Gathering" ["Count Scheduled"]=> int(0) } } } }Is there a way to sort the records in Airpress?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Sort order of records returned?’ is closed to new replies.
