You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Last 3 Thread entries

Accepted answer
edited May 7, 2015 2:52PM in Reporting & Analytics for B2C Service 2 comments


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?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!