Hoekstra_VFZ
3 years agoAdvisor
I was struggling a bit with getting links to the last reply directly from home and category pages. I used the following query in the macro of the message tile.
SELECT view_href, author.login, author.view_href, id from messages where topic.id = '${msg.id}' AND id > '${msg.id}' ORDER BY id DESC LIMIT 1
This gives the direct url, and the username and profile url of the latest reply (including nested replies). And it resolves to 0 if a topic does not have replies.
How dit you solve this Claudius? I really like the way Dataiku presents this info.
Related Content
- 3 years ago
- 2 years ago
- 3 years ago
- 2 years ago