Useful commands

Things worth running that people don't think to ask for.

A starting set. Adapt the filters to your own field names.

Finding gaps

• find part where lifecycle = 'released' and supplier.price is null
  Released parts nobody has priced — the usual reason a rolled cost looks wrong.
• find part where mass is null and category != 'virtual'
  Parts contributing nothing to weight rollups.
• find part where compliance.rohs is null
  The compliance survey gap list.
• find part where hsCode is null and lifecycle = 'released'
  Released parts with no tariff classification.

Housekeeping

• find part where category is null | set category = 'mechanical'
  Categorise the stragglers after an import.
• find revision where state = 'wip' and updated < '90 days ago'
  Working revisions nobody has touched in a quarter.

Getting data out

• export part where project = 'X' --template 'supplier-pack'
  The same export every time, without re-picking columns.
• download file where part.project = 'X' and file.type = 'pdf'
  Every drawing for a project, as one archive.
• backup tenant --scope all --destination 'our-storage'
  A full copy into storage you control. Worth scheduling.

Before a release

• compare bom <old> <new> --level all
  What actually changed, at every level.
• report traceability where assembly = 'X' --format pdf
  The evidence matrix a customer's quality department will ask for.