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

확인되지 않은 체크박스가 있는 모든 게시물을 추출하는 SQL 쿼리

커뮤니티 구축 데이터 및 보고

JammyDodger 1월 15, 2024, 7:22오전 4

맞아요.

다만 raw 대신 cooked를 사용하면 아이콘으로 변환되는 것을 볼 수 있습니다. 다만 그렇게 하면 검색이 더 쉬울지는 확실하지 않네요?

글		댓글	조회수
Checkbox for 'Check all' in category UX	3	1135	11월 18, 2016
User-posted code blocks in a category Data & reporting sql-query	3	368	5월 13, 2024
Getting All Posts for a Given Category ID Matching Certain Parameters Data & reporting sql-query	2	131	3월 17, 2025
Amend badge query to include Unlisted topics? Data & reporting sql-triggered-badge	1	177	12월 11, 2019
Query Topics with Category Expert posts? Data & reporting data-explorer , category-experts	2	141	4월 22, 2025

확인되지 않은 체크박스가 있는 모든 게시물을 추출하는 SQL 쿼리

Related topics