I also don’t understand why you can transfer a user ID via “assigned_users” when creating a new review, but this is not automatically transferred to the “posts” table as the id for the “post_author” field. I think that would make perfect sense, wouldn’t it ?!
No.
1. The post_author is the person who created the post (or review in this case). There can only be one post author!
2. The assigned_users is the user (or users) that the review has been assigned to after it was created. A review may be assigned to multiple users, posts, and categories.
For example, you may run a hair salon and want to assign review to each of the hair stylists who are also users on your website. The hair stylist is not the author of the reviews, the reviews have simply been assigned to them.
-
This reply was modified 4 years, 11 months ago by
Gemini Labs.
Thread Starter
knubew
(@knubew)
Okay, I understand. Thank you.
But I think I have to investigate my enviroment more, because I the filtering has a weird behaviour and it really does not look like your screenshot. Maybe this is caused by entries in my function.php. When I know more, I’ll get back to you.
How does your “All Reviews” page look?
To access the screen options to enable the filters, you need to click the “Screen Options” tab on the top-right.

Also, make sure you are using the latest version of Site Reviews.
Thread Starter
knubew
(@knubew)
Hello,
for testing I’ve deleted nearly all entries in the function.php of my child theme and also disables W3C caching, but no filtering drop down boxes are offered on the screen. Also after updating to V 5.12.5 nothing has changed.
Screenshot Site Reviews V 5.12.2
Screenshot Site Reviews V 5.12.5
Maybe there is a conflict with one of your active plugins. You may need to try performing steps 3 and 4 from the “Basic Troubleshooting Steps” to track it down:

It should look like this: https://i.imgur.com/i43spB6.mp4
-
This reply was modified 4 years, 11 months ago by
Gemini Labs.
Thread Starter
knubew
(@knubew)
Ok, I’ll try this and come back with the results.
Thank you so far.
Thread Starter
knubew
(@knubew)
Here are my results…
Performed Step 3:
Deactivated my Avada Theme and testet with the standard themes “Twenty Twenty” and also with “Twenty Twenty-One”.
a) Activation Filter “Assigned Posts” works and the drop down is displayed.
b) Activation Filter “Assigned USER” does NOT work and NO drop down is displayed.
c) Activation Filter “Category” does NOT work and NO drop down is displayed.
d) Activation Filter “Rating” works and the drop down is displayed.
Performed Step 4:
My Avada Theme was still deactivated. Testet with the standard themes “Twenty Twenty” and also with “Twenty Twenty-One” and ALL PLUGINS DEACTIVATED (except Site Review Plugin). Absolutely the same results.
a) Activation Filter “Assigned Posts” works and the drop down is displayed.
b) Activation Filter “Assigned USER” does NOT work and NO drop down is displayed.
c) Activation Filter “Category” does NOT work and NO drop down is displayed.
d) Activation Filter “Rating” works and the drop down is displayed.
I think the reason why the “Assigned Filter” does not work could be, that there is no entry in the “glsr_assigned_users” table. But the “Category” filter should be displayed, when it’s activated in the screen options.
I have no idea, what’s going on.
Oh, okay I see what is happening.
If your reviews have not been assigned to any user then the assigned_users filter will not display. The same goes for the assigned_posts filter. And if you have no categories (or have not assigned any reviews to them), the category filter will not display either.
This is intentional.
The reason why the filters are not hidden in Screen Options when they cannot be displayed is because keeping a filter enabled will make it appear once there are options available to filter by.
However, I probably should add some text description text to avoid confusion like this:

Thread Starter
knubew
(@knubew)
If your reviews are not assigned to any user then the assigned_users filter will not display.
Okay, that’s logical.
And if you have no categories, the category filter will not display either.
But I HAVE categories and cannot filter them!
But have you assigned any of the reviews to your categories?

If you have assigned reviews to your categories, the categories should also be visible in the categories column of the reviews table:

If you have assigned reviews to your categories and the categories can be seen in the categories column on the reviews table but the category filter is still not visible, then you may need to run the “Reset Assigned Meta Values” tool to fix it:

-
This reply was modified 4 years, 11 months ago by
Gemini Labs.
Thread Starter
knubew
(@knubew)
I’m sorry, but “Reset Assigned Meta Values” did not bring up the “Category” filter drop-down.
In my posted screenshot https://imgur.com/af0Hfrm you can see, that there is a category (“Kategorie” in German) with the name “hc386” The “term_id” for this category is stored in the “glsr_assigned_terms” table correctly (along with the correct “rating_id”) and it’s corresponding to the entry in the standard WP “terms” table. But although the display option “Categorie” is checked, no filter drop-down is diplayed.
Don’t know, if this important?!
I just saw, that in your screenshots is an additional filter option “Form”. I cannot see the filter option “Form” on my screen.
Actually all plugins are still disabled (except SR plugin) an the “Twenty Twenty” theme is activatet.
The Form filter is only available if you are using the Review Forms add-on.
What happens when you approve the review and refresh the page?
Thread Starter
knubew
(@knubew)
Wow … I found the reason !!!
The “Category” only works, if a review is appoved. But that’s really not good. I should also work for not approved reviews.
Thread Starter
knubew
(@knubew)
Sorry, did not see your last post and had the same idea. :-))