View | Details | Raw Unified | Return to bug 8945
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt (-1 / +1 lines)
Lines 12-17 Link Here
12
12
13
<p>Choosing amount will change your results to appear as the sum of the amounts spent.</p>
13
<p>Choosing amount will change your results to appear as the sum of the amounts spent.</p>
14
14
15
<p><strong>See the full documentation for Acquisitions Statistics in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#acqstats">manual</a> (online).</strong></p>
15
<p><strong>See the full documentation for Acquisitions Statistics in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#acqstats">manual</a> (online).</strong></p>
16
16
17
[% INCLUDE 'help-bottom.inc' %]
17
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Patrons with the most Checkouts report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#mostcheckouts">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Patrons with the most Checkouts report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#mostcheckouts">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Patrons with no Checkouts report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#patnocheckouts">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Patrons with no Checkouts report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#patnocheckouts">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt (-1 / +1 lines)
Lines 8-14 Link Here
8
8
9
<p>Based on your selections, you may see some query information above your results table. You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>Based on your selections, you may see some query information above your results table. You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for Patron Statistics in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#patstats">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for Patron Statistics in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#patstats">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
14
14
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Most Circulation Items report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#mostcirculated">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Most Circulation Items report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#mostcirculated">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Items with no Checkouts report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#itemnocheckouts">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Items with no Checkouts report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#itemnocheckouts">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt (-1 / +1 lines)
Lines 8-14 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for Catalog Statistics in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#catstats">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for Catalog Statistics in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#catstats">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
14
14
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt (-1 / +1 lines)
Lines 18-23 Link Here
18
18
19
<p>Then when generating reports on the module you created the value for you will see an option to limit by the definition at the bottom of the usual filters.</p>
19
<p>Then when generating reports on the module you created the value for you will see an option to limit by the definition at the bottom of the usual filters.</p>
20
20
21
<p><strong>See the full documentation for the Reports Dictionary in the <a href="http://manual.koha-community.org/3.8/en/reportdic.html">manual</a> (online).</strong></p>
21
<p><strong>See the full documentation for the Reports Dictionary in the <a href="http://manual.koha-community.org/3.10/en/reportdic.html">manual</a> (online).</strong></p>
22
22
23
[% INCLUDE 'help-bottom.inc' %]
23
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt (-34 / +29 lines)
Lines 38-44 Link Here
38
38
39
<ul><li>This is optional, if you want the results to come out as they are in the table, just leave this section blank.</li></ul>
39
<ul><li>This is optional, if you want the results to come out as they are in the table, just leave this section blank.</li></ul>
40
40
41
<h1>Edit Reports</h1>
41
<h2>Edit Reports</h2>
42
42
43
<p>Custom reports can be edited in their entirety from the Saved Guided Reports page.</p>
43
<p>Custom reports can be edited in their entirety from the Saved Guided Reports page.</p>
44
44
Lines 51-102 Link Here
51
51
52
<h2>Report from SQL</h2>
52
<h2>Report from SQL</h2>
53
53
54
<p>In addition to the report wizard, you have the option to write your own queries using SQL. To find reports written by other Koha users, visit the Koha Wiki: <a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library">http://wiki.koha-community.org/wiki/SQL_Reports_Library</a>. You can also find your database structure in /installer/data/mysql/kohastructure.sql or online at: <a href="http://schema.koha-community.org">http://schema.koha-community.org</a>.</p>
54
<p>In addition to the report wizard, you have the option to write your own queries using SQL. To find reports written by other Koha users, visit the Koha Wiki: <a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="_top">http://wiki.koha-community.org/wiki/SQL_Reports_Library</a>. You can also find your database structure in /installer/data/mysql/kohastructure.sql or online at: <a href="http://schema.koha-community.org/" target="_top">http://schema.koha-community.org</a>.</p>
55
55
56
<p>To add your query, click the link to 'Create from SQL' on the main reports module or the New button at the top of the Saved Reports page.</p>
56
<p>To add your query, click the link to 'Create from SQL' on the main reports module or the New button at the top of the Saved Reports page.</p>
57
57
58
<p>Fill in the form presented</p>
58
<p>Fill in the form presented</p>
59
<ul>
59
<ul>
60
    <li>The name is what will appear on the Saved Reports page to help you identify the report later. It will also be searchable using the filters found the left of the Saved Reports page.</li>
60
	<li>The 'Name' is what will appear on the Saved Reports page to help you identify the report later. It will also be searchable using the filters found the left of the Saved Reports page.</li>
61
    <li>Notes will also appear on the Saved Reports page, this can be used to provide more details about the report or tips on how to enter values when it runs</li>
61
	<li>You can use the 'Report group' to organize your reports so that you can easily filter reports by groups. Report groups are set in the REPORT_GROUP authorized value category.</li>
62
    <li>The type should always be 'Tabular' at this time since the other formats have not been implemented</li>
62
	<li>You can use 'Report subgroup' to further organize your reports so that you can easily filter reports by groups and subgroups. Report subgroups are set in the REPORT_SUBGROUP authorized value category.</li>
63
    <li>In the SQL box you will type or paste the SQL for the report</li>
63
	<li>'Report is public' should be left to the default of 'No' in most cases. A report can be made public if you intend to allow access to it through the JSON webservice interface. This is a system that can be used by developers to make custom presentations of the data from the report, for example displaying it using a graphing API. To learn more speak to your local developer.
64
    <li>If you feel that your report might be too resource intensive you might want to consider using runtime parameters to your query. Runtime parameters basically make a filter appear before the report is run to save your system resources.
65
<ul>
64
<ul>
66
    <li><strong>Note:</strong> There is a limit of 10,000 records put on SQL statements entered in Koha. To get around this you want to add 'LIMIT 100000' to the end of your SQL statement (or any other number above 10,000.</li>
65
	<li>A public report is accessible via a URL that looks like this: http://MYOPAC/cgi-bin/koha/svc/report?id=REPORTID</li>
67
    <li>There is a specific syntax that Koha will understand as 'ask for values when running the report'. The syntax is &lt;&lt;Question to ask|authorized_value&gt;&gt;.</li>
66
</ul>
68
    <li>The &lt;&lt; and &gt;&gt; are just delimiters. You must put &lt;&lt; at the beginning and &gt;&gt; at the end of your parameter</li>
67
</li>
69
    <li>The 'Question to ask' will be displayed on the left of the string to enter.</li>
68
	<li>'Notes' will also appear on the Saved Reports page, this can be used to provide more details about the report or tips on how to enter values when it runs</li>
70
    <li>The authorized_value can be omitted if not applicable. If it contains an authorized value category, or branches or itemtype or categorycode, a list with the Koha authorized values will be displayed instead of a free field Note that you can have more than one parameter in a given SQL Note that entering nothing at run time won't probably work as you expect. It will be considered as "value empty" not as "ignore this parameter". For example entering nothing for : "title=&lt;&lt;Enter title&gt;&gt;" will display results with title='' (no title). If you want to have to have something not mandatory, use "title like &lt;&lt;Enter title&gt;&gt;" and enter a % at run time instead of nothing</li>
69
	<li>The type should always be 'Tabular' at this time since theother formats have not been implemented</li>
70
	<li>In the 'SQL' box you will type or paste the SQL for the report</li>
71
	<li>If you feel that your report might be too resource intensive you might want to consider using runtime parameters to your query. Runtime parameters basically make a filter appear before the report is run to save your system resources.There is a specific syntax that Koha will understand as 'ask for values when running the report'. The syntax is &lt;&lt;Question to ask|authorized_value&gt;&gt;.
72
<ul>
73
	<li>The &lt;&lt; and &gt;&gt; are just delimiters. You must put &lt;&lt; at the beginning and &gt;&gt; at the end of your parameter</li>
74
	<li>The 'Question to ask' will be displayed on the left of the string to enter.</li>
75
	<li>The authorized_value can be omitted if not applicable. If it contains an authorized value category, or branches or itemtype or categorycode, a list with the Koha authorized values will be displayed instead of a free field Note that you can have more than one parameter in a given SQL Note that entering nothing at run time won't probably work as you expect. It will be considered as "value empty" not as "ignore this parameter". For example entering nothing for : "title=&lt;&lt;Enter title&gt;&gt;" will display results with title='' (no title). If you want to have to have something not mandatory, use "title like &lt;&lt;Enter title&gt;&gt;" and enter a % at run time instead of nothing</li>
71
</ul>
76
</ul>
72
73
<p>Examples:</p>
77
<p>Examples:</p>
74
75
<ul>
78
<ul>
76
    <li>SELECT surname, firstname<br />
79
	<li>SELECT surname, firstname<br />
77
    FROM borrowers<br />
80
FROM borrowers <br />
78
    WHERE branchcode=&lt;&lt;Enter patrons library|branches&gt;&gt; AND surname like &lt;&lt;Enter filter for patron surname (% if none)&gt;&gt;</li>
81
WHERE branchcode=&lt;&lt;Enter patrons library|branches&gt;&gt; AND surname like &lt;&lt;Enter filter for patron surname (% if none)&gt;&gt;</li>
79
    <li>SELECT *<br />
82
	<li>SELECT * <br />
80
    FROM items<br />
83
FROM items <br />
81
    WHERE homebranch = &lt;&lt;Pick your branch|branches&gt;&gt; and barcode like &lt;&lt;Partial barcode value here (use % for wildcard)&gt;&gt;</li>
84
WHERE homebranch = &lt;&lt;Pick your branch|branches&gt;&gt; AND barcode like &lt;&lt;Partial barcode value here&gt;&gt;</li>
82
</ul>
85
</ul>
83
</li>
86
</li>
84
    <li style="background-color: #ffe599;">Tip: To generate a date picker calendar to the right of the field when running a report you can use the 'date' keyword like this: &lt;&lt;Enter Date|date&gt;&gt;</li>
87
	<li>Tip: To generate a date picker calendar to the right of the field when running a report you can use the 'date' keyword like this: &lt;&lt;Enter Date|date&gt;&gt;</li>
85
    <li style="background-color: #ffe599;">Tip: You have to put "%" in a text box to 'leave it blank'. Otherwise, it literally looks for "" (empty string) as the value for the field.</li>
88
	<li>Tip: You have to put "%" in a text box to 'leave it blank'. Otherwise, it literally looks for "" (empty string) as the value for the field.</li>
86
    <li style="color: #990000;">Important: In addition to using any authorized value code to generate a dropdown, you can use the following values as well: Branches (branches), Item Types (itemtypes) and Patron Categories (categorycode). For example a branch pull down would be generated like this &lt;&lt;Branch|branches&gt;&gt;</li>
89
	<li style="color: #990000">Important: In addition to using any authorized value code to generate a dropdown, you can use the following values as well: Branches (branches), Item Types (itemtypes) and Patron Categories (categorycode). For example a branch pull down would be generated like this &lt;&lt;Branch|branches&gt;&gt;</li>
87
</ul>
90
</ul>
88
91
89
<p>Once everything is entered click the 'Save Report' button and you'll be presented with options to run it. Once a report is saved you do not have to recreate it you can simply find it on the Saved Reports page and run or edit it.</p>
92
<p>Note: There is a limit of 10,000 records put on SQL statements entered in Koha. To get around this you want to add 'LIMIT 100000' to the end of your SQL statement (or any other number above 10,000.</p>
90
91
<h1>Questions</h1>
92
93
93
<p><strong>What are duration and visibility?</strong></p>
94
<p>Once everything is entered click the 'Save Report' button and you'll be presented with options to run it. Once a report is saved you do not have to recreate it you can simply find it on the Saved Reports page and run or edit it.</p>
94
<p>The duration field may be visible or not, don't worry if you don't see it. If you see it, it says how long a report run is kept in Koha and, any subsequent re-run will in fact display the result run the 1st time</p>
95
<p>The visibility field specify if your report is accessible <strong>without authentication</strong> from the OPAC. Reports can be retrieved from the following URLs:
96
<ul><li> opac: http://localhost/cgi-bin/koha/svc/report?id=1</li>
97
<li>intranet: http://localhost:8080/cgi-bin/koha/svc/report?id=1</li>
98
</ul>
99
<p>(replace localhost and localhost:8080 with the appropriate URLs)</p>
100
95
101
<p><strong>Is there a repository for reports?</strong></p>
96
<p><strong>Is there a repository for reports?</strong></p>
102
97
Lines 104-109 Link Here
104
99
105
<p>NEKLS also has a great page (<a href="http://www.nexpresslibrary.org/training/reports-training/" target="_new">http://www.nexpresslibrary.org/training/reports-training/</a>) with a list of reports they have written.</p>
100
<p>NEKLS also has a great page (<a href="http://www.nexpresslibrary.org/training/reports-training/" target="_new">http://www.nexpresslibrary.org/training/reports-training/</a>) with a list of reports they have written.</p>
106
101
107
<p><strong>See the full documentation for Custom Reports in the <a href="http://manual.koha-community.org/3.8/en/reports.html#customreports">manual</a> (online).</strong></p>
102
<p><strong>See the full documentation for Custom Reports in the <a href="http://manual.koha-community.org/3.10/en/reports.html#customreports">manual</a> (online).</strong></p>
108
103
109
[% INCLUDE 'help-bottom.inc' %]
104
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Average Loan Time report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#avloantime">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Average Loan Time report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#avloantime">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt (-1 / +1 lines)
Lines 19-24 Link Here
19
	<li>For a single day, an example would be: 11/15/2009 to 11/16/2009 to find what circulated on the 15th</li>
19
	<li>For a single day, an example would be: 11/15/2009 to 11/16/2009 to find what circulated on the 15th</li>
20
</ul>
20
</ul>
21
21
22
<p><strong>See the full documentation for Circulation Statistics in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#circstats">manual</a> (online).</strong></p>
22
<p><strong>See the full documentation for Circulation Statistics in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#circstats">manual</a> (online).</strong></p>
23
23
24
[% INCLUDE 'help-bottom.inc' %]
24
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt (-1 / +1 lines)
Lines 16-21 Link Here
16
		</ul>
16
		</ul>
17
	</div>	
17
	</div>	
18
18
19
<p><strong>See the full documentation for the Lost Items report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#lostreport">manual</a> (online).</strong></p>
19
<p><strong>See the full documentation for the Lost Items report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#lostreport">manual</a> (online).</strong></p>
20
	
20
	
21
[% INCLUDE 'help-bottom.inc' %]
21
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt (-1 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for the Catalog by Item Type report in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#catbyitem">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for the Catalog by Item Type report in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#catbyitem">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt (-1 / +1 lines)
Lines 19-24 Link Here
19
</li>
19
</li>
20
</ul>
20
</ul>
21
21
22
<p><strong>See the full documentation for Reports in the <a href="http://manual.koha-community.org/3.8/en/reports.html">manual</a> (online).</strong></p>
22
<p><strong>See the full documentation for Reports in the <a href="http://manual.koha-community.org/3.10/en/reports.html">manual</a> (online).</strong></p>
23
23
24
[% INCLUDE 'help-bottom.inc' %]
24
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reserves_stats.tt (-1 / +1 lines)
Lines 10-15 Link Here
10
10
11
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
11
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
12
12
13
<p><strong>See the full documentation for Holds Statistics in the <a href="manual.koha-community.org/3.8/en/statsreports.html#holdstats">manual</a> (online).</strong></p>
13
<p><strong>See the full documentation for Holds Statistics in the <a href="manual.koha-community.org/3.10/en/statsreports.html#holdstats">manual</a> (online).</strong></p>
14
14
15
[% INCLUDE 'help-bottom.inc' %]
15
[% INCLUDE 'help-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt (-2 / +1 lines)
Lines 8-13 Link Here
8
8
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
9
<p>You can also choose to export to a file that you can manipulate to your needs.</p>
10
10
11
<p><strong>See the full documentation for Serials Statistics in the <a href="http://manual.koha-community.org/3.8/en/statsreports.html#serialstats">manual</a> (online).</strong></p>
11
<p><strong>See the full documentation for Serials Statistics in the <a href="http://manual.koha-community.org/3.10/en/statsreports.html#serialstats">manual</a> (online).</strong></p>
12
12
13
[% INCLUDE 'help-bottom.inc' %]
13
[% INCLUDE 'help-bottom.inc' %]
14
- 

Return to bug 8945