/**
* Truncate datagrid_column_preference table
* @return void
*/
public static function Truncate()
{
// Get the Database Object for this Class
$objDatabase = DatagridColumnPreference::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
TRUNCATE `datagrid_column_preference`');
}
/**
* 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 intDatagridColumnPreferenceId
* @return DatagridColumnPreference[]
*/
public static function GetJournalForId($intDatagridColumnPreferenceId)
{
$objDatabase = DatagridColumnPreference::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM datagrid_column_preference WHERE datagrid_column_preference_id = ' . $objDatabase->SqlVariable($intDatagridColumnPreferenceId) . ' ORDER BY __sys_date');
return DatagridColumnPreference::InstantiateDbResult($objResult);
}
