Hi community,
can anybody give me a foolproof instruction how i can exclude manufacturer parts from BOM in SW electrical 2D?
I know it is possible with the SQL-tool but i´m not familiar with SQL-programming.
Beside that, i cant´t understand why such an expensive ECAD does not have those fundamental Features integrated...
I draw schematics of control cabinets - for that i want just the parts of the cabinet in my BOM, not things like field devices. I also do not need every cable duct and DIN Rail in my BOM.
Would be great if anybody can help me. Thanks alot in advance!
Hello Andreas,
We agreed that not having a readily available filter in the user interface was not useful. In SW Electrical 2016, we introduced this filter on the report management dialog.
You can accomplish this task in SW Electrical 2014 by editing the SQL query in the user interface. Specifically, find the WHERE statement and add
AND bom_manufacturer != ]]Leroy Somer[[
Anything you place between the ]] [[ will be filtered within. You can verify the filter is working by pressing the Test button after editing the query. In the image below, I have done this after activating the expert mode and pressing the Edit button to edit the SQL query.