dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #34229
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 17571: Analytics tables, including column for organisation unit. Not necessary for dhis but useful in SQ...
------------------------------------------------------------
revno: 17571
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2014-11-24 16:19:53 +0100
message:
Analytics tables, including column for organisation unit. Not necessary for dhis but useful in SQL queries.
modified:
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2014-11-03 01:54:15 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2014-11-24 15:19:53 +0000
@@ -325,9 +325,10 @@
String[] de = { quote( "de" ), "character(11) not null", "de.uid" };
String[] co = { quote( "co" ), "character(11) not null", "co.uid" };
+ String[] ou = { quote( "ou" ), "character(11) not null", "ous.organisationunituid" };
String[] level = { quote( "level" ), "integer", "ous.level" };
- columns.addAll( Arrays.asList( de, co, level ) );
+ columns.addAll( Arrays.asList( de, co, ou, level ) );
if ( isApprovalEnabled() )
{