Zobrazení zdroje stránky TAS:Pokročilé/Pluginy/KPI/Tvorba KPI reportu/Tvorba KPI reportu z .s3db databáze (editace .xml)/en

<languages />  

If we are creating a KPI report from a template and we have data in the .s3db database, it is necessary to add fields by editing the .xml file in note++ (or another editor).

<br />


'''Procedure:'''

1) I find out if the xml contains the necessary table from which I want to extract data, if not I add it to &lt;Table Name=&quot;xxx&quot; /&gt;

<span style="color: rgb(51,153,102);">&lt;Query Type=&quot;SelectQuery&quot; Name=&quot;ServedJobStatistics&quot;&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Tables&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Table Name=&quot;ServedJobStatistics&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Table Name=&quot;SolutionStatistics&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Table Name=&quot;RouteStatistics&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Relation Type=&quot;Inner&quot; Parent=&quot;ServedJobStatistics&quot; Nested=&quot;SolutionStatistics&quot;&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;KeyColumn Parent=&quot;Solution&quot; Nested=&quot;OID&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;/Relation&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Relation Type=&quot;Inner&quot; Parent=&quot;ServedJobStatistics&quot; Nested=&quot;RouteStatistics&quot;&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;KeyColumn Parent=&quot;Route&quot; Nested=&quot;OID&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;/Relation&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;/Tables&gt;</span>

<span style="color: rgb(0,0,0);">2) I will add the names of the necessary columns</span>

<span style="color: rgb(51,153,102);">&lt;Columns&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Column Table=&quot;ServedJobStatistics&quot; Name=&quot;Latitude&quot; /&gt;</span><br />
<span style="color: rgb(51,153,102);"> &lt;Column Table=&quot;ServedJobStatistics&quot; Name=&quot;Longitude&quot; /&gt;</span>

<span style="color: rgb(0,0,0);"><span style="color: rgb(51,153,102);">&lt;/Columns&gt;</span><br />
</span>

<span style="color: rgb(0,0,0);">3) add the data format of the added column</span>

<span style="color: rgb(51,153,102);"> &lt;ResultSchema&gt;<br />
&lt;DataSet Name=&quot;SQL Data Source 1&quot;&gt;<br />
&lt;View Name=&quot;ServedJobStatistics&quot;&gt;<br />
&lt;Field Name=&quot;Latitude&quot; Type=&quot;Decimal&quot; /&gt;<br />
&lt;Field Name=&quot;Longitude&quot; Type=&quot;Decimal&quot; /&gt;</span>

<span style="color: rgb(51,153,102);"> &lt;/View&gt;<br />
&lt;/DataSet&gt;<br />
&lt;/ResultSchema&gt;</span>