寻找在特定时间范围内创建的帖子

文档 使用Discourse
,
1

:bookmark: This guide explains how to use Discourse’s search functionality to find posts created within a certain timeframe.

:person_raising_hand: Required user level: All users

Discourse’s search interface allows you to scope your searches to specific date ranges using the before and after search clauses. This feature can be particularly useful when you need to find posts from a certain period or within a specific timeframe.

Using the before and after clauses

The before and after clauses accept the following date formats:

  • Full date (YYYY-MM-DD)
  • Name of month
  • Day of week

Here are some examples to help you understand how to use these clauses:

  1. before:june hashtag

    • This will find posts with the term “hashtag” that were created before last June.

  2. before:2014 category:bug order:latest

    • This search will return posts in the “bug” category created before 2014, ordered by the most recent first.

  3. after:friday broken

    • This will find posts containing the word “broken” that were created after last Friday.

  4. after:2016-01-12 before:2016-01-20 happy

    • This search will return posts containing the word “happy” that were created between January 12, 2016, and January 20, 2016.

  5. after:june before:july in:first composer

    • This will search for the word “composer” in the first post of topics created between last June and last July.

  6. after:10 before:8 thing

    • This search will find posts containing the word “thing” that were created between 8 and 10 days ago.

Important notes

  • All dates are in UTC (Coordinated Universal Time).
  • The search uses the beginning of the day (00:00:00 UTC) as the start time for any period.
  • The filter applies to the created_at date of posts, not the date a topic was created.
  • If you need to filter based on topic creation date, use the in:first clause in your search query.

Limitations

Currently, the search function does not support sub-day resolution without specifying a full qualified date. For example, searching for posts that are at least 2 hours old using before:2h or before:120m is not possible.

:bulb: If you need more precise time-based filtering (e.g., posts older than 2 hours), consider using a Data Explorer report. This can be especially useful for support teams who need to give community members a chance to answer questions before intervening.

Last edited by @hugh 2024-07-02T09:45:57Z

Last checked by @hugh 2024-07-02T09:46:04Z

Check documentPerform check on document:
13 个赞
6

after: 和 before: 搜索可用的单位是什么？我看到单位默认为天，我们可以在不指定完整限定日期的情况下获得亚日分辨率吗？

我的具体用例：我希望返回至少 2 小时前的帖子。我打算使用 in:first 来获取 2 小时前创建的主题。

我尝试了 before:2h、before:120m 和 before:02:00:00，但它们都不起作用。

原因：我们的支持团队希望在社区成员有机会回答问题之前，不要立即介入并尝试解决帮助请求。

1 个赞
7

如果您的支持团队需要不到一天的时间来使用数据探索器报告，那么提供给他们的数据探索器报告可能是更合适的选项。他们可以将该报告添加到其侧边栏，以便随时运行。:+1:

3 个赞