Sparx Systems Forum

Discussion => General Board => Topic started by: monicashishodia on June 14, 2017, 04:18:38 pm

Title: In which table sparx stores content from Discussion (version 13)
Post by: monicashishodia on June 14, 2017, 04:18:38 pm
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
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: monicashishodia on June 14, 2017, 04:45:55 pm
I have found one table t_files. Is there any other table?
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: Uffe on June 14, 2017, 07:12:16 pm
Hi Monica,

t_issues and t_xrefsystem might be worth a look.

/Uffe
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: monicashishodia on June 14, 2017, 07:23:42 pm
Thanks Ufffe.
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: deadbird on October 19, 2017, 10:47:50 pm
Discussions are stored in t_document where t_document.ElementType = 'Post'
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: KrugerPe on November 30, 2017, 07:29:29 pm
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?
Title: Re: In which table sparx stores content from Discussion (version 13)
Post by: Geert Bellekens on November 30, 2017, 08:19:09 pm
The elementID contains the GUID of the discussed element.

Geert