cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Most commonly used components/documents

Highlighted
Aquamarine

Most commonly used components/documents

This is a follow up to my previous email. I modified the previous query
to report on most commonly linked documents to BOMs



SELECT DOCUMENT, COUNT(*)

FROM

(SELECT DISTINCT M1.WTDOCUMENTNUMBER DOCUMENT, M2.WTPARTNUMBER ASM

FROM WTDOCUMENTMASTER M1, WTDOCUMENT D1, WTPARTMASTER M2,
WTPARTDESCRIBELINK, WTPART

WHERE

D1.IDA2A2 = WTPARTDESCRIBELINK.IDA3B5 AND

D1.IDA3MASTERREFERENCE = M1.IDA2A2 AND

WTPART.IDA3MASTERREFERENCE = M2.IDA2A2 AND

WTPART.IDA2A2 = WTPARTDESCRIBELINK.IDA3A5 AND

WTPART.IDA3VIEW = 1447) MYTABLE

GROUP BY DOCUMENT

HAVING COUNT(*) >5

ORDER BY COUNT(*) DESC



Same rules as below with optional stuff.


Announcements