Filter/sort by boolean not working on large user table
I’m trying to set up a filterable and/or sortable column for my users table, which includes about 35,000 rows. The custom field I’d like to sort/filter by stores a true/false value of 1 or 0/null. I’ve attempted to set it up both as a custom field and as an ACF field.
In both cases, the appropriate values are displayed in the new column, but the filter dropdown never gets past the “Loading values …” state, and attempting to sort by clicking the column heading does have the intended effect. In some cases, attempting to sort or filter has crashed my local server environment. I’ve had no issue doing this on smaller data sets of custom post types.
Are there any best practices I should know about that would help me use Admin Columns effectively with this large set of users?
You must be logged in to reply to this topic.