How to delete system queries in Data Explorer?

You can now “delete” all queries, including system ones. The delete button’s functionality will be same from the user’s perspective, but will only soft delete (hide) queries. There are also rake tasks available if you ever want to:

  • see which queries are hidden
rake data_explorer:list_hidden_queries
  • hide visible queries by ID (one or multiple)
rake data_explorer[id]
rake data_explorer[id1,id2,id3]

rake data_explorer[1]
rake data_explorer[-1,2,-3]
  • unhide hidden queries by ID (one or multiple)
rake data_explorer:unhide_query[id]
rake data_explorer:unhide_query[id1,id2,id3]

rake data_explorer:unhide_query[1]
rake data_explorer:unhide_query[-1,2,-3]
  • hard delete hidden queries by ID (one or multiple)
rake data_explorer:hard_delete[id]
rake data_explorer:hard_delete[id1,id2,id3]

rake data_explorer:hard_delete[1]
rake data_explorer:hard_delete[-1,2-3]

https://github.com/discourse/discourse-data-explorer/commit/dcfb92d7f895bf749cbe962997a15d2961d2272f

4 Likes