Hi
Quick question: I have just added two CATEGORY OPTIONS to an instance - but in which table in the database are those options stored?
Regards
Calle
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
dataelementcategoryoption
–
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg calle.hedberg@gmail.com wrote:
Hi
Quick question: I have just added two CATEGORY OPTIONS to an instance - but in which table in the database are those options stored?
Regards
Calle
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Morten
Thanks for prompt reply, I had actually looked at the properties for that and all other tables with category/options in the name (in pgadmin), but it was showing with only 1 records. Had to actually open the table to see the options, so I guess postgresql don’t automatically update it’s meta-data tables with accurate record counts. Lesson learnt…
Regards
Calle
On 13 February 2018 at 11:40, Morten Olav Hansen morten@dhis2.org wrote:
dataelementcategoryoption
–
–
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg calle.hedberg@gmail.com wrote:
Hi
Quick question: I have just added two CATEGORY OPTIONS to an instance - but in which table in the database are those options stored?
Regards
Calle
Calle Hedberg
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Sure Calle, I guess postgres must defend itself from the likes of us 
On 13 February 2018 at 09:48, Calle Hedberg <calle.hedberg@gmail.com> wrote:
Morten
Thanks for prompt reply, I had actually looked at the properties for that
and all other tables with category/options in the name (in pgadmin), but it
was showing with only 1 records. Had to actually open the table to see the
options, so I guess postgresql don't automatically update it's meta-data
tables with accurate record counts. Lesson learnt...Regards
CalleOn 13 February 2018 at 11:40, Morten Olav Hansen <morten@dhis2.org> wrote:
dataelementcategoryoption
--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.orgOn Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg <calle.hedberg@gmail.com> >> wrote:
Hi
Quick question: I have just added two CATEGORY OPTIONS to an instance -
but in which table in the database are those options stored?Regards
Calle*******************************************
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
*******************************************
_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help--
*******************************************
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
*******************************************
_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help