Add an "unarchive" button on archived dashboards

[jeffwidman]

If someone accidentally clicks "archive", it'd be nice to be able to undo that from the UI

[benmanns]

For people who find this by Googling, here's how I un-archive via updating the DB:

UPDATE dashboards
SET is_archived = false
WHERE slug = 'mycooldashboard';

[gclsoft]

@benmanns How to update the postgress DB in the docker?

root@ubuntu:/home/g/redash# docker exec -it -u 0 b1a2f4fb93e8  bash
bash-4.3# top
Mem: 2909540K used, 140736K free, 22432K shrd, 350008K buff, 936752K cached
CPU:   0% usr   0% sys   0% nic 100% idle   0% io   0% irq   0% sirq
Load average: 0.08 0.11 0.24 2/463 66
  PID  PPID USER     STAT   VSZ %VSZ CPU %CPU COMMAND
   29     1 postgres S     165m   5%   1   0% postgres: postgres postgres 172.19.0.5(33074) idle
   26     1 postgres S     165m   5%   0   0% postgres: postgres postgres 172.19.0.5(33056) idle
   28     1 postgres S     162m   5%   1   0% postgres: postgres postgres 172.19.0.5(33070) idle
   27     1 postgres S     162m   5%   0   0% postgres: postgres postgres 172.19.0.5(33066) idle
   55     1 postgres S     161m   5%   0   0% postgres: postgres postgres 172.19.0.4(33380) idle
   56     1 postgres S     161m   5%   1   0% postgres: postgres postgres 172.19.0.4(33390) idle
   21     1 postgres S     161m   5%   0   0% postgres: autovacuum launcher process   
    1     0 postgres S     160m   5%   0   0% postgres
   19     1 postgres S     160m   5%   0   0% postgres: writer process   
   18     1 postgres S     160m   5%   0   0% postgres: checkpointer process   
   20     1 postgres S     160m   5%   1   0% postgres: wal writer process   
   22     1 postgres S    19664   1%   1   0% postgres: stats collector process   
   61     0 root     S     6212   0%   0   0% bash
   66    61 root     R     1532   0%   0   0% top
bash-4.3# psql
psql: FATAL:  role "root" does not exist
bash-4.3# exit
exit
root@ubuntu:/home/g/redash# docker exec -it -u 0 b1a2f4fb93e8  bash
bash-4.3# sudo psql
bash: sudo: command not found
bash-4.3# psql
psql: FATAL:  role "root" does not exist
bash-4.3# postgres
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise.  See the documentation for
more information on how to properly start the server.
bash-4.3# 

[gclsoft]

root@ubuntu:/home/g/redash# docker exec -it  b1a2f4fb93e8  bash
bash-4.3# psql
psql: FATAL:  role "root" does not exist
bash-4.3# postgress
bash: postgress: command not found
bash-4.3# postgres
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise.  See the documentation for
more information on how to properly start the server.

[RichardLitt]

@gclsoft That does not look like it is related to this issue. Again, please refer this kind of issue to the forum. Thank you!

[jakelodge]

For anyone looking for a solution that's not yet running the latest version, the below workaound seems to do it:

curl -X POST '<baseUrl>/api/queries/<accidentallyArchivedQueryId>?api_key=<userApiKey>' -H 'Accept: application/json' -d '{"is_archived":false}'

Would advise calling and storing GET result first as a backup, since we're POSTing (PATCHing not allowed).
Tested with v10.1.0