Hi Geregor,

My guess would be that out of some reasons some of the views get lost during the Update.
Could you check in your database if the queries you don't see anymore has an entry in the view table in the database.
As example you could use the following SQL-Query to check if the view of a query is missing:

select 
	q.name, 
    case when 
    	v.query_id is null 
    then 
    	'false' 
    else 
    	'true' 
    end as has_view 
from 
	queries as q 
left join 
	views as v 
on 
	q.id = v.query_id 
where 
	q.name = 'NameOfMissingQuery';

Best regards

Tizian

Hi Tizian,

Thank you for your reply! I have tried your suggestion. It seems that the missing queries are still available in the views table.

Here an expample:

openproject=# select id from queries where name = 'MRO';
 id  
-----
 519
(1 row)

openproject=# select * from views where query_id = 519;
 id  | query_id | options | type  |          created_at           |          updated_at           
-----+----------+---------+-------+-------------------------------+-------------------------------
 279 |      519 | {}      | gantt | 2021-04-12 13:16:11.049844+02 | 2021-07-15 15:24:52.325627+02
(1 row)

While executing several select statements and playing around I noticed that some views have type gantt and others have type work_packages_table. So I simply tried to change the type of a missing view and set it to work_packages_table - and there you go - it miraculously reappears! 🤩 

Best regards,
Gregor

Hi Gergor,

In this case the reason why you don't see the Queries anymore is the separation of the gantt chart in an own module:

https://www.openproject.org/docs/release-notes/13-3-0/#separate-gantt-charts-module

The queries with the gantt type are moved to new gannt module and aren't shown in the query section of the workpackages anymore

Best regards

Tizian