Show last comment on discussion listing page
We are using the vanilla forum for building our community platform, So in our requirements, we will have a discussion listing page and if the discussion has any comment then we need to show along with it.
So is there any way using which we can introduce "lastcomment" data inside currently provided discussion list data?
We do not want to have extra loops and multiple queries to prepare this data, any way to make use of "join" in existing discussion model?
Any help will be very much appreciated.