Léim go dtí an t-ábhar

Tuairisc a chruthú, a mhodhnú nó a scriosadh

Cumraítear an tuairisc le comhad XML. Ní mór duit na nithe seo a leanas a shainiú:

  • An fiosrúchán ar bhunachar sonraí CyberElements Identity chun an fhaisnéis atá uait a aisghabháil,
  • Airíonna gach colúin atá le taispeáint, i bhformáid XML: cineál oibiachta, ainm i mbunachar sonraí SQL, ainm le taispeáint, innéacs taispeána, srl.
  • Roghanna taispeána na ngraf (barrchairt, píchairt, poncanna daite).

Cliceáil ar an gcnaipe “New report” chun tuairisc nua a chruthú agus a chumrú.

Roghnaigh tuairisc agus cliceáil ar an gcnaipe “Modify” chun a cumraíocht a mhodhnú.

New report

Airíonna tuairisce

Paraiméadar Cur síos Cineálacha agus luachanna féideartha
Name Ainm taispeána na tuairisce. Teaghrán carachtar. Éigeantach.
Code Comhfhreagraíonn sé do ID na hoibiachta. Caithfidh a luach a bheith uathúil i measc na dtuairiscí uile. Teaghrán carachtar, gan spásanna ná carachtair speisialta. Éigeantach
Category Catagóir na tuairisce ina dtaispeánfar liosta na dtuairiscí. Liosta catagóirí réamhshainithe.
Description Teaghrán carachtar.
XML Clibeanna XML a dhéanann cur síos ar an bhfiosrúchán SQL i mbunachar sonraí Hpliance, ar airíonna gach colúin sa tuairisc agus ar airíonna na n-eilimintí grafacha. Téacs i bhformáid XML.
Choice of report template Teimpléad grafach don tuairisc (chomh maith leis an tábla sonraí). Without chart, Histogram, Stacked histogram, Pie chart nó Color ball by threshold.
With parameters Ligeann sé duit athróga a iontrálann an t-úsáideoir a chur leis. Beidh ort an chlib a chur leis an XML. Ticbhosca.

An XML a scríobh do thuairisc shimplí

 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>

Sampla: liosta na n-úsáideoirí gan uimhir theileafóin

 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>

Clibeanna XML a dhéanann cur síos ar cholúin tuairisce

Clib XML Sainmhíniú Luachanna féideartha
Name Ainm an réimse mar atá sé sainithe san fhiosrúchán SQL. Teaghrán carachtar.
Column_Link_Id Úsáidtear é chun colúin a chruthú ina bhfuil sonraí inchliceáilte. Comhfhreagraíonn sé d'ainm an cholúin ina bhfuil an ID a úsáidtear chun an nasc a bhainistiú. Teaghrán carachtar. Roghnach
ObjectType Cineál sprioc-oibiachta an naisc inchliceáilte (Identity, struchtúr). Identity = 1 => Atreorú chuig an leathanach userDetails.aspx
Structure = 2 => Atreorú chuig an leathanach structure.aspx
Roghnach
DisplayName Ainm an cholúin atá le taispeáint sa chomhéadan. Teaghrán carachtar.
Visible Léiríonn sé an dtaispeántar nó an bhfoluítear an colún. 'TRUE' nó 'FALSE'
DisplayIndex Innéacs an cholúin (ord taispeána). Slánuimhir níos mó ná 0

Paraiméadair a iontrálann an t-úsáideoir a chur leis an tuairisc: an chlib

Roghnaigh an ticbhosca “With parameters” agus cuir na clibeanna seo a leanas leis an 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>

Sampla: ceadanna atá ar tí dul in éag

 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>

Clibeanna XML in <Parameter> a dhéanann cur síos ar na paraiméadair is féidir leis an úsáideoir a iontráil:

Clib XML Sainmhíniú Luachanna féideartha
Variable Ainm na hathróige a úsáidtear san fhiosrúchán SQL (gan an @). Teaghrán carachtar.
Data Type An cineál oibiachta CyberElements Identity a fhreagraíonn don pharaiméadar. Mura cineál oibiachta bunúsach é (dáta, teaghrán, slánuimhir, srl.), is liosta anuas ina bhfuil na luachanna féideartha a bheidh sa pharaiméadar. 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 Lipéad atá le taispeáint don úsáideoir. Teaghrán carachtar.
AttributeCode Cód tréithe PSA. Teaghrán carachtar a fhreagraíonn do chód PSA.
Mandatory Léiríonn sé an gceanglaítear ar an úsáideoir luach a shonrú. 'TRUE' nó 'FALSE
DefaultValue I gcás paraiméadar roghnach, is é seo an luach réamhshocraithe a chuirtear isteach mura n-iontrálann an t-úsáideoir aon rud. Teaghrán carachtar.

Na paraiméadair do ghrafaic a shainiú

Roghnaigh an teimpléad grafach ón liosta anuas agus cuir na clibeanna seo a leanas leis an 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

Cuir na clibeanna seo a leanas isteach sa chlib :

 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>

Ciorcal daite de réir tairsí

Cuir na clibeanna seo a leanas isteach sa chlib :

 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>

Ainmneacha na gcolún i dtuairisc a aistriú

Is féidir na colúin agus na luachanna atá i dtorthaí tuairisce a aistriú go roinnt teangacha.

Seo a leanas sampla de thuairisc ina bhfuil na colúin aistrithe:

 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>

Clib XML

  • Internationaldisplayname:
    • Sainmhíniú: Clib a úsáidtear chun ainmneacha na gcolún a thugann an tuairisc ar ais a aistriú. Ní mór an oiread cásanna den chlib seo a bheith ann agus atá de theangacha cumraithe i CyberElements Identity.
    • Tréith: Lang=“<\language_code>” áit a seasann <\language_code> don chód teanga atá sainithe sna socruithe teanga sa chluaisín General > Application Settings.
    • Luach féideartha: Teaghrán carachtar. Ainm an cholúin a thaispeántar sa tuairisc don teanga.
  • CultureColumnName:
    • Sainmhíniú: Sainmhíniú ar an XML cultúir a úsáidtear chun ábhar an tábla a ghineann an tuairisc a aistriú.
    • Tréith: Prop=“<\XML_Attribute>” áit a seasann <\XML_Attribute> do thréith an airí XML a fhreagraíonn do na luachanna éagsúla sa cholún.
    • Luach féideartha: Teaghrán carachtar. Colún cultúir an fhiosrúcháin SQL.

Tuairisc a thaispeáint bunaithe ar chomhthéacs an úsáideora

I leagan 4000 de Hpliance, is féidir paraiméadar dofheicthe a chur le tuairisc, paraiméadar a shainítear de réir an duine a ritheann an tuairisc. Taispeánfar na luachanna sa tuairisc de réir luachanna tréithe úsáideora. Mar shampla, ní fheicfidh úsáideoirí ach na torthaí dá n-eagraíocht féin.

Sampla tuairisce: liostaigh na ceadanna uile atá sannta do na haitheantais i struchtúr ar leith. Taispeáin sloinnte, céadainmneacha, ceadanna agus feidhmchláir na n-aitheantas uile a bhfuil a dtréith struchtúir “Responsibility” ag teacht le tréith struchtúir an úsáideora atá ceangailte.

  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>

Clibeanna XML a dhéanann cur síos ar na paraiméadair bunaithe ar chomhthéacs an úsáideora.

  • Variable:
    • Sainmhíniú: Ainm na hathróige a úsáidtear san fhiosrúchán SQL (gan an @).
    • Luach féideartha: Teaghrán carachtar.
  • AttributUserConnected:
    • Sainmhíniú: Sonraíonn sé an sainítear an paraiméadar bunaithe ar chomhthéacs an úsáideora reatha, nó an gcaithfear é a iontráil de láimh ón gcomhéadan.
    • Luach féideartha:
      • True: comhthéacs an úsáideora
      • False: iontráil de láimh
  • AttributeCode:
    • Sainmhíniú: Cód tréithe PSA.
    • Luach féideartha: Teaghrán carachtar a fhreagraíonn don chód PSA.