Does anyone know what this table is for please ?
Is it still used
Thanks
Pierre
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