QPR ProcessAnalyzer Objects in Expression Language

Datatable

Datatables are used to store data in QPR ProcessAnalyzer persistently. Datatables consist of one-to-many named columns and zero-to-many rows. The Datatable entity in the expression language is used to access Datatables metadata, such as name, description and audit information. The actual data contents can be accessed by using the DataFrame property, which causes the actual data to be loaded from the database into memory for calculations.

Datatables have many usecases:

• project can load their data from Datatables.
• Datatables can be used to store data extracted from external systems
• Intermediate ETL calculation results can be stored to Datatables
• It's possible to visualize data from Datatables directly in the dashboards without building a QPR ProcessAnalyzer model

Datatables are stored to QPR ProcessAnalyzer database as database tables. Each datatable belongs to a project.

Datatable properties	Description
CreatedDate (DateTime)	Timestamp when the datatable was created.
DataFrame (DataFrame)	Contents of the DataTable as a DataFrame.
Description (String)	Datatable description. The datatable description may contain line breaks.
Id (Integer)	Datatable Id. Datatable Id is generated by QPR ProcessAnalyzer when the datatable is created.
LastImportDate (DateTime)	Timestamp when data was the last time imported to the datatable.
LastModifiedDate (DateTime)	Timestamp when the datatable was modified the last time.
Name (String)	Name of the datatable.
NColumns (Integer)	Number of columns in the datatable.
NRows (Integer)	Number of data rows in the datatable.
Project (Project)	Project the datatable belongs to.

Model

Model properties	Description
CaseAttributes (AttributeType*)	CaseAttributes in the model returned in the alphabetical order. Using this property requires that the model is loaded in the memory. If the model is not in the memory, it's loaded when this property is used.
ConfigurationJson (String)	Returns an model configuration in JSON format.
CreatedDate (DateTime)	Timestamp when the model was created.
DefaultFilterId (Integer)	Default filter id of the model.
ConfigurationJson (String)	Returns an model configuration in JSON format.
Description (String)	Model description. The model description may contain line breaks.
EstimatedMemory (Integer)	Returns an estimation of how much memory in bytes the model requires.
EventAttributes (AttributeType*)	EventAttributes in the model returned in the alphabetical order. Using this property requires that the model is loaded in the memory. If the model is not in the memory, it's loaded when this property is used.
EventLog (EventLog)	EventLog containing the entire model (i.e. event log where no filters have been applied). Using this property requires that the model is loaded in the memory. If the model is not in the memory, it's loaded when this property is used.
Id (Integer)	Model Id. Model Id is generated by QPR ProcessAnalyzer when the model is created.
LastImportDate (DateTime)	Timestamp when data was the last time imported to the model.
LastModifiedDate (DateTime)	Timestamp when the model was modified the last time.
Name (String)	Model name.
NBookmarks (Integer)	Number of bookmarks in the model.
NCache (Integer)	Amount of objects related to the model when the model is loaded into the memory.
NCaseAttributes (Integer)	Number of CaseAttributes in model.
NCases (Integer)	Number of Cases in the model.
NEventAttributes (Integer)	Number of EventAttributes in model.
NEvents (Integer)	Number of Events in model.
NEventTypes (Integer)	Number of EventTypes in the model.
NFilters (Integer)	Number of filters in the model.
NOpens (Integer)	Number of times analysis has been requested from the model.
Project (Project)	Project the model belongs to.
ProjectId (Integer)	Project id the model belongs to.
Status (String)	Memory availability status of the model. There are the following statuses: Loading: The model is currently loading into the memory. When the loading is ready, the status changes to online. If the loading fails, the status changes to offline. Offline: The model is currently not loaded into the memory. The model needs to be loaded into the memory, so that analyses can be calculated from the model (occurs automatically when an analysis is requested). Online: The model is in the memory and ready for analysis calculation. If the model is dropped from the memory, its status changes to offline.

Notes:

• Regarding properties returning object counts: For models downloaded from a datatable, ODBC or expression datasource, the numbers represent the situation in the previous data load. Null is returned for models downloaded from an ODBC datasource, if the model has never been loaded into the memory. Note also that if Case permissions are used for the model, null is returned for data security reasons.
• Using CaseAttributes, EventAttributes or Eventlog properties of the Model object requires the model to be loaded into the memory. If the model is not in the memory, it's loaded when these properties is called. Other Model object properties down require the model to be in the memory.

Project

Project properties	Description
Id (Integer)	Id of the Project. It's generated by QPR ProcessAnalyzer when the model is loaded.
Name (String)	Name of the Project.
Models (Model*)	Models that are in the Project.

User/Group

User objects represents users and user groups. Note that some properties can only be used for users and some for groups.

User properties	Description
Description (String)	Description of the user.
Email (String)	Email address of the user.
FullName (String)	Full name of the user or group name.
GroupMemberNames (String*)	Array of names of members of a user group. This property is available for groups.
GroupMembers (User*)	Array of members of a user group. This property is available for groups.
GroupNames (String*)	Array of names of user groups the user belongs to. This property is available for users.
Groups (User*)	Array of user groups the user belongs to. This property is available for users.
Id (Integer)	Id of the user, which is unique for every user.
IsActive (Boolean)	Returns true only if the user is active (not disabled).
IsGroup (Boolean)	Returns true if the user is a user group.
LogonMessage (String)	Returns the logon message of the user.
Name (String)	Login name of the user or group.
Roles (String Array*)	Roles of user as string array.