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.hispviet...@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? > > On Tue, May 12, 2015 at 10:02 PM, Lars Helge Ă˜verland <larshe...@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 >> >> On Mon, May 11, 2015 at 3:04 PM, Pierre Dane <pie...@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 >>> >>> >> >> _______________________________________________ >> 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 >> >> > > _______________________________________________ > 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.hedb...@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