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

<languages />  

Pokud tvoříme KPI report z šablony a máme data v .s3db databázi, je nutné přidávání polí realizovat přes úpravu .xml souboru v note++ (či jiném editoru).

<br />


'''Postup.'''

1) zjistím, jestli xml obsahuje potřebnou tabulku, ze které chci čerpat data, pokud ne doplním ji do &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) Doplním názvy potřebných sloupců</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) doplním formát dat přidaného sloupce</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>