Jump to content

Why is member search count different than member widget count? Which is correct?


Recommended Posts

Posted

Is "Allow filtering by this group?" disabled on group(s) which are the only group for members? If so, that would be a correct count there.

Posted (edited)
4 hours ago, Jim M said:

Is "Allow filtering by this group?" disabled on group(s) which are the only group for members? If so, that would be a correct count there.

I have 1 group of about 400 that are not allowed to be filtered. However, I am missing about 10K members versus widget count.

I think members who are deleted aren't recalculated and deducted from the widget count is my guess

Edited by SJ77
Posted (edited)
46 minutes ago, SJ77 said:

I think members who are deleted aren't recalculated and deducted from the widget count is my guess

The widget count is just a SQL query - it's not a figure that is recalculated as and when something is done:

/* fetch only successful registered members ; if this needs to be changed, please review the other areas where we have the name<>? AND email<>? condition */
$where = array( 'completed=?', true );
/* Member count */
$stats['member_count'] = \IPS\Db::i()->select( 'COUNT(*)', 'core_members', $where )->first();

Which is:

SELECT count(*) from core_members WHERE completed = TRUE;

Got a tonne of validating members?

Maybe show what search criteria was used for the search result? (To be clear how you got there)

 

Edited by Nathan Explosion
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...