Hey there, I’m looking to display something like this on my Wordpress homepage: [画像] I’m using @meglio ’s Twig Anything to do this, which can pull data from any JSON feed. I’ve tried just using https://meta.discourse.org/latest.json , but the issue is that it’s difficult to pull the user avatars, …

You might check out this thread [Superseded] What cool badge queries have you come up with?

Thanks for sharing the link. I just took a look through, and it seems like it is mostly about badges? Is there a specific post in particular that you’re referring to?

No. It’s just a trove of sql examples.

[画像] pfaffman: No. It’s just a trove of sql examples. Badges are granted based on SQL queries typically.

So I spent a few hours this afternoon learning SQL queries. Lol. Here’s where I got: SELECT t.last_post_user_id, ua.custom_upload_id, u.username, u.username_lower, t.title, t.slug, t.id, t.category_id, c.name, c.color, t.posts_count, t.last_posted_at FROM topics t LEFT JOIN categories c ON c.id = t…

Yep, with SQL queries you can extract about any data that you need from Discourse. Re date formatting, I might need to add an ago filter, like this one . Without AGO-ing, you can still format dates with using native date filter . You can also format dates directly in you SQL query .

Wohoo, just figured out how to get the “8 hours ago” using the Twig Syntax: {% set difference = date("now"|date("M j, g:ia T")).diff(date(row[11]|date("M j, g:ia T"))) %} {% set leftDays = difference.days %} {% set leftHours = difference.h %} {% set leftMinutes = difference.i %} {% if leftDays > 1 …

Using @meglio ’s Twig Anything ( https://twiganything.com/ ), on Wordpress.

SQL query in Data Explorer to pull latest topics?

Community Building Data & reporting

pfaffman (Jay Pfaffman) 2017 年 6 月 5 日午後 2:31 7

The "8 hours ago " thing gets done by a rails function. There is probably some function you can find that’ll do that for you.

トピック		返信	表示
Display Data Explorer query results in WordPress (with TwigAnything) Administrators data-explorer , how-to	3	6363	2017 年 12 月 5 日
Discourse AI + Data Explorer? Feature data-explorer , completed , ai , ai-bot	47	4924	2024 年 1 月 11 日
Formatting Data Explorer Table Results Data & reporting data-explorer , sql-tutorial	0	998	2023 年 9 月 5 日
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14215	2025 年 5 月 6 日
Understanding what our users are posting about Data & reporting sql-query	9	446	2024 年 6 月 20 日

SQL query in Data Explorer to pull latest topics?

関連トピック