Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Raju Thangellamudi (LifelongLearner)
Frontier Communications

Frontier Communications
US
LifelongLearner Member since 2017 2 posts
Frontier Communications
Posted: Jan 24, 2019
Last activity: Jan 29, 2019
Posted: 24 Jan 2019 23:23 EST
Last activity: 29 Jan 2019 3:30 EST
Closed

How to delete Pega Knowledge article(s) from DB directly ?

I am trying to delete an article from KM Database directly by created or updated operator id. Is there any list of tables I should delete from ? I found few tables that has record for this article but, if there is attachment or image , or media file , etc.. how can I delete the article and all related content of the article ?

If someone can share SQL queries on how to accomplish this task is greatly appreciated .

To see attachments, please log in.
Pega Knowledge

Posted: 6 years ago
Posted: 29 Jan 2019 1:06 EST
Sawant Tandle (tands)
PEGA
Senior Manager, Customer Service Desktop & Self-Service
Pegasystems Inc.
IN

we do not recommend hard deleting the data from db as it might cause  issues with new data. However if you still insist on deleting, please delete the instances related to pega knowledge from the below classes 

https://community.pega.com/knowledgebase/articles/pega-knowledge-application-rap-classes-and-instances

let us know if you face any issues.

 

Regards

Sawant

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice