|
Initial Build |
2015.1.3 |
|
Module |
Admin |
|
Current Setting Type |
Text Box |
Use this system option to enable or disable local SQL logic evaluation for the specified query-type areas. Enabling local SQL logic evaluation means that netFORUM attempts to evaluate a conditional SQL statement locally, before sending the statement to the SQL server. netFORUM can locally evaluate only conditional SQL statements such as those statements determining if something IsVisible, IsReadOnly, or IsRequired. Enter the sum of the numbers that correspond to the options you'd like to enable.
The default for this option is 65536.
The current setting for EnableSQLLogicEvaluation is used as follows:
Values: This system option can be set to enable or disable local SQL logic evaluation globally or for any single area or a collection of areas.
Global Settings:
| Option Name | Description | Number |
|---|---|---|
| Enable All | Enable local SQL logic evaluation for every option listed here. | 65536 |
| Disable All | Disable local SQL logic evaluation for every option listed here. | 0 |
Individual Areas:
To enable local SQL logic evaluation for an area, enter the number beside that area. If you want to enable local SQL logic evaluation for more than one option, then add up the numbers and enter the sum.
| Option Name | Description | Number |
|---|---|---|
| ChildForm | Queries controlling child form behavior IsVisible, ReadOnly, Row IsVisible, Row ReadOnly, Add IsVisible | 1 |
| FormLink | Queries controlling Form Link visibility | 2 |
| FormPanel | Queries controlling Form Panel visibility | 4 |
| FormControls | Queries embedded in md_dynamic_form_control.dys_data controlling visibility/readonly/required | 8 |
| ProfileDetail | Queries controlling dynamic profile detail visibility | 16 |
| Search | Queries controlling dynamic search visibility | 32 |
| WebContent | Web content visibility conditions | 64 |
| Misc | Other conditional expressions (including ones embedded in md_web_link.wbl_data) | 128 |
Default Value: 65536
This system option includes the following fields:
description: This field gives the description of the system option, including its use and default value.
Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.
category: This field sets the category (usually the module) where the system option is used.
type : The type field determines the display type of the current setting field (check box, drop-down list, or text box).
values: The values field indicates the allowed values for the current setting field.
Each system option includes the following availability settings:
entity level option?: Select this check box to make this system option available on an entity level.
visible to external systems?: Select this check box to make this system option available in xWeb.