Where is user data stored for a forum stored?

[chetanvajre2014]

We've a situation where we had a focum posted to produciton by accident and we deleted the forum, but the user responses are still showing up if we queyr the "activites"> SO i went to the user profile and deleted the content from hi profile. I also used replicate delete to delete from publish. So asicaly under that user we do not have any UGC.

On dispatcher, it's still showing up? DOes dispatcher cache even forum data? if so where should I be looking at to delete the user response?

Thanks

[dwalling]

The dispatcher should not be configured to cache ugc in AEM 5.6.1 and earlier because there isn't a suitable invalidation mechanism available out of the box. Check your dispatcher configuration to be sure that it is not caching /content/usergenerated. You can also invoke the url against a publish node directly (not through dispatcher) to see if the content has been deleted. 

Don

[Runal_Trivedi]

Just to rule out the case of caching you can put some query parameter to your page URL and see the behavior, if you still see the UGC content, if it is still coming up then it means it is still in AEM.

[shekhardhiman]

HI there,

Thanks for reaching out to Adobe Community.

As per my knowledge, the data is stored in the JCR nodes. Please follow the below article to see if it helps:

http://helpx.adobe.com/experience-manager/using/programmatically-accessing-cq-content-using.html

Thanks!

[dwalling · Accepted solution]

Shekhar_Dhiman wrote...

As per my knowledge, the data is stored in the JCR nodes. Please follow the below article to see if it helps:

http://helpx.adobe.com/experience-manager/using/programmatically-accessing-cq-content-using.html

In AEM 6.0 and later it is not recommended to use JCR APIs to access UGC. This is because UGC can be configured to be stored in cloud storage or in a local mongo database. Instead, the SCF APIs should be used to access UGC. http://docs.adobe.com/docs/en/aem/6-0/develop/social-communities/scf.html