Continuing the discussion from Topic Checkboxes - a dynamic check list showing all checkboxes from all topic messages : What would be an SQL query to extract all posts with unchecked checkboxes in a particular category, including excerpts (i.e. the paragraph that contains that checkbox)?

Something like that? -- [params] -- int_list :categories SELECT p.id post_id, t.id topic_id, c.id category_id, (regexp_matches(p.raw, '\[\s\]\s*[^]\r\n]+', 'g'))[1] AS html$excerpt FROM posts p JOIN topics t ON p.topic_id = t.id JOIN categories c ON t.category_id = c.id WHERE …

Oh, so are checkboxes just regular text in the message, e.g. [], [ ], [*] etc?

That’s right. :+1: [圖片] Discourse Checklist Once enabled, you can add checklists to your posts by typing them in like this: [] or [ ] for an unchecked box [x] for checked box (no fill) [X] for a checked box (with fill) - Permanent option, which can no longer be toggled Though if you use coo…

提取所有具有未选中复选框的帖子的 SQL 查询

社区数据与报告

JammyDodger 2024年一月15日 07:22 4

没错。

不过，如果您使用 cooked 而不是 raw，您会看到它们被转换为图标。我不确定那是否更容易搜索？

話題		回覆	觀看
Checkbox for 'Check all' in category UX	3	1112	2016年十一月18日
User-posted code blocks in a category Data & reporting sql-query	3	323	2024年五月13日
Getting All Posts for a Given Category ID Matching Certain Parameters Data & reporting sql-query	2	113	2025年三月17日
Amend badge query to include Unlisted topics? Data & reporting sql-triggered-badge	1	172	2019年十二月11日
Editable checklist of options Support	3	1040	2021年一月31日

提取所有具有未选中复选框的帖子的 SQL 查询

相關主題