About association between reporttable and reporttable_categoryoptioncombos

Hi folks,

I’m using Vietnamese database and I tried to delete CategoryCombo and got an exception related to the association between reporttable and reporttable_categoryoptioncombos tables.

However, it seems reporttable_categoryoptioncombos table is not used anymore. If so, we should add some code to delete it. Can anybody confirm this?

Btw, when we modify the database structure, please add the queries to do that change to TableCreator or TableAlteror (org.hisp.dhis.startup on dhis-server-core) to fix the current database before system starts up.

Best regards,
Quang

It is in use… Please don’t delete :slight_smile:

Lars

···

On Wed, May 26, 2010 at 12:12 PM, Quang Nguyen quangnguyen111@gmail.com wrote:

Hi folks,

I’m using Vietnamese database and I tried to delete CategoryCombo and got an exception related to the association between reporttable and reporttable_categoryoptioncombos tables.

However, it seems reporttable_categoryoptioncombos table is not used anymore. If so, we should add some code to delete it. Can anybody confirm this?

Btw, when we modify the database structure, please add the queries to do that change to TableCreator or TableAlteror (org.hisp.dhis.startup on dhis-server-core) to fix the current database before system starts up.

Best regards,
Quang


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

Hi Lars,

It is in use… Please don’t delete :slight_smile:

Could you please tell me what is it used for?

I see in ReportTable has one-many association to DataElementCategoryCombo.

And “reporttable” table has a field named “categorycomboid” for this relationship.
Even I didn’t find the mapping stuff for reporttable_categoryoptioncombos table.
This is the reason of my thought it is not in use.

Quang

···

2010/5/26 Lars Helge Øverland larshelge@gmail.com

Lars

On Wed, May 26, 2010 at 12:12 PM, Quang Nguyen quangnguyen111@gmail.com wrote:

Hi folks,

I’m using Vietnamese database and I tried to delete CategoryCombo and got an exception related to the association between reporttable and reporttable_categoryoptioncombos tables.

However, it seems reporttable_categoryoptioncombos table is not used anymore. If so, we should add some code to delete it. Can anybody confirm this?

Btw, when we modify the database structure, please add the queries to do that change to TableCreator or TableAlteror (org.hisp.dhis.startup on dhis-server-core) to fix the current database before system starts up.

Best regards,
Quang


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

Sorry Quang, you are right, you can remove it…

···

2010/5/26 Quang Nguyen quangnguyen111@gmail.com

Hi Lars,

2010/5/26 Lars Helge Øverland larshelge@gmail.com

It is in use… Please don’t delete :slight_smile:

Could you please tell me what is it used for?

I see in ReportTable has one-many association to DataElementCategoryCombo.

And “reporttable” table has a field named “categorycomboid” for this relationship.
Even I didn’t find the mapping stuff for reporttable_categoryoptioncombos table.
This is the reason of my thought it is not in use.

Quang

Lars

On Wed, May 26, 2010 at 12:12 PM, Quang Nguyen quangnguyen111@gmail.com wrote:

Hi folks,

I’m using Vietnamese database and I tried to delete CategoryCombo and got an exception related to the association between reporttable and reporttable_categoryoptioncombos tables.

However, it seems reporttable_categoryoptioncombos table is not used anymore. If so, we should add some code to delete it. Can anybody confirm this?

Btw, when we modify the database structure, please add the queries to do that change to TableCreator or TableAlteror (org.hisp.dhis.startup on dhis-server-core) to fix the current database before system starts up.

Best regards,
Quang


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

Sorry Quang, you are right, you can remove it…

Okay. Thanks Lars.

Quang

···

2010/5/26 Lars Helge Øverland larshelge@gmail.com

2010/5/26 Quang Nguyen quangnguyen111@gmail.com

Hi Lars,

2010/5/26 Lars Helge Øverland larshelge@gmail.com

It is in use… Please don’t delete :slight_smile:

Could you please tell me what is it used for?

I see in ReportTable has one-many association to DataElementCategoryCombo.

And “reporttable” table has a field named “categorycomboid” for this relationship.
Even I didn’t find the mapping stuff for reporttable_categoryoptioncombos table.
This is the reason of my thought it is not in use.

Quang

Lars

On Wed, May 26, 2010 at 12:12 PM, Quang Nguyen quangnguyen111@gmail.com wrote:

Hi folks,

I’m using Vietnamese database and I tried to delete CategoryCombo and got an exception related to the association between reporttable and reporttable_categoryoptioncombos tables.

However, it seems reporttable_categoryoptioncombos table is not used anymore. If so, we should add some code to delete it. Can anybody confirm this?

Btw, when we modify the database structure, please add the queries to do that change to TableCreator or TableAlteror (org.hisp.dhis.startup on dhis-server-core) to fix the current database before system starts up.

Best regards,
Quang


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