/** * 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 intDatagridId * @return Datagrid[] */ public static function GetJournalForId($intDatagridId) { $objDatabase = Datagrid::GetDatabase()->JournalingDatabase; $objResult = $objDatabase->Query('SELECT * FROM datagrid WHERE datagrid_id = ' . $objDatabase->SqlVariable($intDatagridId) . ' ORDER BY __sys_date'); return Datagrid::InstantiateDbResult($objResult); }
/** * Static Qcodo Query method to query for an array of Datagrid objects. * Uses BuildQueryStatment to perform most of the work. * @param QQCondition $objConditions any conditions on the query, itself * @param QQClause[] $objOptionalClausees additional optional QQClause objects for this query * @param mixed[] $mixParameterArray a array of name-value pairs to perform PrepareStatement with * @return Datagrid[] the queried objects as an array */ public static function QueryArray(QQCondition $objConditions, $objOptionalClauses = null, $mixParameterArray = null) { // Get the Query Statement try { $strQuery = Datagrid::BuildQueryStatement($objQueryBuilder, $objConditions, $objOptionalClauses, $mixParameterArray, false); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } // Perform the Query and Instantiate the Array Result $objDbResult = $objQueryBuilder->Database->Query($strQuery); return Datagrid::InstantiateDbResult($objDbResult, $objQueryBuilder->ExpandAsArrayNodes); }