# Data Explorer에서 시스템 쿼리를 삭제하는 방법? **URL:** \ **Category:** UX\ **Tags:** data-explorer, completed\ **Created:** [4월 10, 2020, 8:30오전 UTC](https://meta.discourse.org/t/how-to-delete-system-queries-in-data-explorer/147524 "2020-04-10T08:30:42Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![RickyC0626](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rickyc0626/32/185743_2.png) [@RickyC0626](https://meta.discourse.org/u/RickyC0626)\ **Post date:** [7월 29, 2020, 4:10오후 UTC](https://meta.discourse.org/t/how-to-delete-system-queries-in-data-explorer/147524/8 "2020-07-29T16:10:00Z")
이제 시스템 쿼리를 포함하여 모든 쿼리를 "삭제"할 수 있습니다. 사용자 관점에서는 삭제 버튼의 기능이 동일하게 유지되지만, 실제로는 쿼리를 소프트 삭제(숨김)만 수행합니다. 필요 시 다음 rake 태스크를 사용할 수도 있습니다: - 숨겨진 쿼리 확인 ```plaintext rake data_explorer:list_hidden_queries ``` - ID로 표시 중인 쿼리 숨기기 (하나 또는 여러 개) ```plaintext rake data_explorer[id] rake data_explorer[id1,id2,id3] rake data_explorer[1] rake data_explorer[-1,2,-3] ``` - ID로 숨겨진 쿼리 다시 표시 (하나 또는 여러 개) ```plaintext 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] ``` - ID로 숨겨진 쿼리 하드 삭제 (하나 또는 여러 개) ```plaintext 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] ``` > > > \* FEATURE: Add hide button (toggleable) for all queries (frontend only) > > \* Swi…tches between hide/unhide on click > \* Works almost like the delete button, but toggles between the query's > hidden attribute instead > \* So far this is only a frontend feature, the backend implementation > still needs work > > \* Revert "FEATURE: Add hide button (toggleable) for all queries (frontend only)" > > This reverts commit a8771d2ad57083a91b7130df807fa54c26205d11. > > REVERT: Remove button that hides queries (frontend) > > \* Prepare for migration of old frontend logic to backend > \* We are going to reuse the existing delete button, but change its > backend logic to enable soft deletion. From the user's perspective > nothing will change, but any deletion mistakes can be reverted. > > \* DEV: Hide user queries upon deletion, but keep them in store > > \* Creating a new query will set its hidden attribute to false by > default > \* Deleting a user-made query will not delete it from the store, but > set its hidden attribute to true > \* User queries will not be indexed if they are hidden > \* Undeleting a query will unhide it, and will be indexed > \* Updating a hidden query will unhide it, and will be indexed > > \* SPEC: Add spec for hidden/deleted queries > > \* Hidden queries should not be shown > > \* FEATURE: Add ability to delete/hide system queries > > \* System queries are now able to be deleted from view, but will remain > in the backend for retrieval, if necessary > > \* FEATURE/DEV: Add rake commands for query soft deletion > > \* query:list\_hidden - Shows a list of hidden queries > \* query:hide\_all\[only\_default\] - Hides all queries, w/ boolean arg to > hide only default ones > \* query:unhide\[id\] - Unhides a query by id > \* query:unhide\_all\[exclude\_default\] - Unhides all hidden queries, > w/ boolean arg to exclude default ones > > \* Remove rails loggers > > \* UX/DEV: Update query rake tasks to be more user friendly > > \* Split query:hide\_all\[only\_default\] into two tasks: > \* query:hide\_all - Hides all queries > \* query:hide\_all:only\_default - Hide only default queries > \* Split query:unhide\_all\[exclude\_default\] into two tasks: > \* query:unhide\_all - Unhides all hidden queries > \* query:unhide\_all:exclude\_default - Unhides all non-default > queries > \* Rename file to match task name > > \* UX: query:unhide can accept multiple arguments > > \* Example: rake query:unhide\[-5,-6,-7,3,5,6,-13,-14,-10\] > > \* UX: Update query rake tasks to output cleaner messages > > \* Remove unneeded comment > > \* DEV: Keep only necessary rake tasks, use more specific naming > > \* UX/DEV: Add rake task for hard deletion, better console logs > > \* User is able to hard delete a query only if it is hidden, otherwise > output a message stating so > \* Add commented examples above each task > \* Add rainbow support for more readable console logs > \* Successful messages will display green, failures display red, > additional info displays yellow > \* Separate multiple queries with spaces instead of lines > > \* DEV: Remove rainbow colorizing in console logs > > \* Rainbow is a dependency of rubocop and it may go away in the future > \* Rainbow is only used for dev and test environments > > \* DEV: Add Rails engine to enable rake tasks to be loaded at runtime > > \* DEV: Favor require - load files only if they are not already loaded > > \* SPEC: Add tests for data\_explorer\[id\] rake command > > \* Test if a single query is hidden correctly > \* Expect length of query list to not be modified > \* Expect array of hidden queries to have exactly 1 element > \* Expect that one element to have the same ID as the one invoked to > be hidden > \* Test if multiple queries are hidden correctly > \* Expect length of query list to not be modified > \* Expect array of hidden queries to have the number of elements > equal to the number invoked to be hidden > \* Expect the elements to have the same ID as the ones invoked to be > hidden > \* Test if a query exists in PluginStore > \* Expect query list to be empty > > \* DEV: Clear pre-existing tasks before redefining > > \* This prevents double invocation when user invokes the task once > > \* SPEC: Add tests for unhide\_query rake task > > \* Test if a single query unhides correctly > \* Expect length of query list to not be modified > \* Expect array of hidden queries to have exactly 1 element after > unhiding 1 of 2 queries > \* Expect remaining element to be hidden > \* Test if multiple queries unhide correctly > \* Expect length of query list to not be modified > \* Expect array of hidden queries to have exactly 1 element after > unhiding 3 of 4 queries > \* Expect remaining element to be hidden > \* Test if a query exists in PluginStore > \* Expect query list to not be modified > > \* SPEC: Add tests for hard\_delete rake task > > \* Test if a single query hard deletes correctly > \* Expect length of query list to be shorter by 1 > \* Expect array of hidden queries to have exactly 1 element after > hard deleting 1 of 2 queries > \* Expect 1 remaining hidden element > \* Test if multiple queries hard delete correctly > \* Expect length of query list to be shorter by 3 after hard deleting > 3 of 4 queries > \* Expect array of hidden queries to have exactly 1 element after > hard deleting 3 of 4 queries > \* Expect 1 remaining hidden element > \* Test if a query exists in PluginStore > \* Expect hidden query list to not be modified > \* Test if a query is not hidden > \* Expect query list to not be modified > > \* UX: Favor newline char in place of puts for logs > > \* Condensed console logs to output newline char instead of another puts > statement (reduces number of lines used significantly) --- _[View the full topic](https://meta.discourse.org/t/how-to-delete-system-queries-in-data-explorer/147524)._