Not a bug Trouble with XenForo Finder Queries Not Returning Expected Results

[LeeBanks]

Affected version

I'm using XenForo version 2.2.9 when I encountered this issue.

I'm working with the Finder and Entity system in XenForo 2, but I am running into a problem where the results are inconsistent when trying to query multiple rows with custom filters.

Here's the scenario: I need to fetch all users who have been active in the last 30 days and sort them by their message count. However, when applying a custom filter using where and then sorting using order, the results aren't being returned as expected. Some users are missing, and the order doesn't reflect the message count accurately.

Here’s the code I’m working with:

$finder = \XF::finder('XF:User');
$users = $finder->where('user_state', 'valid')
    ->where('last_activity', '>=', time() - (86400 * 30))
    ->order('message_count', 'DESC')
    ->fetch();

I’ve tried using limit(10) as well, but that doesn’t solve the issue. The records returned are not sorted properly, and some users who should be included are being skipped.

Additionally, I’ve used the getQuery() method to inspect the query that is being built and confirmed that the SQL seems fine, but the results still seem incorrect when fetched.

Has anyone encountered this issue or have any suggestions on how I can properly filter and sort users using the Finder system? Should I be looking into using with or another method for this, or is there something I might be missing when chaining the where and order methods?

 

[LeeBanks]

I'm working with the Finder and Entity system in XenForo 2, but I am running into a problem where the results are inconsistent when trying to query multiple rows with custom filters.

Here's the scenario: I need to fetch all users who have been active in the last 30 days and sort them by their message count. However, when applying a custom filter using where and then sorting using order, the results aren't being returned as expected. Some users are missing, and the order doesn't reflect the message count accurately.

Here’s the code I’m working with:

$finder = \XF::finder('XF:User');
$users = $finder->where('user_state', 'valid')
    ->where('last_activity', '>=', time() - (86400 * 30))
    ->order('message_count', 'DESC')
    ->fetch();

I’ve tried using limit(10) as well, but that doesn’t solve the issue. The records returned are not sorted properly, and some users who should be included are being skipped.

Additionally, I’ve used the getQuery() method to inspect the query that is being built and confirmed that the SQL seems fine, but the results still seem incorrect when fetched.
they also helped me alot: www.concretesrichmondva.com
Has anyone encountered this issue or have any suggestions on how I can properly filter and sort users using the Finder system? Should I be looking into using with or another method for this, or is there something I might be missing when chaining the where and order methods?

I’ve also tried clearing the cache and rebuilding the database, but it didn’t seem to fix the issue either. Just wanted to make sure I’m not missing something simple in the code.

 

[Paul B]

You will need to associate your forum user name with your customer account in order to obtain support.