public function deleteAllByCustomField($intCustomFieldId)
{
// Get the Database Object for this Class
$objDatabase = AssetCustomFieldAssetModel::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
DELETE FROM
`asset_custom_field_asset_model` WHERE `custom_field_id` = ' . $objDatabase->SqlVariable($intCustomFieldId));
}
/**
* 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 intAssetCustomFieldAssetModelId
* @return AssetCustomFieldAssetModel[]
*/
public static function GetJournalForId($intAssetCustomFieldAssetModelId)
{
$objDatabase = AssetCustomFieldAssetModel::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM asset_custom_field_asset_model WHERE asset_custom_field_asset_model_id = ' . $objDatabase->SqlVariable($intAssetCustomFieldAssetModelId) . ' ORDER BY __sys_date');
return AssetCustomFieldAssetModel::InstantiateDbResult($objResult);
}