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