Searching for posts created within a specific timeframe

[Discourse]

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

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.

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 document

Perform check on document:

[aidanheerdegen]

after: および before: 検索で利用可能な単位は何ですか？ 単位はデフォルトで日数になるようですが、完全な修飾日付を指定せずに日未満の解像度を取得できますか？

私の具体的なユースケース：少なくとも 2 時間前の投稿を返したいです。 2 時間以上前に作成されたトピックを取得するために in:first を使用するつもりです。

before:2h、before:120m、before:02:00:00 を試しましたが、どれも機能しませんでした。

理由：サポートチームは、コミュニティメンバーがヘルプリクエストの解決に飛び込む前に、質問に答える機会を与えたいと考えています。

[JammyDodger]

データエクスプローラーレポートをサポートチームに提供することで、1日未満で必要な場合に、より適切なオプションとなる可能性があります。チームはそれをサイドバーに追加し、必要に応じて実行できるようにすることができます。