/**
* 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 intAssetId
* @return AssetCustomFieldHelper[]
*/
public static function GetJournalForId($intAssetId)
{
$objDatabase = AssetCustomFieldHelper::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM asset_custom_field_helper WHERE asset_id = ' . $objDatabase->SqlVariable($intAssetId) . ' ORDER BY __sys_date');
return AssetCustomFieldHelper::InstantiateDbResult($objResult);
}
