How to view a task from Review in Jira?

Question

Project management

Hello.
I closed the task in fat, pointed it to "review", but I forgot to look there, and I can't find the task.
Can I somehow see the tasks from the review if I am a developer here, and I don’t have admin rights here and all that?
I'm attaching a photo:

Answer 1

Good afternoon!
1. You can check via search :)
https://confluence.atlassian.com/jirasoftwarecloud...
https://www.atlassian.com/blog/jira-software/jql-t...
2. You can map in kanban board
Sincerely,
Gonchik Tsymzhitov

Answer 2

SELECT COUNT(*) as count, status FROM users WHERE status = %status_id%

group by is an expensive operation
to further parse the EXPLAIN post of a query
www.sitepoint.com/using-explain-to-write-better-my...
IMO putting a trigger on a table with a lot of updates is not good

Answer 3

Is the table indexed by status?

Answer 4

count довольно дорогая операция.
Сделайте отдельную таблицу для аггрегированных данных: status tinyint, count int. Поддерживать актуальность данных пачкой триггеров: на insert увеличиваете счётчик нужного status, на update уменьшаете OLD.status и увеличиваете NEW.status, на delete уменьшаете status.