Full list of Revisions without Attachments

Is there a way for me to gather a list of Revisions that DO NOT have an attachment? I’ve looked for the BAQ Table fields and have been unsuccessful. Thanks

Attachments are stored in ice.XFileAttch. The field “RelatedToFile” is basically the table the attachment is a child of. E.g. “PartMtl” ties to erp.PartMtl. PartRev is PartRev, etc. Depending on whether or not you’re linked to the Rev master, the ops, or the mtl, you may need multiple joins.

Either way, you have to join via the “key#” fields. XFileAttch.Key1 is the PartNum, Key2 is the Rev, Key3 is AltMethod. Do a Select * or BAQ on XFileAttch by itself and it should become obvious what I’m talking about.

If you want to see what the actual attachment is, you have to join ice.XFileRef as well.

1 Like

Thank you! That’s exactly what I needed.