Hello SOLIDWORKS Electrical Community,

I’m reaching out for assistance with an issue related to SQL queries for custom BOM (Bill of Materials) exports in SOLIDWORKS Electrical. After a recent update, my existing SQL query—previously used to extract data for custom components (e.g., electrical conduits)—no longer returns any data, despite executing without errors.

Context:

• We use custom SQL queries to export BOM data for specific components (e.g., electrical conduits) from the SOLIDWORKS Electrical database.
• The query involves joins between tables like tew_buildofmaterial, tew_userdata, tew_function, and tew_component.
• After the update, the query runs successfully but returns zero rows, suggesting a change in table relationships, column names, or data structure.

Problematic Joins:

The query includes the following joins, which seem to be the root cause:

LEFT JOIN tew_userdata ON (tew_buildofmaterial.bom_id = tew_userdata.use_objectid)
INNER JOIN tew_userdata AS fun1 ON (tew_function.fun_id = fun1.use_objectid)
INNER JOIN tew_userdata AS com ON (tew_component.com_id = com.use_objectid)

Request for Help:

1. Has anyone else experienced this issue after updating SOLIDWORKS Electrical? If so, how did you resolve it?
2. Could someone from Dassault Systèmes confirm if there were changes to the database schema (e.g., table/column renames) in the latest update?
3. Are there alternative tables or columns I should use for joining tew_userdata with tew_buildofmaterial, tew_function, or tew_component?

I’d greatly appreciate any insights or suggestions to restore functionality to our BOM export process. Thank you in advance for your help!