EnableSQLReadOnlyAGConnection

Initial Build

2015.1.3

Module

Admin

Current Setting Type

Text Box

Use this system option to enable or disable Availability Group read-only connection for the specified query-type families, or areas. Enter the sum of the numbers that correspond to the options you'd like to enable. The default for this option is 65536.

You can also enable or disable Availability Group read-only connection for a targeted metadata query (such as a child form). This process allows you to override the overall area setting in EnableSQLReadOnlyAGConnection but only for your chosen metadata query.

This functionality is under development. Check back later for specific steps on using this powerful feature.

Current Setting

The current setting for EnableSQLReadOnlyAGConnection is used as follows:

Values:

Option Name Description Number
Enable All Enable SQL read only AG connection for every option listed here. 65536
Disable All Disable SQL read only AG connection for every option listed here. 0

 

This system option can be set to enable Availability Group read-only connect for any single area or a collection of areas. To enable Availability Group read-only connect for an area, enter the number beside that area. If you want to enable Availability Group read-only connect for more than one area, then add up the numbers for each area and enter the sum.

Area Name Description Number
CachedMetaData Only queries controlled by this system option and generated by cached metadata. 16
ChildFormData All queries for child-form data. 4
ChildFormConditional All SQL database queries that control the behavior of child forms, such as IsVisible, ReadOnly, Row IsVisible, Row ReadOnly, and Add IsVisible. 8
Formlink All Form Links Selection and Visibility SQL queries. 4096
Misc Only misc queries that are controlled by this system option and have SQL parameters implemented. 32
MiscConditional Miscellaneous conditional queries (expressions that control IsVisible, ReadOnly, etc.) that have SQL Parameters implemented. 8192
Record Select Parameterize queries generated by DataUtils.SelectByKey(), which is an operation that loads the data for a specific netFORUM facade object. 1
SelectFacadeDataSet Parameterize queries generated by DataUtils.SelectByDataRow(), which is an operation that loads the data for a specific netFORUM facade object. 2

 

Default Value: 65536

Fields 

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.

Availability

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.