DataSets with Combination of categories different to default, and Agg. queries

Hi guys,

We have the dataset “External Consultations” with the “Services” combination of categories assigned (Services can be: Nutrition, Surgery, …). So the field attributeoptioncomboid in the datavalue table is going to be different to the ‘default’ id.

This dataset is going to be fed by a Single Event Without Registration Program using Aggregation Queries… so, the question is: Is possible to select (express) the attributeoptioncombo in one aggregation query? I didn’t find anything in the documentation. Or are all values going to be stored with the default attributeoption?

Thanks much

Regards

Jose

Hi Jose,

per now aggregation queries do not support data set categories / attribute option combo, so that will become a problem. Sorry. We intend to phase out aggregation queries (replace with program indicators) so I don’t think we will implement support for this.

regards,

Lars

···

On Wed, Nov 18, 2015 at 9:11 AM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi guys,

We have the dataset “External Consultations” with the “Services” combination of categories assigned (Services can be: Nutrition, Surgery, …). So the field attributeoptioncomboid in the datavalue table is going to be different to the ‘default’ id.

This dataset is going to be fed by a Single Event Without Registration Program using Aggregation Queries… so, the question is: Is possible to select (express) the attributeoptioncombo in one aggregation query? I didn’t find anything in the documentation. Or are all values going to be stored with the default attributeoption?

Thanks much

Regards

Jose


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Lars, thanks for your quick answer! Yes, I completely understand (I was expecting that answer :slight_smile: ). Thanks

···

On Wed, Nov 18, 2015 at 9:20 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Jose,

per now aggregation queries do not support data set categories / attribute option combo, so that will become a problem. Sorry. We intend to phase out aggregation queries (replace with program indicators) so I don’t think we will implement support for this.

regards,

Lars

On Wed, Nov 18, 2015 at 9:11 AM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi guys,

We have the dataset “External Consultations” with the “Services” combination of categories assigned (Services can be: Nutrition, Surgery, …). So the field attributeoptioncomboid in the datavalue table is going to be different to the ‘default’ id.

This dataset is going to be fed by a Single Event Without Registration Program using Aggregation Queries… so, the question is: Is possible to select (express) the attributeoptioncombo in one aggregation query? I didn’t find anything in the documentation. Or are all values going to be stored with the default attributeoption?

Thanks much

Regards

Jose


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org