table for Category Options

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

http://www.dhis2.org

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

http://www.dhis2.org

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


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 :slight_smile:

···

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
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
http://www.dhis2.org

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

--

*******************************************

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