select count(*) enabled
from tbl_LIB_ModSettings
where companyPKeyId =
and companyPType =
and moduleId = 86
and settingid = 11
and value = 1
SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager
FROM request.qmd_userTerritoryHierarchy
WHERE brokerLevel = 1
SELECT distinct parentTerritoryId
FROM request.qmd_listBrokerMrkts
WHERE brokerLevel = 1
SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager
FROM request.qmd_userTerritoryHierarchy
WHERE brokerlevel <> 1
filterChanged = false;
applyDistributorContext();
if( ListLen( _param, "=" ) gt 1 ) {
_paramName = ListFirst( _param, "=" );
_paramValue = ListLast( _param, "=" );
StructInsert( client, _paramName, _paramValue, true );
} else {
_paramName = ListFirst( _param, "=" );
if( isDefined( "client.#_paramName#" ) and isNumeric( client[_paramName] )) {
StructInsert( client, _paramName, 0, true );
} else {
StructInsert( client, _paramName, "", true );
}
}