كيفية إظهار المشاركات غير الموظفين مع صفر ردود

[Vikteur (Viktor)]

مرحباً!

أبحث عن طريقة لعرض جميع المنشورات من الأعضاء غير الموظفين الذين لم يتلقوا أي ردود بعد. هل هناك طريقة للقيام بذلك؟

[ondrej]

شيء كهذا؟

Data explorer query: find posts without replies

Following the topic: How to find topics without a reply from someone other than the topic owner? I created this query, but in my case there is a problem. PG::UndefinedTable: ERROR: missing FROM-clause entry for table "t" LINE 31: AND t.category_id = ANY ('{48,23}'::int[]) Here is the query’ code: -- [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', CURRE…

أوصي بهذا المكون الإضافي

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 pa…

[Benjamin_D (Benjamin Decotte)]

search?q=max_posts%3A1 ممكن ولكنه للأسف لا يبدو أنه يقبل @somegroup كمعامل فقط @anyuser