Is there some way to filter datavalue by more than one organization group ?

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

莫愁前路无知己,天下谁人不识君。

You can do it easily by

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?
--
此致

easy

莫愁前路无知己,天下谁人不识君。

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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

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

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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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
(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.

http://dhis2.org/doc/snapshot/en/user/html/ch23s16.html

Regards,
Jason

···

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

(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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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.

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.

dhis-web.zip (135 KB)

···


此致

林晓东

莫愁前路无知己,天下谁人不识君。


在 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

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

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

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help