Commmetrics table - column "actiontype"

Hello,

My understanding is that the table Commmetrics tracks the usage of communities in Content Server.

Does anyone know what the column 'actiontype' in this table represents? In my system, this column is usually 1, but sometimes 2 or 3.

Thanks,
Pascal

Find more posts tagged with

Comments

Greg Griffiths

the values are drawn from $spdcommittee.constants, so you can look in there to match what your values are. Hopefully OT will add this to a new version of the Schema Companion - https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=13682418&objAction=Open&nexturl=/knowledge/cs.dll?func=ll&objid=19905386&objaction=browse

Pascal_SSC

Thank you Greg. Could you tell me what is $spdcommittee.constants and how I query it in a livereport? I tried with no success. And note that I don't have access directly to database, only front-end by livereports/webreports.

Thanks,
Pascal

Greg Griffiths

Pascal, these values are constants in the OScript layer, so not in the database and are dependant on which modules you have installed. You may be able to reverse engineer the values by looking at the results of changes you make in the UI.