답변이 없는 비직원 게시글 보기

[ondrej]

이런 식으로?

데이터 탐색기 쿼리: 답변이 없는 게시물 찾기

다음 주제를 참고했습니다: How to find topics without a reply from someone other than the topic owner? 이 쿼리를 작성했지만 제 경우 문제가 발생합니다. PG::UndefinedTable: ERROR: missing FROM-clause entry for table "t" LINE 31: AND t.category_id = ANY ('{48,23}'::int[]) 쿼리 코드는 다음과 같습니다: -- [params] -- int :months_ago = 1 WITH query_period as ( SELECT date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' as period_start, date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' + …

이 플러그인을 추천합니다

Discourse Data Explorer

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. If you’re looking for examples or support for any custom queries, you can find lots of topics in our #data-reporting category under the sql-query tag. If there’s not one to suit your par…