Difference between revisions of "QPR UI System Settings"

From Mea Wiki
Jump to navigation Jump to search
(307035)
(307035)
Line 20: Line 20:
 
|-
 
|-
 
|GENERIC_WEB_SERVICE_LOCATION
 
|GENERIC_WEB_SERVICE_LOCATION
|QPR Reporting Add-on web service interface location of the Dataset handler. QPR UI uses this address to access QPR Suite to fetch data when Generic Web Service queries are made.<br>The url should contain values for the "xsession" and "expression" parameters, for which the following tags are supported as values:
+
|QPR Reporting Add-on web service interface location of the ExpressionAsDataset handler. QPR UI uses this address to access QPR Suite to fetch data when Generic Web Service queries are made.<br>The url should contain values for the "xsession" and "expression" parameters, for which the following tags are supported as values:
 
* <#expression>: Used for the expression parameter. Contains the expression that is sent to the web service. Mandatory.
 
* <#expression>: Used for the expression parameter. Contains the expression that is sent to the web service. Mandatory.
 
* <#meaSessionId>: Used for the xsession parameter. Contains the QPR Suite session id.
 
* <#meaSessionId>: Used for the xsession parameter. Contains the QPR Suite session id.
* <#enticeSessionId>: Used for the xsession parameter. Contains the QPR UI session id.
+
* <#enticeSessionId>: Not in use currently, but would be used for the xsession parameter. Contains the QPR UI session id.
In addition to the mandatory <#expression> tag, either the <#meaSessionId> or <#enticeSessionId> tag must be used.<br>
+
In addition to the mandatory <#expression> tag, the <#meaSessionId> tag must be used.<br>
Example: <nowiki>https://localhost/QPRWebServicesExtensions/Dataset.ashx?xsession=<#enticeSessionId>&expression=<#expression></nowiki>
+
Example: <nowiki>https://localhost/QPRWebServicesExtensions/ExpressionAsDataset.ashx?xsession=<#meaSessionId>&expression=<#expression></nowiki>
 
|-
 
|-
 
|MEA_SERVICE_LOCATION
 
|MEA_SERVICE_LOCATION

Revision as of 13:22, 16 November 2017

This page describes all QPR UI system settings. The settings are stored in QPR UI's database in the CONFIGURATIONENTITY table. Some of the settings can be changed during the installation in the installation wizard. After these settings are changed in the database, QPR UI's Windows service must be restarted so that the changes take effect.

The Setting name in the following table is defined in the KEY_FIELD column of the CONFIGURATIONENTITY table.

Setting name (KEY_FIELD column) Description
ADMINISTRATORS_GROUP_NAME QPR Suite (MEA) or QPR ProcessAnalyzer user group name which member users are administrators in QPR UI. Other users have only viewer rights.
AUTHENTICATION_SERVICES
DB_VERSION QPR UI database version. Do not edit this field.
FEDERATEDLY_MANAGED_GROUPS List of user groups that the federated authentication syncronizes for a user when the user logs in to QPR UI.
GENERIC_WEB_SERVICE_LOCATION QPR Reporting Add-on web service interface location of the ExpressionAsDataset handler. QPR UI uses this address to access QPR Suite to fetch data when Generic Web Service queries are made.
The url should contain values for the "xsession" and "expression" parameters, for which the following tags are supported as values:
  • <#expression>: Used for the expression parameter. Contains the expression that is sent to the web service. Mandatory.
  • <#meaSessionId>: Used for the xsession parameter. Contains the QPR Suite session id.
  • <#enticeSessionId>: Not in use currently, but would be used for the xsession parameter. Contains the QPR UI session id.

In addition to the mandatory <#expression> tag, the <#meaSessionId> tag must be used.
Example: https://localhost/QPRWebServicesExtensions/ExpressionAsDataset.ashx?xsession=<#meaSessionId>&expression=<#expression>

MEA_SERVICE_LOCATION QPR Suite (MEA) web service interface location. QPR UI uses this address to access QPR Suite to fetch data.
PA_SERVICE_LOCATION QPR ProcessAnalyzer web service interface location. QPR UI uses this address to access QPR ProcessAnalyzer to fetch data.
SAML_AUTOMATIC_LOGIN Federated authentication setting, described in the linked page.
SAML_CONSUMER_URL Federated authentication setting, described in the linked page.
SAML_METADATA_URL Federated authentication setting, described in the linked page.
SAML_REDIRECT_URL Federated authentication setting, described in the linked page.
SAML_SERVER_ENTITY_IDENTIFIER Federated authentication setting, described in the linked page.
SAML_SIGNING_CERTIFICATE Federated authentication setting, described in the linked page.
SAML_USER_DESCRIPTION_ATTRIBUTE Federated authentication setting, described in the linked page.
SAML_USER_EMAIL_ATTRIBUTE Federated authentication setting, described in the linked page.
SAML_USER_FULLNAME_ATTRIBUTE Federated authentication setting, described in the linked page.
SAML_USER_GROUPS_ATTRIBUTE Federated authentication setting, described in the linked page.
SAML_USER_ID_ATTRIBUTE Federated authentication setting, described in the linked page.
SCHEMA_VERSION QPR UI database schema version. Do not edit this field.
SESSION_EXPIRATION_TIME QPR UI user session expiration time in minutes. If this setting is not defined, by default this is 30 minutes.
SYSTEM_USER_NAME QPR Suite (MEA) system username. Used in the federated authentication.
SYSTEM_USER_PASSWORD Password of the QPR Suite (MEA) system user defined in SYSTEM_USER_NAME field.