# Exportação de Relatório CSV de Consulta do Data Explorer mostra user\_id enquanto os resultados exibem o nome do usuário

**URL:** <https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019>\
**Category:** Data & reporting\
**Created:** [Dezembro 6, 2024, 8:27pm UTC](https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019 "2024-12-06T20:27:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [Dezembro 6, 2024, 8:33pm UTC](https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019/2 "2024-12-06T20:33:53Z")

</div>

Tente isto:

```plaintext
SELECT u.username, ucf.user_id,
       ucf.value,
       ucf.updated_at AS reltime$time
FROM user_custom_fields ucf, users u
WHERE ucf.name = 'user_field_9'
and ucf.user_id=u.id
AND LENGTH(ucf.value) > 1
ORDER BY ucf.updated_at DESC

```

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-csv-export-reports-user-id-while-results-display-user-name/341019)._