Hi! Had a nice weekend?
I'm stuck with this. I can't figure out what where the link between CONFIGURATION ITEMS is made on the database.
I have so many "articles" in to CI classes, and i wish to link them. It has to be done on the config item part directly on the DB because there are more than 5000 things to relate. I've been making tests linking CI's but the only thing i see is a change in configitem_history, wich add's a record matching the linked object configitem_id on the configitem_history table and a textstring.
Something like this: 4970%%ITSMConfigItem.
On the linked field it happens the same thing but with with the data related with the linked object. This part is obvious.
But if I change it in the DB it does nothing to the app. I supose this is not the data it's reading, but a historical change record. Can you help finding the correct table/field... whatever...
Any one can help?
Thanks!
Regards
Bruno
Linking Configuration items directly on the DB. [SOLVED]
Moderator: crythias
Linking Configuration items directly on the DB. [SOLVED]
Last edited by Amukinado on 22 Jun 2010, 17:00, edited 3 times in total.
OTRS V3.2.8 - ITSM 3.2.6 - Cent OS 5.9x64
Re: Linking Configuration items directly on the DB.
Solved! Don't rely only on documents like I was doing! Lesson learnd!
When i looked at the DB through the mysqclient there's a table called link_relation!
Regards
Bruno
When i looked at the DB through the mysqclient there's a table called link_relation!
Regards
Bruno
OTRS V3.2.8 - ITSM 3.2.6 - Cent OS 5.9x64