DataElementOperand

Does anyone know what this table is for please ?
Is it still used

Thanks

Pierre

Hi Pierre,

yes it is used. It stores combinations of data elements + category option combos, and is used e.g. in data set “disabled fields” and report table favorites.

Lars

···

On Mon, May 11, 2015 at 3:04 PM, Pierre Dane pierre@jembi.org wrote:

Does anyone know what this table is for please ?
Is it still used

Thanks

Pierre


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,

I have problem related to this Dataelementoperand table.

I tried to delete a data element. After remove it from all the report table, chart and this data element has no data value. But it didn’t allow me to delete. I check in the log file, it said that cannot delete because has foreign key with data element operand table.

What should I do to delete this data element in interface without do from database?

···

On Tue, May 12, 2015 at 10:02 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Pierre,

yes it is used. It stores combinations of data elements + category option combos, and is used e.g. in data set “disabled fields” and report table favorites.

Lars


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

On Mon, May 11, 2015 at 3:04 PM, Pierre Dane pierre@jembi.org wrote:

Does anyone know what this table is for please ?
Is it still used

Thanks

Pierre


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

Lars,

Strictly speaking, the DataElementOperand table is a “derived” meta-data table. If, as in Thuy’s case, there are no actual data values linked to a data element, and no reports or charts etc is using it - then “derived” (support) table records should be automatically deleted as part of the DataElement DELETE operation.

Regards

calle

···

On 14 May 2015 at 09:19, Thuy Nguyen thuy.hispvietnam@gmail.com wrote:

Hi,

I have problem related to this Dataelementoperand table.

I tried to delete a data element. After remove it from all the report table, chart and this data element has no data value. But it didn’t allow me to delete. I check in the log file, it said that cannot delete because has foreign key with data element operand table.

What should I do to delete this data element in interface without do from database?


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

On Tue, May 12, 2015 at 10:02 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Pierre,

yes it is used. It stores combinations of data elements + category option combos, and is used e.g. in data set “disabled fields” and report table favorites.

Lars


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

On Mon, May 11, 2015 at 3:04 PM, Pierre Dane pierre@jembi.org wrote:

Does anyone know what this table is for please ?
Is it still used

Thanks

Pierre


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-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg