Finder not sorting correctly

Status: This content is read-only, or is not open for further replies.

Dannymh

Guest

offline

OP
Dec 11, 2023
0
205

Hi,

I have a custom thread field called "Display order". The custom field is a number , however it looks like it returns as a string in the query, I have tried casting to an integer but nothing seems to work. Essentially the order will look like

1, 10, 11, 12, 13
The finder query
PHP:

Code:

$recent_activities = $this->finder('XF:Thread')
        ->where('user_id', '=', $user->user_id)
        ->where('discussion_type', '=', 'article')
        ->order('CustomFields|ProfileOrder.field_value'...