==== validation feature settings ==== === MAXNUMBER_VALIDATIONERR === Number of errors that may occur before validation procedure is aborted. When -1 the procedure does not terminate due to an error. (shipped with: -1 -> no limit) === MAXNUMBER_VALIDATIONMSG === Number of messages/errors that are logged by the feature. (shipped with: -1 -> log all) === MAXNUMBER_VALIDATIONROW === Number of records that should be validated. (shipped with: -1 -> validate all) === VALIDATION_CHUNK_SIZE === Number of records retrieved by a single database access. The higher this value the less database accesses needed, but the more memory is used. (shipped with: 10000) ==== SQL Generation settings ==== === USE_DEFAULT_PK_ORDER_BY === Flag to toggle generation of default order by clause. * ''true'' -> ORDER BY clause based on primary key is generated * ''false'' -> no ORDER BY clause is generated === DEFAULT_GRID_ORDER_BY === Default direction of order by clause if ''USE_DEFAULT_PK_ORDER_BY'' is on. * ''ASC'' -> ascending order * ''DESC'' -> descending order === SYSTEM_OBJECT_ALIAS_GRID === String + pattern for alias clause for editing tables when catalog object join is used * ''""'' (blank) -> no alias * ''"a"'' -> the alias is the given character or string * ''"abc%cat_id%"'' -> the alias is the given character or string concatenated with the actual catalog ID. // validation feature settings define('MAXNUMBER_VALIDATIONERR', -1); define('MAXNUMBER_VALIDATIONMSG', -1); define('MAXNUMBER_VALIDATIONROW', -1); define('VALIDATION_CHUNK_SIZE', 10000); // SQL generation settings define('USE_DEFAULT_PK_ORDER_BY', true); define('DEFAULT_GRID_ORDER_BY', 'ASC'); define('SYSTEM_OBJECT_ALIAS_GRID', 'a%cat_id%');