Sparx Systems Forum

Enterprise Architect => 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