Solved Kunena 6.3.0-BETA2-DEV User incorrect filter options

When I select the users in Kunena 6.3.0-BETA2-DEV with the J5 changes in the dashboard, all users are displayed.
If I select "Show banned" in the filter options, no more users are displayed. If I also select "Show moderator" and/or "Show activated" and/or "Show signature", no users are displayed.
If I select "Show moderator" in the filter options, all moderators are displayed. If I also select "Show signature", only moderators with a signature are displayed.
If I also select "Show activated", only moderators with a signature are displayed. If I switch "Show signature" to No, the active users, the banned users and the moderators without a signature are displayed, regardless of whether "Show banned" is set to Yes or No.

Gindi
 

Hi Gindi, by coincidence stumbled on this topic.
Can you check / test this: github.com/Kunena/Kunena-Forum/pull/9632

I have updated the files "filter_users.xml" and "UsersModel.php" from commit 00564cb.
Now when I select "Show banned" in the filter options, it shows an active user with signature who is not banned.
 If I also select "Show moderators", no more users are displayed. The same happens if I also select "Show activated" and/or "Show signature".

If I select "Show moderators" in the filter options, all moderators are displayed. If I also select "Show signature", only moderators with a signature are displayed.
If I also select "Show activated", only moderators with a signature are displayed. If I set "Show signature" to No, only moderators will be displayed.

If I only set "Show signature" to YES, the active users, the blocked users and the moderators with a signature are displayed, if I also set "Show activated" to YES, only the activated users and moderators with a signature are displayed, but no blocked users.

If I only set "Show activated" to YES, all active users and moderators are displayed. If I also set "Show signature" to YES, only the active users and moderators with a signature are displayed. If I now also set "Show moderators" to Yes, only the moderators with a signature are displayed.

gindi
 

Hi, do you have access to your database (via hosting panel)? If so can you check in table kunena_users what the banned value is for a user that is NOT banned. is it 1000-01-01 00:00:00 or 0000:00:00 00:00:00 (or somthing else).

Now when I select "Show banned" in the filter options, it shows an active user with signature who is not banned.

All banned users are displayed, including those who were once banned and have been unbanned again.

If I also select "Show moderators", no more users are displayed.

This is also correct, because with your selection "Banned + Moderator" only banned moderators should be displayed.

The same happens if I also select "Show activated" and/or "Show signature".

The same applies here. "Banned + Activated" There is no such thing as a banned user who is active at the same time. So the result in the filter is also correct.

If I select "Show moderators" in the filter options, all moderators are displayed. If I also select "Show signature", only moderators with a signature are displayed.

That is also correct. Everything you have selected in the filter must always apply and be present in the result.

Example:
Moderator + Banned + Signature
As a result, you will only see moderators who are (or have been) banned and who have a signature.

I have tested the filters extensively. They all work correctly.

Table jom5_kunena_user
Value is:

---

Name

---

Type -- Null ---Standard                   
7 banned Index - datetime - No - 1000-01-01 00:00:00

is under Indices:
Key name - Type - Unique -- Packed --- Column - Cardinality - Collation - Null
banned --- BTREE -- No

---

No

---

banned --- 4

---

A

---

No

gindi