Author Topic: In which table sparx stores content from Discussion (version 13)  (Read 468 times)

monicashishodia

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
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

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
Re: In which table sparx stores content from Discussion (version 13)
« Reply #1 on: June 14, 2017, 04:45:55 pm »
I have found one table t_files. Is there any other table?

Uffe

  • EA Practitioner
  • ***
  • Posts: 1066
  • Karma: +81/-5
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: In which table sparx stores content from Discussion (version 13)
« Reply #2 on: June 14, 2017, 07:12:16 pm »
Hi Monica,

t_issues and t_xrefsystem might be worth a look.

/Uffe
My theories are always correct, just apply them to the right reality.

monicashishodia

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
Re: In which table sparx stores content from Discussion (version 13)
« Reply #3 on: June 14, 2017, 07:23:42 pm »
Thanks Ufffe.

deadbird

  • EA Novice
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: In which table sparx stores content from Discussion (version 13)
« Reply #4 on: October 19, 2017, 10:47:50 pm »
Discussions are stored in t_document where t_document.ElementType = 'Post'

KrugerPe

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: In which table sparx stores content from Discussion (version 13)
« Reply #5 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?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 7727
  • Karma: +165/-21
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: In which table sparx stores content from Discussion (version 13)
« Reply #6 on: November 30, 2017, 08:19:09 pm »
The elementID contains the GUID of the discussed element.

Geert