# 是否可以从 Discourse 后端数据库中提取帖子 URL？

**URL:** https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426
**Category:** Development
**Created:** [2019年九月24日 22:58 UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426 "2019-09-24T22:58:33Z")
**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: [2019年九月25日 01:31 UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426/2 "2019-09-25T01:31:46Z")

</div>

您可以查看 [https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516。](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516%E3%80%82)

如果我的字段名记得没错，URL 格式应为 /t/post.topic\_id/post.post\_number。

---

_[View the full topic](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426)._