Exporting All BOM Data

Note: The SQL Explorer feature is not included with all Cofactr plans. Please contact success@cofactr.com to discuss upgrades to a plan that includes SQL Explorer if you do not already have access.

SELECT
  bom_line.id,
  bom.name AS bom_name,
  bom.version AS bom_version,
  bom.part_number AS bom_number,
  bom_line.line_number,
  bom_line.dnp,
  bom_line.quantity,
  bom_line.reference_designators,
  STRING_AGG(part.mfg, ', ' ORDER BY part.mfg) AS mfg,
  STRING_AGG(part.mpn, ', ' ORDER BY part.mpn) AS mpn,
  STRING_AGG(part.custom_id, ', ' ORDER BY part.custom_id) AS custom_id
FROM bom_line
LEFT JOIN bom ON bom_line.bom_id = bom.id
LEFT JOIN alt_part_bom_line_join ON alt_part_bom_line_join.bom_line_id = bom_line.id
LEFT JOIN part ON alt_part_bom_line_join.part_id = part.id
GROUP BY
  bom_line.id,
  bom_line.line_number,
  bom_line.dnp,
  bom_line.quantity,
  bom_line.reference_designators,
  bom.name,
  bom.version,
  bom.part_number