| Table Name: | MPSysUserQuery |
| View Name: | MARISysUserQuery |
| Group: | Group: SysUserQuery |
| Description: | System: User Defined Queries |
| ClassID: | 250. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| UserQueryID | UserQueryID INT Primary |
Internal ID | |
| Matchcode | Matchcode NVARCHAR (50) Index |
Name of the query | |
| QueryType | QueryType INT Index |
0=MARI, 1=MARI+SBO, 2=SBO Only | |
| QuerySQL | QuerySQL NTEXT |
QUERY TEXT | |
| ConnectionID | ConnectionID INT Index |
1=MARIProject DB | |
| Company | Company INT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| QueryGroup | QueryGroup INT |
Link to group | MPSysUserQuery.GruppenID |
| Description | Description NTEXT |
||
| QuerySyntax | QuerySyntax INT |
1=TSQL, 2=HANA Syntax | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| CreateView | CreateView SMALLINT (0=false,-1=true) |
Flag to store the query as permanent view in the database | |
| ViewName | ViewName NVARCHAR (50) |
Name of the view, when stored | |
| LastImport | LastImport Datetime |
||
| ClassId | ClassID INT Index |
ClassId | |
| FilterMode | FilterMode INT |
||
| FilterID | FilterID INT Index |
MPSysFilterDefinitionFilter.FilterID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPChefInfoDashboardTiles | Project Dash Board Settings Tiles |
| MPCommissionTypes | Commission: Basic Settings for different Types |
| MPDBColumnsDefinitionCol | Info Screen Management: Column Definition Columns |
| MPDocApprovalRessource | Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button. |
| MPOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |
| MPSysUserQuery | System: User Defined Queries |