How to get journal activities in a report

[wakespirit]

Dear all,

If you look at the TASK table we are able to have a journal of activities displayed in a chronological order.

Question 1 :
Does this activity entry is physical store in a table some where for reporting ?

Question 2 :
Is tehre a way to get the activity journal in a report ?

thanks for your feedback

regards

[Rohit Kaintura]

Question 1 :
Does this activity entry is physical store in a table some where for reporting ? - sys_journal_field

Question 2 :
Is tehre a way to get the activity journal in a report ? - You can make a database view with the target table and journal table(sys_journal_field).

[wakespirit]

How journal_field entry and task activities are linked together ? could not catch the proper link

[Rohit Kaintura · Accepted solution]

I think you are talking about this:

So, it is a activity formatter available out of the box and you can see it in form layout as 'Activities (filtered)'. Let me know if you have any other query.