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); }