CNSAudit_ListSiblingIDs

Description

When CNS Audit audits a record, it does its best to determine which Table Occurrence the record was audited through and uses that Table Occurrence Name and ID to log the audit to the CNS Audit Log table. So, when examining the CNS Audit Log for any changes to a specific table, you'll need to know all the possible Table Occurrence IDs for the table to find all the audits. This function will provide you with a list of all Table Occurrence IDs that are siblings (ie, from the same Base Table) of the Table Name or Table ID you provide. The list returned from this plug-in can easily be used in a relationship as a Multikey to the "Table ID" field of the CNS Audit Log table.

Return Type

Text

Format

CNSAudit_ListSiblingIDs ( TableNameOrID )

Required Parameters

• TableNameOrID
  

  The Table [Occurrence] Name or ID that you want the Sibling IDs of.