Please enable JavaScript to view this site.

System table SYS_SETTINGS

dsgn_sys-settings

There are several types of settings?

Global settings are stored in the file ServerSettings.json, a JSON configuration object.

Database server settings are application server settings which override the global settings.

Each object is stored in the system table SYS_SETTINGS.

Database client settings are Efficy settings which override the global settings.

Each object is stored in the system table SYS_SETTINGS, with the exception of the parameter user – you’ll find it in the table ACC_ACCOUNT.

Learn how you can edit JSON configuration objects successfully.

The objects start with an uppercase character; the parameters apply the Camelcase standard and start with a lowercase character.

// JSON CONFIGURATION OBJECTS
// Do not remove the {} or commas
// The value names are case-sensitive
// The syntax is NAME : "VALUE",

dsgn_JSON-logo

reference info on the Efficy settings

dsgn_settings-reference

ABCDEFHIJLMNOPQRSTUWX

A

addEmailOutEfficyTagadminCheckIntervaladminSaltagendaParamsModeadminPasswordallowIpSwitchingalternateConnectionsTimeOutapiEndPointappBaseAppServer appServersauthorizationKey autoEditLinkautoSaveDocumentautoSaveOptionsInterval

B

base broadcastInterval

C

caseClosedStatusIdcaseManagerDefaultUsercaseOpenedStatusIDchannelclientCertificateclientCertificateKeyCommonconcurrentIntervalconnectionMaxRetryconnectionSleepTimeconnectionTimeOut consolidatedCurrency contactPictureSize contentEntitiescontRelationEntitiescreateLogFile (of Proxy) – createLogFile (of RemServer) – createLogFile (of Servicy) – createLogFile (of Web) customerForExtranetcustomerSelection

D

dbName dbTranslateFrom dbTranslateOverridedbTranslateTodbTypedealerBasedebugModedefaultEntitiesdefaultFloatFormatdefaultLanguage (of User) – defaultLanguage (of Web) – defaultRowCountdisableFullSearchEntitiesdisableInvitationsdisableQuickAddLink (of Efficy (Session)) –disableQuickAddLink (of User) – disableReminderAlertsdisableThumbsCreationdtSearchDebugLogdtSearchMaxResultsdtSearchRetrieveSteps

E

EfficyEfficy (Session)EfficyFormatefficyTimeZoneefficyUrlencoderAllowedTagsencryptentitiesWithSecureContent entityListsWithTagUserSelection excelConvertDurationextranetFileBaseList extranetSettingsExtranetTemplatesCSSExtranetTemplatesSignatureextranetURL

F

faxMonitorOutputFolderFcm fileCacheActivefileIndexingEnable fileIndexingPath fileIndexingRoot fileMaxSizefileMinSize fileRepositoryfileTempUploadfileURL firstNameFirstfolderformat

H

hideInactiveButtonDelayhttps

I

ignoreContextExceptions ignoreSideBarHttp interval

J

jVersion

L

LdaplinkMainComploadBalancinglockIntervallogEnabledlogIntervalInDayslogExactQuerieslogSQLQuerieslogUserQuerieslogin

M

mailIndexingPathmailingCodeFormatmaxConcurentConnectionCreationmaxEditOperationsmaxGridRowsmaxItemProcessedPerAdminCheckmaxRecentEntitiesmaxRequestPerConnectionmaxUsedDays meetingInvitationURLmemLog (of AppServer) – memLog (of Efficy) – memoFormattedmergeIntervalminConnectionsmultiCurrencyMode

N

Notification (in Efficy (Session))

O

OneAlloppoListReportKeyoppoOrderStatusIdoracleClobLength oracleFullYearSearch oracleSkipTranslate

P

Passwordpassword (of Ldap) – password (of RemServer) – passwordLockTimepasswordMaxAttemptspdfMonitorInputFolderpdfMonitorOutputFolderpdfTimeOutPeakMeUpPlacesSettingsport privateKey protocol Proxy proxyList publicKey

Q

Qlik

R

realtimerefreshIntervalrelationSecurityLevelremoteCallWorkflowIdRemServerReplicFileCutSizeReplicStandardCutSize

S

searchMemoLengthsecondaryUnit secureCookie ServerserverNameserverTicketUrlservicesConnectionStringServicysessionTimeOut (of Slsp) sessionTimeout (of Web) sidebarCtiSearchMaxDigitssidebarCtiSearchMinDigits skipFields Slc Slsp ssoMode subDomainsyncQueueActive

T

tempFolder (of SLsp) – tempFolder (of Web) – timesheetImportRoundMinutestnsNametrainingPrivateReferenceParttrainingPublicReferencePart

U

useContactDataOnContCompRelationuseLinkedFileUseruserIdIsUserCodeurl (of Fcm) url (of PeakMeUp) – URL (of Servicy) User userCanDeleteItem userDirectory userIduserHashuserPasswordUrl

W

WatchdocFaxFolderWatchdocScanFolderworkingMinutes workingPeriodFromworkingPeriodTo

X

xrfkey

© 2006-2020 Efficy All rights reserved