Product Logo

CNS Audit

An Audit Trail Plug-in for FileMaker Pro.

Functions

CNSAudit_ListSiblingIDs

NameCNSAudit_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 TypeText
FormatCNSAudit_ListSiblingIDs ( TableNameOrID )
Required Parameters
TableNameOrID

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