project BLF > class BSettingConfiguration > business logic query CheckSettingByName
Parameters
| icConfigName | character | |
| icConfigLevel | character | |
| icScope | character | |
| ilActive | logical | |
query condition
each fcSettingConfig where
fcSettingConfig.SettingConfigName = icConfigName AND
fcSettingConfig.SettingConfigLevel = icConfigLevel
each fcSetting (inner-join) where
fcSetting.SettingConfig_ID = fcSettingConfig.SettingConfig_ID AND
fcSetting.SettingScope = icScope AND
fcSetting.SettingIsActive = ilActive
query resultset tqCheckSettingByName
| field name | data type | db field | description |
|---|
| tiSetting_ID | integer | fcSetting.Setting_ID | Record ID |
| tlSettingIsActive | logical | fcSetting.SettingIsActive | Active |
Internal usage
BLF
QadFinancials