You are currently reviewing an older revision of this page.
Devices and/or part numbers are appearing on reports but I can find no evidence of them in the project. There are no symbols placed for these devices, but they are affecting the quantity on the bill of materials.
The Remove Unplaced Devices button was added to the BOM Explorer tab of Project Manager in SELECTseries 7 (08.11.12.xx). It removes devices that have no associated symbols placed in the project. These devices may have been added using BOM Explorer, imported into the project, existed as symbols that have since been deleted from the page, or left behind by some other workflow.
Select the BOM Explorer tab of Project Manager. Tabs are along the bottom of Project Manager.
The Remove Unplaced Devices button is near the top of the BOM Tree pane.
Devices in the project that have no symbols inserted should appear with their device tags in a darker/bold color. Right-click such device tags and select Remove.
Use this method at your own risk. This process performs the same operations as the Remove Unplaced Devices button, so when available, use Remove Unplaced Devices. If this button is not present on BOM Explorer, consider upgrading to the latest version.
-- Clear Unused Partnumber
DELETE FROM partnumber WHERE part_number not in(SELECT partnumber FROM device_partnumber WHERE project_id=9999 or project_id=-9999) AND project_id=9999;
-- Clear Unused Device
DELETE FROM Device_PartNumber WHERE project_id=9999 AND device_id is null;
DELETE FROM Device WHERE project_id=9999 AND (type<>N'DEVICE' OR type is null) AND id NOT IN (SELECT DISTINCT device_id FROM symbol WHERE project_id=9999 AND device_id is not null UNION SELECT device_id FROM Spare WHERE project_id=9999);
DELETE FROM ParentDevice WHERE project_id=9999 AND (id not in (SELECT DISTINCT parent_device_id FROM device WHERE project_id=9999 UNION SELECT DISTINCT parentdevice_id FROM parentdeviceattribute WHERE project_id=9999));