How to sort/order Redbean sharedList

orm, php, redbean

Solution

Despite having read the Redbean documentation many times, I had missed the (very simple) solution.

Prepending the ->with() method applies extra sql to the query. So what I need to do is;

foreach($member->with("ORDER BY position")->sharedQuestion as $question){.......}

and my problem is elegantly solved!

Problem

In my application, member entities choose a from a pre-defined set of question entities. I save and iterate over them as a shared list ($member->sharedQuestion). Now I need to rank them, so I add another column via the link bean (member_question) called 'position'. My question is - can I make redbean retrieve the questions ORDERed by the column 'position'? I currently do a ``` foreach($member->sharedQuestion as $question){.......} ``` I know I could get the array property and run it through a custom sort handler before I start iterating, but that seems expensive. Does anyone know of a Redbean method to append some sql (i.e. "ORDER BY position") to a sharedList for example?

Original source