I want get data element value by filter by org group,but I find there only filter one org group in dhis2, I want to know how to filter with more group (org is the interset of grp1 ,grp2,…)
1) Creating a group set
2) Creating multiple groups as members of the group set
3) Rebuild the resource tables
4) Execute the data mart
5) Download your data with MyDatamart into a new Excel Pivot table.
The group set will be available as a field, which you can filter on.
Regards,
Jason
···
On Sun, Sep 23, 2012 at 3:59 AM, easy <lin_xd@126.com> wrote:
Hello,
I want get data element value by filter by org group,but I find there only
filter one org group in dhis2, I want to know how to filter with more group
(org is the interset of grp1 ,grp2,...)
also there isn't filter by groupset?
--
此致
I want get data element value by filter by org group,but I find there only filter one org group in dhis2, I want to know how to filter with more group (org is the interset of grp1 ,grp2,…)
I want get data element value by filter by org group,but I find there only filter one org group in dhis2, I want to know how to filter with more group (org is the interset of grp1 ,grp2,…)
If I understood you correctly, this should provide a path to get data
elements for each orgunit in different groups.
Regards,
Jason
···
On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
Hi,Knut,
I have translated DHIS2 to chinese. glad to contribute.
I hope provide the dataelement of the org belong to grp1 and grp2 with
webapi,is there a way do it ?
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
At 2012-09-23 17:01:25,"Knut Staring" <knutst@gmail.com> wrote:
Hello Easy, have you translated DHIS2 to Chinese? It would be great if you
could contribute back.
Best regards,
Knut
Sent from my mobile
On Sep 23, 2012 9:00 AM, "easy" <lin_xd@126.com> wrote:
Hello,
I want get data element value by filter by org group,but I find there only
filter one org group in dhis2, I want to know how to filter with more group
(org is the interset of grp1 ,grp2,...)
also there isn't filter by groupset?
--
此致
My mean is: for example: we have defined two orggrp1( org1,org2,org3,org4,org5) ,orggrp2(org3,org4,org5,org6), I want only get the dataelement and indiator values of (orggrp1) ∩ (orggrp2) ={ org3,org4,org5}. not
(orggrp1) ∪ (orggrp2) ={ org1,org2,org3,org4,org5,org6}
···
–
此致
林晓东
莫愁前路无知己,天下谁人不识君。
At 2012-09-24 11:49:20,"Jason Pickering" <jason.p.pickering@gmail.com> wrote:
>Hi Easy,
>
>Nice that you have translated it to Chinese.
>
>In regards to your other query, I think you can do this by something
>like this (login with admin/district)
>
>1) Gettting all orgunits in a particular group
>
>e.g. http://apps.dhis2.org/dev/api/organisationUnitGroups/RXL3lPSK8oG.xml
>
>2) You can get the datasets which the orgunit belongs to
>
>e.g. http://apps.dhis2.org/dev/api/organisationUnits/GvFqTavdpGE.xml
>
>3) Each dataset is associated with data elements
>
>e.g http://apps.dhis2.org/dev/api/dataSets/lyLU2wR22tC.xml
>
>If I understood you correctly, this should provide a path to get data
>elements for each orgunit in different groups.
>
>Regards,
>Jason
>
>
>On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
>> Hi,Knut,
>> I have translated DHIS2 to chinese. glad to contribute.
>> I hope provide the dataelement of the org belong to grp1 and grp2 with
>> webapi,is there a way do it ?
>>
>>
>> --
>> 此致
>>
>> 林晓东
>>
>> 莫愁前路无知己,天下谁人不识君。
>> At 2012-09-23 17:01:25,"Knut Staring" <knutst@gmail.com> wrote:
>>
>> Hello Easy, have you translated DHIS2 to Chinese? It would be great if you
>> could contribute back.
>>
>> Best regards,
>> Knut
>>
>> Sent from my mobile
>>
>> On Sep 23, 2012 9:00 AM, "easy" <lin_xd@126.com> wrote:
>>>
>>> Hello,
>>> I want get data element value by filter by org group,but I find there only
>>> filter one org group in dhis2, I want to know how to filter with more group
>>> (org is the interset of grp1 ,grp2,...)
>>> also there isn't filter by groupset?
>>> --
>>> 此致
>>>
>>> easy
>>>
>>> 莫愁前路无知己,天下谁人不识君。
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help : https://help.launchpad.net/ListHelp
>>
Not sure how easy this would be through the WebAPI. I would probably
tend opt to create an SQL view and get the data this way through the
API. Maybe something like
SELECT * FROM datavalue where sourceid in (SELECT DISTINCT
organisationunitid from orgunitgroupmembers where
orgunitgroupiorgunitgrp1.id d = )
AND sourceid IN (SELECT DISTINCT organisationunitid from
orgunitgroupmembers where orgunitgroupid = orgunitgrp2.id )
where orgunitgrp1.id and orgunitgrp2.id would correspond to the IDs
of the orgunit groups.
Of course, you might need to adjust the query just a bit if you wanted
aggregated data values, indicators, and you would probably need to
filter on certain periodicites of course.
The result set could then be retrieved through the WebAPI as described here.
On Mon, Sep 24, 2012 at 6:05 AM, easy <lin_xd@126.com> wrote:
Thanks for your quick answer.
My mean is: for example: we have defined two orggrp1(
org1,org2,org3,org4,org5) ,orggrp2(org3,org4,org5,org6), I want only get the
dataelement and indiator values of (orggrp1) ∩ (orggrp2) ={
org3,org4,org5}. not
If I understood you correctly, this should provide a path to get data
elements for each orgunit in different groups.
Regards,
Jason
On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
Hi,Knut,
I have translated DHIS2 to chinese. glad to contribute.
I hope provide the dataelement of the org belong to grp1 and grp2 with
webapi,is there a way do it ?
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
At 2012-09-23 17:01:25,"Knut Staring" <knutst@gmail.com> wrote:
Hello Easy, have you translated DHIS2 to Chinese? It would be great if
you
could contribute back.
Best regards,
Knut
Sent from my mobile
On Sep 23, 2012 9:00 AM, "easy" <lin_xd@126.com> wrote:
Hello,
I want get data element value by filter by org group,but I find there
only
filter one org group in dhis2, I want to know how to filter with more
group
(org is the interset of grp1 ,grp2,...)
also there isn't filter by groupset?
--
此致
Great. The best way for us to incorporate the translations is if you
can go to the root of your DHIS2 source code and run the following
statement from the command line:
bzr dif > ch.patch
Please just email me the resulting file (called ch.patch).
Thanks a lot,
Knut
···
On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
Hi,Knut,
I have translated DHIS2 to chinese. glad to contribute.
在 2012-09-24 17:29:08,"Knut Staring" <knutst@gmail.com> 写道:
>On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
>> Hi,Knut,
>> I have translated DHIS2 to chinese. glad to contribute.
>
>Great. The best way for us to incorporate the translations is if you
>can go to the root of your DHIS2 source code and run the following
>statement from the command line:
>
> bzr dif > ch.patch
>
>Please just email me the resulting file (called ch.patch).
>
>Thanks a lot,
>Knut
the bzr dif get nothing, I copy out the files to a zip file.
I also another question: how to get the aggregated data at any time? not just last year,last month, I want get the year 2011,2009, or 201101.
–
此致
林晓东
莫愁前路无知己,天下谁人不识君。
在 2012-09-24 17:29:08,"Knut Staring" <knutst@gmail.com> 写道: >On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote: >> Hi,Knut, >> I have translated DHIS2 to chinese. glad to contribute. > >Great. The best way for us to incorporate the translations is if you >can go to the root of your DHIS2 source code and run the following >statement from the command line: > > bzr dif > ch.patch > >Please just email me the resulting file (called ch.patch). > >Thanks a lot, >Knut
Hi Easy,
First, WOW. Amazing you have translated just about everything.
I merged your files with trunk and will commit them now . There have
been a number of changes to the translations since the last time you
updated the strings, but they will be available soon in trunk so you
can work off of the latest version.
Best regards,
Jason
···
On Mon, Sep 24, 2012 at 7:23 PM, Knut Staring <knutst@gmail.com> wrote:
Sorry, spelling mistake. It should be like this:
bzr diff > ch.patch
Please try again.
Thanks, Knut
Sent from my mobile
On Sep 25, 2012 12:04 AM, "easy" <lin_xd@126.com> wrote:
Hi,
the bzr dif get nothing, I copy out the files to a zip file.
I also another question: how to get the aggregated data at any time?
not just last year,last month, I want get the year 2011,2009, or 201101.
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
在 2012-09-24 17:29:08,"Knut Staring" <knutst@gmail.com> 写道:
>On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
>> Hi,Knut,
>> I have translated DHIS2 to chinese. glad to contribute.
>
>Great. The best way for us to incorporate the translations is if you
>can go to the root of your DHIS2 source code and run the following
>statement from the command line:
>
> bzr dif > ch.patch
>
>Please just email me the resulting file (called ch.patch).
>
>Thanks a lot,
>Knut
I translated dis2 on everyday almost after I've pulled the trunk
···
At 2012-09-25 01:37:15,"Jason Pickering" <jason.p.pickering@gmail.com> wrote:
Hi Easy,
First, WOW. Amazing you have translated just about everything.
I merged your files with trunk and will commit them now . There have
been a number of changes to the translations since the last time you
updated the strings, but they will be available soon in trunk so you
can work off of the latest version.
Best regards,
Jason
On Mon, Sep 24, 2012 at 7:23 PM, Knut Staring <knutst@gmail.com> wrote:
Sorry, spelling mistake. It should be like this:
bzr diff > ch.patch
Please try again.
Thanks, Knut
Sent from my mobile
On Sep 25, 2012 12:04 AM, "easy" <lin_xd@126.com> wrote:
Hi,
the bzr dif get nothing, I copy out the files to a zip file.
I also another question: how to get the aggregated data at any time?
not just last year,last month, I want get the year 2011,2009, or 201101.
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
在 2012-09-24 17:29:08,"Knut Staring" <knutst@gmail.com> 写道:
>On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
>> Hi,Knut,
>> I have translated DHIS2 to chinese. glad to contribute.
>
>Great. The best way for us to incorporate the translations is if you
>can go to the root of your DHIS2 source code and run the following
>statement from the command line:
>
> bzr dif > ch.patch
>
>Please just email me the resulting file (called ch.patch).
>
>Thanks a lot,
>Knut
I translated dis2 on everyday almost after I've pulled the trunk
how about the question?
···
At 2012-09-25 01:37:15,"Jason Pickering" <jason.p.pickering@gmail.com> wrote:
Hi Easy,
First, WOW. Amazing you have translated just about everything.
I merged your files with trunk and will commit them now . There have
been a number of changes to the translations since the last time you
updated the strings, but they will be available soon in trunk so you
can work off of the latest version.
Best regards,
Jason
On Mon, Sep 24, 2012 at 7:23 PM, Knut Staring <knutst@gmail.com> wrote:
Sorry, spelling mistake. It should be like this:
bzr diff > ch.patch
Please try again.
Thanks, Knut
Sent from my mobile
On Sep 25, 2012 12:04 AM, "easy" <lin_xd@126.com> wrote:
Hi,
the bzr dif get nothing, I copy out the files to a zip file.
I also another question: how to get the aggregated data at any time?
not just last year,last month, I want get the year 2011,2009, or 201101.
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
在 2012-09-24 17:29:08,"Knut Staring" <knutst@gmail.com> 写道:
>On Mon, Sep 24, 2012 at 5:26 AM, easy <lin_xd@126.com> wrote:
>> Hi,Knut,
>> I have translated DHIS2 to chinese. glad to contribute.
>
>Great. The best way for us to incorporate the translations is if you
>can go to the root of your DHIS2 source code and run the following
>statement from the command line:
>
> bzr dif > ch.patch
>
>Please just email me the resulting file (called ch.patch).
>
>Thanks a lot,
>Knut