timeline updates table

[Everton1878]

Hi,

Which table contains the timeline updates for the calls?

I want to look at the dates and times for each of the updates on a call

thanks,

Pete

[Guest Chaz]

@Everton1878 you'll find the updates in the table h_buz_activities however this also contains workspace posts and timelines for other entities depending on which apps you have available on your instance. You can filter this down per request, by providing the parent activity stream ID stored in h_target.

To find the value for this, you'll need to find the ID of the activity stream from table h_buz_activity_streams where you can match h_owner_ref with a where clause as follows:

WHERE
	h_owner_ref LIKE '%:IN00000001'

 

[Everton1878]

thanks @cchana