FuelPHP Forums

Has two tables: users (belongs to) and positions (has many)

I make the jqGrid table on the page and give json data from that query:

$users = Model_Users::query()
    ->related('position')
    ->select('id', 'username', 'email', 'firstname', 'lastname')
    ->order_by($sidx, $sord)
    ->rows_limit($pager->per_page)
    ->rows_offset($pager->offset)
    ->get();

Here I don't select any data for positon, but when I prepare data for json answer I do next:

foreach ($users as $id => $user)
            $result['rows'][] = array(
                'id' => $id,
                'cell' => array(
                    'id' => $id,
                    'username' => $user->username,
                    'email' => $user->email,
                    'firstname' => $user->firstname,
                    'lastname' => $user->lastname,
                    'position' => $user->position->name
                )
            );

It's ok, but when I try to order that column (position), I get the error in SQL query.

I need to set alias for positions.name as position or any other name for order by clause.
How can I do this?
Thank you.