Managing activity streams

Activity Streams are used to capture important updates to the data of a data source and later display them.

To view the Activity Streams:

1. From the Navigation menu, under the Developer role group, click Manage Datasources. The list of existing datasources is displayed.

2. On the required datasource, click .The edit page is displayed. Scroll down to the Activity Streams tab.

To add a new activity stream:

1. On the top-right corner of the tab, click . The Activity Streams dialog box is displayed.

2. Enter the details as required.

3. Click Save.

Other actions:

• To delete a record, against the respective activity stream record, click.

• To edit an existing activity stream, against the respective activity stream record, click.

• To refresh the list, on the top-right corner of the tab, click.

• To hide and expand the smart search filter, click.

Access the activity stream:

The defined activity stream can also be accessed from IO_ACTIVITY_STREAMS table from the platform schema or by using IOActivityStreams data source.

You can use the OBJECT_UID, ORG_ID & OBJECT_TYPE columns to filter the data for any particular data stream, as shown below:

SELECT   USER_ID,
   VERB,
   OBJECT_VALUE,
   TARGET_TYPE,
   TARGET_VALUE,
   TARGET2_TYPE,
   TARGET2_VALUE,
   STREAM_DATE
   FROM   IO_ACTIVITY_STREAMS
   WHERE   OBJECT_UID =   'da82dcf6209549ca947f0f95a070476b'
   AND   ORG_ID = 10013
   AND   OBJECT_TYPE =   'PRODUCT'
ORDER   BY   STREAM_ID   DESC