Last 3 Thread entries

Content

Hi community :-)

I try to set up a repot with a column which shows the last 3 thread entries.

Unfortunately I cant find a function to achieve this. I used last(threads.note,threads.entered) but this gives me only the last entry. I tried group_concat(threads.note, '\n----------------------\n', threads.entered, DESC)) but this gives me all entries.

I tested some things like if((count(threads.seq)<3),threads.note,(group_concat(threads.note, '\n----------------------\n', threads.entered, DESC))) but unfortunately I dont get what I need.

Any idea how to get the last 3 entries?