# Dubbele data explorer sleutel blokkeert rebuild

**URL:** <https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375>\
**Category:** Product Support\
**Created:** [28 augustus 2020 om 18:38 UTC](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375 "2020-08-28T18:38:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)\
**Post date:** [28 augustus 2020 om 18:41 UTC](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375/2 "2020-08-28T18:41:19Z")

</div>

Drop into psql, and run:

```plaintext
     SELECT
          (replace(key, 'q:',''))::integer,
          value::json->>'name',
          value::json->>'description',
          value::json->>'sql',
          CASE WHEN (value::json->'created_by')::text = 'null' THEN
            null
          WHEN (value::json->'created_by')::text = '""' THEN
            null
          WHEN (value::jsonb ? 'created_by') THEN
            (value::json->>'created_by')::integer
          ELSE
            null
          END,
          CASE WHEN (value::json->'last_run_at')::text = 'null' THEN
            null
          WHEN (value::json->'last_run_at')::text = '""' THEN
            null
          ELSE
            (value::json->'last_run_at')::text::timestamptz
          END,
          CASE WHEN (value::json->'hidden')::text = 'null' THEN
            false
          WHEN (value::jsonb ? 'hidden') THEN
            (value::json->'hidden')::text::boolean
          ELSE
            false
          END,
          '2020-08-28 17:54:07.368132',
          '2020-08-28 17:54:07.368132'
        FROM plugin_store_rows
        WHERE plugin_name = 'discourse-data-explorer' AND type_name = 'JSON' AND (replace(key, 'q:',''))::integer < 0;

```

---

_[View the full topic](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375)._
