User Tools
niota-docs:niota_system_config_defaults
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_system_config_defaults [2022/01/05 12:32] admin |
niota-docs:niota_system_config_defaults [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | |||
| + | |||
| + | |||
| + | ==== 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 === | === USE_DEFAULT_PK_ORDER_BY === | ||
| Flag to toggle generation of default order by clause. | Flag to toggle generation of default order by clause. | ||
| - | * true: ORDER BY clause based on primary key is generated | + | * ''true'' -> ORDER BY clause based on primary key is generated |
| - | * false: no ORDER BY clause is generated | + | * ''false'' -> no ORDER BY clause is generated |
| === DEFAULT_GRID_ORDER_BY === | === DEFAULT_GRID_ORDER_BY === | ||
| Default direction of order by clause if ''USE_DEFAULT_PK_ORDER_BY'' is on. | Default direction of order by clause if ''USE_DEFAULT_PK_ORDER_BY'' is on. | ||
| - | * ASC -> ascending order | + | * ''ASC'' -> ascending order |
| - | * DESC -> descending order | + | * ''DESC'' -> descending order |
| === SYSTEM_OBJECT_ALIAS_GRID === | === SYSTEM_OBJECT_ALIAS_GRID === | ||
| Line 20: | Line 40: | ||
| <code> | <code> | ||
| + | // 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('USE_DEFAULT_PK_ORDER_BY', true); | ||
| define('DEFAULT_GRID_ORDER_BY', 'ASC'); | define('DEFAULT_GRID_ORDER_BY', 'ASC'); | ||
| define('SYSTEM_OBJECT_ALIAS_GRID', 'a%cat_id%'); | define('SYSTEM_OBJECT_ALIAS_GRID', 'a%cat_id%'); | ||
| + | |||
| </code> | </code> | ||
niota-docs/niota_system_config_defaults.1641382357.txt.gz · Last modified: 2025/07/17 14:11 (external edit)