/** * Gets the historical journal for an object from the log database. * Objects will have VirtualAttributes available to lookup login, date, and action information from the journal object. * @param integer intAssetModelId * @return AssetModelCustomFieldHelper[] */ public static function GetJournalForId($intAssetModelId) { $objDatabase = AssetModelCustomFieldHelper::GetDatabase()->JournalingDatabase; $objResult = $objDatabase->Query('SELECT * FROM asset_model_custom_field_helper WHERE asset_model_id = ' . $objDatabase->SqlVariable($intAssetModelId) . ' ORDER BY __sys_date'); return AssetModelCustomFieldHelper::InstantiateDbResult($objResult); }