Calling up Statistics via Resource Planning
As of version 1.7 of the FSM, it is possible to call up statistics via the resource planning. Filters from the resource planning can be transferred as parameters in the statistics. The entry points are configured in the "resourcePlanningScheduler.json". For this purpose, another "name-data" object is added to the "objects" array. The name of this object is "openExternalInfo". An object list is specified as "data". An object has the following structure:
Name |
Description |
title |
Name/title of the entry point |
statisticId |
Id of the statistic to be called up |
openInNewTab |
Indicates whether the statistic should be opened in a new browser tab. If 'false' or no entry has been made here, the statistic will be opened in a new sheet. |
mapping |
The mapping between the filter variables from the RP and the parameters of the statistic The variables and the parameters are case sensitive. |
Filter variables
The following filter variables are available for mapping:
Name |
Description |
Start |
Starting point of time |
End |
Ending point of time |
OGrNrs |
The OGrNrs of the filtered main groups |
GrNrs |
The GrNrs of the filtered groups |
Restypes |
The Ids of the filtered resource types |
FilteredFlags |
The Ids of the filtered flags |
FilteredIcons |
The Ids of the filtered icons |
The list is not complete. The most important filters are listed.
Example:
{
"name"
:
"openExternalInfo"
,
"data"
: [
{
"title"
:
"Open in new sheet"
,
"statisticId"
:
"eba5ca97-9ea2-44f5-a24a-0a4135210850"
,
"mapping"
: {
"OGrNrs"
:
"user_ogrnr"
,
"GrNrs"
:
"user_grnr"
,
"Start"
:
"date_from"
,
"End"
:
"date_to"
}
},
{
"title"
:
"Open in new tab"
,
"statisticId"
:
"eba5ca97-9ea2-44f5-a24a-0a4135210850"
,
"mapping"
: {
"OGrNrs"
:
"user_ogrnr"
,
"GrNrs"
:
"user_grnr"
,
"Start"
:
"date_from"
,
"End"
:
"date_to"
},
"openInNewTab"
:
true
},
{
"title"
:
"Something new, something blue, something borrowed"
,
"statisticId"
:
"ed81f39b-68c1-4c0f-bd6a-a0a8f187cedf"
,
"mapping"
: {
"GrNrs"
:
"user_grnr"
,
"Start"
:
"date_from"
,
"End"
:
"date_to"
}
}
]
}