Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: adepreter on February 08, 2016, 07:39:30 pm

Title: Deleting all baselines from a repository in one go
Post by: adepreter on February 08, 2016, 07:39:30 pm

What is the most effective way to delete all baselines from the repository in one go.

Is all baseline information stored ONLY in the t_document table (where t_document.ElementID = t_package.ea_guid) ?

Thanks

Alain

Title: Re: Deleting all baselines from a repository in one go
Post by: Geert Bellekens on February 08, 2016, 08:02:10 pm

Alain,

I believe it is indeed only stored in the t_document, but it is not the only thing that is stored in that table.
So you'll have to make sure that your selection is precise enough to delete ONLY the baselines.

Geert

Title: Re: Deleting all baselines from a repository in one go
Post by: qwerty on February 08, 2016, 09:39:11 pm

Code: [Select]

DELETE FROM t_document WHERE ElementType="Baseline"should do. See p. 28 of my Inside book.

q.

Title: Re: Deleting all baselines from a repository in one go
Post by: adepreter on February 11, 2016, 02:24:55 am

Thank you very much! I guess you meant DocType and not ElementType.

DELETE FROM t_document WHERE DocType="Baseline"

Title: Re: Deleting all baselines from a repository in one go
Post by: qwerty on February 11, 2016, 02:44:51 am

Yes. It looks like I need to clarify the according paragraph in my book ;D

q.