BTW, I still do not understand how to set an individual item (data) as invalid.
On 8/19/10, Yasir Mughal <[email protected]> wrote: > Thanks for the hint, as some of the records has been entered by > mistake and there is no point in keeping those in DB. > > > > On 8/19/10, Bryan Baldwin <[email protected]> wrote: >> On 08/19/2010 06:40 PM, Yasir Mughal wrote: >>> The invalid option is for the metadata, I am looking for delete >>> option for the actual data. For example I was adding information for >>> computers, and out of 8 entries, one is incorrect and I want to delete >>> that. >> >> I don't see why you can't simply make corrections to the data as it >> stands. You don't really have to remove the database rows, but you >> probably can. This is not recommended to do so if your config items have >> been in use and linked in tickets etc etc. Even so, there are six tables >> that may contain data about the config item you wish to remove. >> >> mysql> show tables like "%config%"; >> +---------------------------+ >> | Tables_in_otrs (%config%) | >> +---------------------------+ >> | configitem | >> | configitem_counter | >> | configitem_definition | >> | configitem_history | >> | configitem_history_type | >> | configitem_version | >> +---------------------------+ >> 6 rows in set (0.00 sec) >> >> Deleting the main row in configitem should be enough, although this may >> leave some dangling bits in the other five tables. As such, its >> recommended to edit the item or simply set it to "invalid". >> >> Cheers! >> >> Bryan >> --------------------------------------------------------------------- >> OTRS mailing list: itsm - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/itsm >> To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm >> > --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
