Aqbeż għall-kontenut

Ħolqien/modifika/tħassir ta’ rapport

Ir-rapport jiġi kkonfigurat permezz ta’ fajl XML. Trid tiddefinixxi:

  • Il-query fuq id-database ta’ CyberElements Identity biex tinkiseb l-informazzjoni mixtieqa,
  • Il-proprjetajiet ta’ kull kolonna li għandha tintwera, f’format XML: tip ta’ oġġett, isem fid-database SQL, isem li għandu jintwera, indiċi tal-wiri, eċċ.
  • L-għażliet tal-wiri tal-grafiċi (grafiku bil-vireg, grafiku f’forma ta’ torta, tikek ikkuluriti).

Ikklikkja l-buttuna “New report” biex toħloq u tikkonfigura rapport ġdid.

Agħżel rapport u kklikkja l-buttuna “Modify” biex timmodifika l-konfigurazzjoni tiegħu.

New report

Proprjetajiet ta’ rapport

Parametru Deskrizzjoni Tipi u valuri possibbli
Name Isem tal-wiri tar-rapport. Sensiela ta’ karattri. Obbligatorju.
Code Jikkorrispondi għall-ID tal-oġġett. Il-valur tiegħu jrid ikun uniku fost ir-rapporti kollha. Sensiela ta’ karattri , mingħajr spazji jew karattri speċjali. Obbligatorju
Category Il-kategorija tar-rapporti li fiha tintwera l-lista tar-rapporti. Lista ta’ kategoriji predefiniti.
Description Sensiela ta’ karattri.
XML Tikketti XML li jiddeskrivu l-query SQL fid-database Hpliance, il-proprjetajiet ta’ kull kolonna tar-rapport, u l-proprjetajiet tal-elementi grafiċi. Test f’format XML.
Choice of report template Mudell grafiku tar-rapport (minbarra t-tabella tad-dejta). Without chart, Histogram, Stacked histogram, Pie chart jew Color ball by threshold.
With parameters Jippermettilek iżżid varjabbli mdaħħla mill-utent. Ikollok iżżid it-tikketta mal-XML. Kaxxa ta’ selezzjoni.

Kitba tal-XML għal rapport sempliċi

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<Config> 

   <!-- If there is a chart, indicate whether to display the chart on the dashboard --> 

   <DisplayGraphicInDashboard>true</DisplayGraphicInDashboard> 

   <!-- If there is a chart, indicate the chart display index on the dashboard --> 

   <DashboardDisplayIndex>0</DashboardDisplayIndex> 

   <!-- Indicates whether data is displayed as soon as the report page is accessed -->

   <DirectDisplay>true</DirectDisplay> 

   <!-- The SQL query used to retrieve the data to be displayed --> 

   <Query></Query> 

   <!-- Definition of the list of columns available to the user. --> 

   <!-- The visibility and display index of the column can be configured by the user when viewing the report.  --> 

   <Columns> 

       <!-- Definition of a column (to be duplicated as many times as necessary) --> 

       <Column> 

           <!-- The Object Type -->  

           <ObjectType></ObjectType> 

           <!-- Name of the column containing the IDs -->  

           <Column_Link_Id></Column_Link_Id> 

           <!-- The name of the field as defined in the query.  --> 

           <Name></Name> 

           <!-- The default name to display to the user.  -->  

           <DisplayName></DisplayName> 

           <!-- Indicates whether this column is visible by default. TRUE or FALSE  -->

           <Visible></Visible> 

           <!-- The default display index.  --> 

           <DisplayIndex></DisplayIndex> 

       </Column> 

   </Columns> 

</Config>

Eżempju: lista tal-utenti mingħajr numru tat-telefon

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<Config> 

   <DisplayGraphicInDashboard>true</DisplayGraphicInDashboard> 

   <DashboardDisplayIndex>0</DashboardDisplayIndex> 

   <DirectDisplay>true</DirectDisplay> 

   <Query> 

SELECT personne_uid,personne_display_name FROM PERSONNE 

WHERE personne_id NOT IN(SELECT personne_id FROM PERSONNE_MULTIVALUED WHERE personne_schema_attribut_id = 7) 

 AND personne_hidden=0 

</Query> 

   <Columns> 

       <Column> 

           <ObjectType/> 

           <Column_Link_Id/> 

           <Name/> 

           <DisplayName/> 

           <Visible/> 

           <DisplayIndex/> 

       </Column> 

       <Column> 

           <ObjectType/> 

           <Column_Link_Id/> 

           <Name>personne_uid</Name> 

           <DisplayName>UID</DisplayName> 

           <Visible>TRUE</Visible> 

           <DisplayIndex>1</DisplayIndex> 

       </Column> 

       <Column> 

           <Name>personne_display_name</Name> 

           <DisplayName>Nom</DisplayName> 

           <Visible>TRUE</Visible> 

           <DisplayIndex>2</DisplayIndex> 

       </Column> 

   </Columns> 

</Config>

Tikketti XML li jiddeskrivu l-kolonni ta’ rapport

Tikketta XML Definizzjoni Valuri possibbli
Name L-isem tal-qasam kif inhu definit fil-query SQL. Sensiela ta’ karattri.
Column_Link_Id Jintuża biex jinħolqu kolonni li fihom dejta klikkabbli. Jikkorrispondi għall-isem tal-kolonna li fiha l-ID użat biex jiġi ġestit il-link. Sensiela ta’ karattri. Mhux obbligatorju
ObjectType Tip ta’ oġġett fil-mira tal-link klikkabbli (Identity, struttura). Identity = 1 => Ridirezzjoni lejn il-paġna userDetails.aspx
Structure = 2 => Ridirezzjoni lejn il-paġna structure.aspx
Mhux obbligatorju
DisplayName Isem il-kolonna li għandu jintwera fl-interfaċċja. Sensiela ta’ karattri.
Visible Jindika jekk il-kolonna tintweriex jew hijiex moħbija. 'TRUE' jew 'FALSE'
DisplayIndex Indiċi tal-kolonna (ordni tal-wiri). Numru sħiħ akbar minn 0

Żieda ta’ parametri mdaħħla mill-utent fir-rapport: tikketta

Agħżel il-kaxxa ta’ selezzjoni “With parameters” u żid dawn it-tikketti mal-XML:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  <!-- Definition of the list of parameters expected by the report request.  --> 

   <Parameters> 

       <!-- Definition of a parameter (to be duplicated as many times as necessary) -->  

       <Parameter> 

           <!-- The name of the variable as defined in the query.  -->

           <Variable></Variable> 

           <!-- The label to display to the user.  -->  

           <Label></Label> 

           <!-- An integer indicating the expected data type (see documentation for possible values) -->  

           <DataType></DataType> 

           <!-- Indicates whether the user must specify a value of ‘TRUE’ or ‘FALSE’ --> 

           <Mandatory></Mandatory> 

           <!-- For optional parameters, the default value to be used if not entered by the user.  --> 

           <DefaultValue></DefaultValue> 

       </Parameter> 

   </Parameters>

Eżempju: permessi li se jiskadu

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<Query>DECLARE @DateNow AS DATETIME; SELECT @DateNow = GETDATE(); SELECT * FROM vHABILITATIONS_FULL WHERE (date_debut_lien IS NULL OR @DateNow > date_debut_lien) AND date_fin_lien IS NOT NULL AND ((0 = @ApplicationId) OR (application_id = @ApplicationId)) AND DATEADD(dd, @NbJours, @DateNow) > date_fin_lien ORDER BY date_fin_lien ASC</Query> 

 <Parameters> 

      <Parameter> 

           <Variable>ApplicationId</Variable> 

           <DataType>4</DataType> 

           <Mandatory>TRUE</Mandatory> 

           <Label>Selectionnez l'application</Label> 

       </Parameter> 

      <Parameter> 

           <Variable>NbJours</Variable> 

           <DataType>23</DataType> 

           <Mandatory>TRUE</Mandatory> 

           <Label>Sélectionnez le nombre de jour</Label> 

       </Parameter> 

   </Parameters>

Tikketti XML f’<Parameter> li jiddeskrivu l-parametri li jistgħu jiddaħħlu mill-utent:

Tikketta XML Definizzjoni Valuri possibbli
Variable Isem il-varjabbli użata fil-query SQL (mingħajr il-@). Sensiela ta’ karattri.
Data Type It-tip ta’ oġġett ta’ CyberElements Identity li jikkorrispondi għall-parametru. Jekk ma jkunx tip ta’ oġġett bażiku (data, sensiela, numru sħiħ, eċċ.), il-parametru jkun lista li tinżel li fiha l-valuri possibbli. Structure=2; Authorization Rule=3; Application=4; Repository=5; Right=8; StructureType=11; Tree=12; AdminProfile=18; PersonType=19; String=22; Integer=23; Boolean=24; Date=25.
Label Test li għandu jintwera lill-utent. Sensiela ta’ karattri.
AttributeCode Kodiċi tal-attribut PSA. Sensiela ta’ karattri li tikkorrispondi għal kodiċi PSA.
Mandatory Jindika jekk l-utent huwiex obbligat jispeċifika valur. 'TRUE' jew 'FALSE
DefaultValue Għall-parametri mhux obbligatorji, dan huwa l-valur default li jiddaħħal jekk l-utent ma jdaħħal xejn. Sensiela ta’ karattri.

Definizzjoni tal-parametri għall-grafiċi

Agħżel il-mudell grafiku mil-lista li tinżel u żid dawn it-tikketti mal-XML:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<GraphicConfig> 

       <!-- The type of graph (1=Histogram, 2=Stacked histogram, 3=Pie chart, 4=Colored ball per threshold -->  

       <GraphicType>1</GraphicType> 

       <!-- Graph title (if not specified, the report name will be used -->  

       <Title></Title> 

       <!-- The query to use to retrieve the data that will be used to generate the graph -->

       <Query></Query> 

       <!-- The name of the query field that will serve as the x-axis --> 

       <ColumnX></ColumnX> 

       <!-- The name of the query field that will serve as the y-axis -->  

       <ColumnY></ColumnY> 

       <!-- The label of the x-axis -->  

       <LabelX>Label of column X</LabelX> 

       <!-- The label of the y-axis --> 

       <LabelY>Label of column Y</LabelY> 

       <!-- Indicates whether the graph is in 3 dimensions --> 

       <ThreeDimension>false</ThreeDimension> 

   </GraphicConfig>

Stacked histogram

Daħħal dawn it-tikketti fit-tikketta :

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 <!-- 0 = each compiled block corresponds to a column of data (default value) --> 

       <!-- 1 = each compiled block corresponds to a grouping of data from a single column of data --> 

       <StackColumnMode></StackColumnMode> 

       <!-- Definition of the list of columns to stack. --> 

       <StackedColumns> 

           <!-- Definition of a column (to be duplicated as many times as necessary) -->  

           <StackedColumn> 

               <!--  StackColumnMode = 0: The name of the field that contains the data as defined in the query.  --> 

               <!--  StackColumnMode = 1: The name of the field that allows you to create stackable blocks. (YColumn contains the data) --> 

               <DataField></DataField> 

               <!-- The name to display to the user.  --> 

               <DisplayName></DisplayName> 

               <!-- Defines the color of the stacked block (HTML code or color name) --> 

               <Color></Color> 

           </StackedColumn> 

       </StackedColumns>

Ċirku kkulurit għal kull limitu

Daħħal dawn it-tikketti fit-tikketta :

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<!-- Definition of thresholds -->

       <Intervals> 

           <!-- Definition of a threshold (to be duplicated as many times as necessary) --> 

           <Interval> 

               <!-- Minimum threshold included --> 

               <Min></Min> 

               <!-- Maximum threshold excluded --> 

               <Max></Max> 

               <!-- Color of the ball for the defined threshold (HTML code or color name) -->

               <Color></Color> 

           </Interval> 

       </Intervals>

Traduzzjoni tal-ismijiet tal-kolonni ta’ rapport

Il-kolonni u l-valuri inklużi fir-riżultati ta’ rapport jistgħu jiġu tradotti f’diversi lingwi.

Dan li ġej huwa eżempju ta’ rapport li fih il-kolonni ġew tradotti:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<Config> 

   <DisplayGraphicInDashboard>True</DisplayGraphicInDashboard> 

   <DashboardDisplayIndex>5</DashboardDisplayIndex> 

   <GraphicConfig> 

       <GraphicType>1</GraphicType> 

       <Title>Nombre de personnes par application et type de compte</Title> 

       <Query>SELECT APPLICATION.application_nom + ' - ' + compte_type_nom as Administrateur, T_PERSONNE_APPLICATION_GROUPED.total FROM (SELECT application_id, compte_type_id, COUNT(*) AS total FROM (SELECT DISTINCT personne_id, vPERSONNE_COMPTE_DROIT.application_id, compte_type_id FROM vPERSONNE_COMPTE_DROIT INNER JOIN DROIT ON DROIT.droit_id = vPERSONNE_COMPTE_DROIT.droit_id) T_PERSONNE_APPLICATION GROUP BY application_id, compte_type_id) T_PERSONNE_APPLICATION_GROUPED INNER JOIN APPLICATION ON APPLICATION.application_id = T_PERSONNE_APPLICATION_GROUPED.application_id INNER JOIN COMPTE_TYPE ON COMPTE_TYPE.compte_type_id = T_PERSONNE_APPLICATION_GROUPED.compte_type_id ORDER BY total DESC</Query> 

       <ColumnX>Administrateur</ColumnX> 

       <LabelX>Nom de l'administrateur</LabelX> 

       <ColumnY>total</ColumnY> 

       <LabelY>Nombre de compte</LabelY> 

       <ThreeDimension>false</ThreeDimension> 

   </GraphicConfig> 

   <Query>SELECT APPLICATION.application_culture, APPLICATION.application_nom, compte_type.compte_type_nom, compte_type.compte_type_culture, T_PERSONNE_APPLICATION_GROUPED.total FROM (SELECT application_id, compte_type_id, COUNT(*) AS total FROM (SELECT DISTINCT personne_id, vPERSONNE_COMPTE_DROIT.application_id,  

compte_type_id FROM vPERSONNE_COMPTE_DROIT INNER JOIN DROIT ON DROIT.droit_id = vPERSONNE_COMPTE_DROIT.droit_id)  T_PERSONNE_APPLICATION GROUP BY application_id, compte_type_id) T_PERSONNE_APPLICATION_GROUPED  INNER JOIN APPLICATION ON APPLICATION.application_id = T_PERSONNE_APPLICATION_GROUPED.application_id INNER JOIN COMPTE_TYPE ON COMPTE_TYPE.compte_type_id = T_PERSONNE_APPLICATION_GROUPED.compte_type_id ORDER BY total DESC</Query> 

   <Columns> 

       <Column> 

           <Name>application_nom</Name> 

           <DisplayName>Application</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>1</DisplayIndex> 

           <Internationaldisplayname Lang="FR">Application_FR</internationaldisplayname> 

           <Internationaldisplayname Lang="EN">Application_EN</internationaldisplayname> 

           <CultureColumnName Prop="Name">application_culture</CultureColumnName>  

       </Column> 

      <Column> 

           <Name>compte_type_nom</Name> 

           <DisplayName>Compte type</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>2</DisplayIndex> 

          <Internationaldisplayname Lang="FR">Compte type</internationaldisplayname> 

           <Internationaldisplayname Lang="EN">Account type</internationaldisplayname> 

           <CultureColumnName Prop="Name">compte_type_culture</CultureColumnName>  

       </Column> 

       <Column> 

           <Name>total</Name> 

           <DisplayName>Nombre</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>3</DisplayIndex> 

           <internationaldisplayname Lang="FR">Nombre</internationaldisplayname> 

           <internationaldisplayname Lang="EN">Number</internationaldisplayname> 

       </Column> 

   </Columns> 

</Config>

Tikketta XML

  • Internationaldisplayname:
    • Definizzjoni: tikketta użata biex jiġu tradotti l-ismijiet tal-kolonni li jirritorna r-rapport. Din it-tikketta trid tidher daqs kemm hemm lingwi kkonfigurati f’CyberElements Identity.
    • Attribut: Lang=“<\language_code>” fejn <\language_code> jirrappreżenta l-kodiċi tal-lingwa definit fis-settings tal-lingwa fit-tab General > Application Settings.
    • Valur possibbli: sensiela ta’ karattri. L-isem tal-kolonna muri fir-rapport għal-lingwa.
  • CultureColumnName:
    • Definizzjoni: definizzjoni tal-XML tal-kultura li jintuża biex jiġi tradott il-kontenut tat-tabella ġġenerata mir-rapport.
    • Attribut: Prop=“<\XML_Attribute>” fejn <\XML_Attribute> jirrappreżenta l-attribut tal-proprjetà XML li jikkorrispondi għad-diversi valuri tal-kolonna.
    • Valur possibbli: sensiela ta’ karattri. Kolonna tal-kultura tal-query SQL.

Wiri ta’ rapport skont il-kuntest tal-utent

Fil-verżjoni 4000 ta’ Hpliance, huwa possibbli li żżid ma’ rapport parametru inviżibbli li jiġi definit skont il-persuna li tħaddem ir-rapport. Il-valuri tar-rapport jintwerew skont il-valuri ta’ attribut tal-utent. Pereżempju, l-utent jara biss ir-riżultati tal-organizzazzjoni tiegħu.

Eżempju ta’ rapport: elenka l-permessi kollha assenjati lill-identitajiet ta’ struttura partikolari. Uri l-kunjomijiet, l-ismijiet, il-permessi u l-applikazzjonijiet tal-identitajiet kollha li għalihom l-attribut tal-istruttura “Responsibility” jaqbel mal-attribut tal-istruttura tal-utent konness.

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
<Config> 

   <DirectDisplay>true</DirectDisplay> 

   <Query>select P.personne_id,P.personne_nom, P.personne_prenom, D.droit_nom, A.application_nom 

from vHABILITATIONS_ALL  AS VHA 

inner join LIEN_PERSONNE_STRUCTURE AS LPS ON LPS.personne_id = VHA.personne_id 

inner join DROIT AS D ON D.droit_id = VHA.droit_id 

inner join PERSONNE AS P ON P.personne_id = VHA.personne_id 

inner join APPLICATION AS A ON A.application_id = D.application_id 

where structure_id  in  

 (select * from dbo.fctSplitString(dbo.fctGetAttributeValueByPersonneIdAndPersonneSchemaAttributCode(@personneId, 'responsabilite'), '|')) 

 </Query> 

   <Columns> 

       <Column> 

           <Name>personne_id</Name> 

           <DisplayName>ID</DisplayName> 

           <Visible>False</Visible> 

           <DisplayIndex>1</DisplayIndex> 

       </Column> 

       <Column> 

           <Name>personne_nom</Name> 

           <DisplayName>Nom</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>2</DisplayIndex> 

           <ObjectType>1</ObjectType> 

           <Column_Link_Id>personne_id</Column_Link_Id> 

       </Column> 

       <Column> 

           <Name>personne_prenom</Name> 

           <DisplayName>Prénom</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>2</DisplayIndex> 

           <ObjectType>1</ObjectType> 

           <Column_Link_Id>personne_id</Column_Link_Id> 

       </Column> 

       <Column> 

           <Name>droit_nom</Name> 

           <DisplayName>Droit</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>3</DisplayIndex> 

       </Column> 

       <Column> 

           <Name>application_nom</Name> 

           <DisplayName>Application</DisplayName> 

           <Visible>True</Visible> 

           <DisplayIndex>4</DisplayIndex> 

       </Column> 

   </Columns> 

  <Parameters> 

       <Parameter> 

           <Variable>personneId</Variable> 

           <AttributUserConnected>True</AttributUserConnected> 

           <AttributeCode>personne_id</AttributeCode> 

      </Parameter> 

   </Parameters> 

</Config>

Tikketti XML li jiddeskrivu l-parametri bbażati fuq il-kuntest tal-utent.

  • Variable:
    • Definizzjoni: isem il-varjabbli użata fil-query SQL (mingħajr il-@).
    • Valur possibbli: sensiela ta’ karattri.
  • AttributUserConnected:
    • Definizzjoni: jispeċifika jekk il-parametru huwiex definit skont il-kuntest tal-utent attwali, jew jekk għandux jiddaħħal manwalment mill-interfaċċja.
    • Valur possibbli:
      • True: kuntest tal-utent
      • False: daħla manwali
  • AttributeCode:
    • Definizzjoni: kodiċi tal-attribut PSA.
    • Valur possibbli: sensiela ta’ karattri li tikkorrispondi għall-kodiċi PSA.