View Name:bug_attch
View Number:369
Group:Full Text Search Indexing
Description:Joins attachment to its doc_path
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidbugobjidBug internal record number 
attchiddoc_instobjidDoc_inst internal record number 3 (UNIQUE)
titledoc_insttitleDocument title 
pathdoc_pathpathPath and file name of the attachment 

Joins:

Join FromJoin To
(doc_inst).attach_info2doc_path(doc_path).doc_locate2doc_inst
(doc_inst).doc_inst2bug(bug).bug_attach2doc_inst
My Recent Objects
bug_attch