Hi Jason Pickering,
On using your two statements to resolve my issue:
update sqlview set sqlviewid=viewid;
alter table sqlview drop column viewid;
For some reason on dropping the viewed column from the sqlview table , another
error
Error:
ERROR: cannot drop table sqlview
revno: 18290
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Tue 2015-02-17 14:22:47 +0700
message:
extended getAll/getBetween to support multiple orders, also added new
OrderOptions class to enable criteria based order in
Noted.
Thanks Jason for helping.
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 17 February 2015 12:36 AM
To: Adebusoye Anifalaje
Cc: Arthur Gwatidzo; dhis2-devs
Subject: Re: [Dhis2-devs] Error Creating An SQL View through DHIS2 Front End
Actually not, have a nice ear
revno: 18288
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Tue 2015-02-17 12:01:28 +0700
message:
implemented getAll/getBetween with property order (only single order
supported right now) + testing
added:
dhis-2/dhis-a
Actually not, have a nice early morning with a cup of coffee, but thanks
for the concern, but maybe should have laid off that second cup as it seems
I sent out another email to quickly. Lets try again
I am just taking the statements from the TableAlteror.java, so you can use
that for reference in
HiJason you must be having a long night as you probably meant update sqlview set sqlviewid=viewid;CheersBusoyeSent from my Samsung Galaxy smartphone. Original message From: Jason Pickering Date:16/02/2015 9:48 pm (GMT+00:00) To: Arthur Gwatidzo Cc: dhis2-devs Subject: Re: [Dhis
Hi Arthur,
Here is the problem.
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"viewid" violates not-null constraint Detail: Failing row contains (null,
RidpdaReportSQL, a0rnEhRIhG3, null, 2015-02-16
viewid has been renamed to "sqlviewid" but looks like your version of
Sorry..send that one too fast
Here was the SQL you need
update sqlview set sqlviewid=viweid;
update sqlview set sqlviewid=viweid;
Best regards,
Jason
On Tue, Feb 17, 2015 at 5:47 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:
> Hi Arthur,
>
> Here is the problem.
>
> Caused by: org
revno: 18287
committer: Tran Chau
branch nick: dhis2
timestamp: Tue 2015-02-17 00:57:07 +0700
message:
Fixed bug in Add/Update program indicator.
modified:
dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramIndicator.java
d
Merge authors:
Jan Henrik Øverland (janhenrik-overland)
revno: 18286 [merge]
committer: Jan Henrik Overland
branch nick: dhis2
timestamp: Mon 2015-02-16 17:05:45 +0100
message:
ER EV count type replaced by output type: event/enrollme
Dear all We are still having a serious issue on data approval on version 2.17
where We had approved data in dhis 2.16 where all data set was locked,and after
upgrading to 2.17,all dataset became unlocked.Now users can Modify the data
what ever they want.I have raised this issue many times but ye
** Description changed:
Dear all,
I'm not sure that is a bug or that is what you want the system work, but
I will describe the problem here for you to check:
- If my laptop system time is wrong, for example the year 2009 instead of 2015.
Then I open data entry module, I'm not able to
Hi Devs,
I am encountering an error when creating an SQL View using the front-end
(Data Administration Utility of DHIS2).
I tested this query in Postgre SQL and everything is okay.
Simple SQL View
SELECT de.name AS dataelementname,dv.value as Value,dv.comment, ou.uid As
OrgUnitUID, ou.
revno: 18285
committer: Abyot Asalefew Gizaw
branch nick: dhis2
timestamp: Mon 2015-02-16 15:00:26 +0100
message:
minor
modified:
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dashboard/dashboard-
revno: 18284
committer: Tran Chau
branch nick: dhis2
timestamp: Mon 2015-02-16 20:13:51 +0700
message:
Fixed - Run test fail.
modified:
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/program/ProgramIndicatorSer
revno: 18283
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Mon 2015-02-16 14:05:07 +0100
message:
Moved EventOutputType to api
renamed:
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics
revno: 18282
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Mon 2015-02-16 13:28:45 +0100
message:
Event report, removed constants
modified:
dhis-2/dhis-api/src/main/java/org/hisp/dhis/eventreport/EventReport.java
--
Thanks Lars.
Kind regards,
Busoye
……..
Tel: +44 7901 740 757
Skype: busoye
> On 16 Feb 2015, at 11:56, Lars Helge Øverland wrote:
>
> Hi Busoye,
>
> made a fix, you can now access future years in reporting rates summary (and
> future periods within the current year for other period
revno: 18281
committer: Tran Chau
branch nick: dhis2
timestamp: Mon 2015-02-16 19:03:19 +0700
message:
Minor fix.
modified:
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-program/src/main/webapp/dhis-web-maintenance-progra
revno: 18280
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Mon 2015-02-16 12:56:57 +0100
message:
Reporting rate summary, removed future period filter
modified:
dhis-2/dhis-web/dhis-web-reporting/src/main/webapp/dhis-
Hi Busoye,
made a fix, you can now access future years in reporting rates summary (and
future periods within the current year for other period types) in trunk,
2.18 and 2.17.
Lars
On Mon, Feb 16, 2015 at 12:29 PM, Adebusoye Anifalaje
wrote:
> Hi developers,
>
> We have a use case where we nee
revno: 18279
committer: Tran Chau
branch nick: dhis2
timestamp: Mon 2015-02-16 18:46:32 +0700
message:
Improve Program Indicators.
modified:
dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramIndicator.java
dhis-2/dhis-api/
revno: 18278
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Mon 2015-02-16 16:46:42 +0700
message:
minor
modified:
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/utils/IdSchemes.java
--
lp:dhi
revno: 18277
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Mon 2015-02-16 16:43:40 +0700
message:
remove ExportOptions class, replace with IdSchemes
removed:
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/his
Public bug reported:
Dear all,
I'm not sure that is a bug or that is what you want the system work, but
I will describe the problem here for you to check:
If my laptop system time is wrong, for example the year 2009 instead of 2015.
Then I open data entry module, I'm not able to see the period
revno: 18276
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Mon 2015-02-16 15:53:40 +0700
message:
add index for Translation objectproperty composite key
modified:
dhis-2/dhis-services/dhis-service-core/src/main/resourc
revno: 18275
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Mon 2015-02-16 15:40:56 +0700
message:
new getValue helper for IdSchemes
modified:
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/util
revno: 18274
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Mon 2015-02-16 15:37:44 +0700
message:
implement identifier schemes for /api/events
added:
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/d
28 matches
Mail list logo
