Find discussion status in database

[deadbird]

Hi.
I'm using EA to generate documents containing all the discussions of a project. To do so, I'm using an SQL model search that retrieves t_objects that have a t_document with t_document.ElementType = 'Post'. So far, so good.

But right now, I'd like to generate this document excluding discussions with status "Closed". I searched deeply in the database and found nothing about this status. t_document, for instance, has no column named "status" or so.

Can someone help?

Thanks a lot

[qwerty]

Well, I almost never used that feature (except for some tests many years ago). I did not manage to create a discussion entry due some Sparxian logic my brain is lacking. If you can give me the steps to create a closed discussion I'll have a look.

q.

[deadbird]

Hi qwerty, thanks a lot for your helping hand ^^

To create a discussion:
- select any object in Object Browser, for example an Actor (packages can't have Discussions...)
- open discussions Window: Ribbon, "Start" tab, "Windows" button (on the left), "Discussions"
- double-click on "Create new discussion" and input some text.
- right-click on the text to change discussion status (Open, Awaiting review, Closed). These are the statuses I'm searching for in the database.

[deadbird]

Phew...just found how to...grab tightly your socks before they get knocked off...

EA stores the status in t_document.style, in XML.

If the discussion is closed, it appends "\n\t<STATUS>RS_CLSD</STATUS>".
If it's awaiting review, it's "\n\t<STATUS>RS_PEND</STATUS>".

I couldn't see it because tuples in pgAdmin are displayed in a single line. Thus everything after the "\n\t" wasn't visible...

I really wish I had a deep talk with Sparx's database "engineer"...

[qwerty]

Happily seeing you solved your issue while I was having a cup of coffee :-)

q.

[deadbird]

To see what's next -> http://www.sparxsystems.com/forums/smf/index.php/topic,38804.0.html