Hi @Wendy_S
I totally agree that there should be an easier way to sift through everything that has been unmoderated, but unfortunately there isn't a cleaner way to do this.
@TedV has provided the easiest way that I can think of which is using the API to grab the results and then you can click on the messages by adding view_href to the SELECT query.
You might find this more beneficial: https://h30434.www3.hp.com/api/2.0/search?q=SELECT%20id,view_href,subject,author.login%20FROM%20messages%20WHERE%20moderation_status%20=%20%27unmoderated%27
To make this cleaner rather than having the encoded characters there the query is:
SELECT id,view_href,subject,author.login,board.id FROM messages WHERE moderation_status = 'unmoderated'
As you can see the modified query is looking for:
- ID of the message.
- View_href which translates to the URL of the message.
- Subject of the message.
- Author.login which translates as the username.
- Board.id which is the board where it's located.
I hope this is useful for yourself and trying to find out what hasn't been moderated in your community.
Also in regards to your comment about https://prnt.sc/u9fbeq the view. That is correct, the results output in JSON format.
If your browser displays the JSON in raw format which yours did you can download an extension such as https://chrome.google.com/webstore/detail/json-viewer/gbmdgpbipfallnflgajpaliibnhdgobh for chrome or https://addons.mozilla.org/en-GB/firefox/addon/jsonview/ for firefox.
Do let me know if you need assistance with the JSON output and I'll be happy to help!
... View more