Update FAQ Item from external script

[fRd]

Hi,

I'm trying to update FAQ items with up to date information from an external script.

I update the faq_item table in the OTRS database and change the required f_field columns with the HTML code.
When I go see the faq entry in the web view, the old entry is still present. After clicking edit in the web view, and clicking save the old entry is present again in the faq_item table. Even the changed time is the old changed time from a web change and not taking the entry from the database.

Then I found the tables faq_log and faq_history which keep track of changes of the faq entries:
faq_log
id;item_id;interface;ip;user_agent;created
3520;906;"internal";"172.16.10.122";"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:48.0) Gecko/20100101 Firefox/48.0";"2016-09-01 14:15:07"

faq_history
id;name;item_id;created;created_by;changed;changed_by
1290;"Updated";906;"2016-09-01 14:20:45";17;"2016-09-01 14:20:45";17

Updating these tables with correct information doesn't help either.

So, there must be somewhere a caching of this data, but I cannot find it.
(tested this also with another browser and pc, so no client-side cache is causing this)

Does anyone have an idea how to get this done? Or where the cached data is stored to overwrite that?
(If I find more information myself, I'll update this topic also)

Thanks!
Greets,

fRd

[reneeb]

Do not change data in the database directly. Please use the Modules (e.g. Kernel/System/FAQ.pm) as those modules delete caches when items are updated...

[fRd]

Thanks for the information!
I'll investigate this.

Can I create new FAQ Items also through this module?

Grts,
fRd

[reneeb]

Yes, there is a FAQAdd method: https://github.com/OTRS/FAQ/blob/master ... AQ.pm#L487

[fRd]

Thanks for the info!
One last question about this: Is it possible to use the Webservices to create and update faq items?

KR,
fRd