Finding communication logs
In the Planon relational database, communication logs are stored differently than in the data lake.
In the relational database, all communication logs are stored in one table: PLN_COMLOG
The link between the business object (e.g. Order X) and the comlogs of that order, are stored in the table
PLN_COMLOGBUSINESSOBJECT table (apart from Assets, see below).
This intermediate table has three important fields:
• A reference to the comlog object in PLN_COMLOG
• A reference to the BO definition in PLN_BASEBODEFINITION, so that we know to which BO type the comlog belongs.
• A reference to the actual BO, in this case Order X.
Instead of having this intermediate table, the data lake stores the communication logs in a table per BO definition, they are named CommunicationLog<BOname>.
For assets, the intermediate table is in PLN_COMLOGASSETS and the comlogs in the data lake are in CommunicationLogAsset.