When activities crow to large, the behavior of it cannot be called stable!
Saving an entry can result in losing data.
IBM made a statement on this behavior and let us know that there is a maximum.
In IBM Connections, it is possible to add content to an activity either in the form of an entry, to-do, section, etc. Internally, each of these types of items is classed as a node.
See full article: http://www-01.ibm.com/support/docview.wss?uid=swg21659487
In this article you can see a script to determine the amount of nodes in a particular Activity.
But what if you want to know what the status is for ALL Activities in your Connections environment?
I created this script for showing ALL Activities and it’s amount of nodes:
SELECT OA_NODE.ACTIVITYUUID ActivityUID, COUNT(OA_NODE.NODEUUID) Total, max(OA_NODE2.NAME) Description FROM ACTIVITIES.OA_NODE OA_NODE join (select NAME, ACTIVITYUUID from ACTIVITIES.OA_NODE OA_NODE2 where OA_NODE2.PARENTUUID is null) OA_NODE2 on OA_NODE.ACTIVITYUUID = OA_NODE2.ACTIVITYUUID WHERE OA_NODE.ISDELETED = 0 AND OA_NODE.ISHIDDEN = 0 AND (NOT OA_NODE.NODETYPE = 'activities/activitylink+template') AND (NOT OA_NODE.NODETYPE = 'application/activitynode+template') AND OA_NODE.NODEFAMILY != 2 group by OA_NODE.ACTIVITYUUID order by Total desc
Visits: 199