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.
... View more