In which table sparx stores content from Discussion (version 13)

[monicashishodia]

HI All

I am trying to search for data which is getting stored as discussions, modal chat among users in a repository using 'Discussion' option from ribbon menu in version 13.
Can anybody please tell me in which table/tables its getting stored in database? I could not find it in one of the documents provided which was for older version.

I am using version 13.

Regards,
Monica

[monicashishodia]

I have found one table t_files. Is there any other table?

[Uffe]

Hi Monica,

t_issues and t_xrefsystem might be worth a look.

/Uffe

[monicashishodia]

Thanks Ufffe.

[deadbird]

Discussions are stored in t_document where t_document.ElementType = 'Post'

[KrugerPe]

Hi, I cannot figure out how to find the element that relates to the discussion post when querying the t_document table for 'post'.  Can any one help please?  What am I missing?

[Geert Bellekens]

The elementID contains the GUID of the discussed element.

Geert