Locating linked documents

[skiwi]

A significant issue exists when trying to update the normal.rtf styles to our corporate standard.
Its not enough to simply update all the user templates.
Every linked document requires its styles to be updated as well, otherwise the results are undefined (Word does not handle well multiple redefinitions of a style when it comes to numbering schemes (multi-level lists).


My question is:
Can I use "Find in Project" (<ctrl>-f) to locate all linked documents?

[Geert Bellekens]

Not sure if you can with the standard search builder, but you definitely can with an SQL Search.
IIRC linked documents are stored in t_document. So you would have to join t_object with t_document to get the relevant results.

Geert

[Uffe]

Here's a snippet you can paste into a SQL search definition.

Code: (SQL) [Select]

select t_object.ea_guid as CLASSGUID, t_object.Object_Type as CLASSTYPE,
t_object.Name, t_document.DocID, t_document.DocDate
from t_document
left join t_object on t_document.ElementID = t_object.ea_guid
where t_document.DocType = 'ModelDocument'
You need to check the document type because baselines are also stored as documents (of type 'Baseline'), and in there may be some other stuff there as well.

A document has a name, but that isn't meaningful because it's not shown anywhere in the GUI (to my knowledge). It's simply the name of the element at the time the document was created (and it's not updated when the element's name changes).

Adding a search term is left as an exercise for the reader.

/Uffe

[skiwi]

Code: (SQL) [Select]

select t_object.ea_guid as CLASSGUID, t_object.Object_Type as CLASSTYPE,
t_object.Name, t_document.DocID, t_document.DocDate
from t_document
left join t_object on t_document.ElementID = t_object.ea_guid
where t_document.DocType = 'ModelDocument'

Most helpful thankyou.
And it brings to mind the suggestions to

• Linked Document Identification in Project
• Is there, is is there not, a linked document
• Special icons for elements with linked documents
• Linked Documents in Project Browser
• Linked document indicator