Smarter EPDM Drop Lists Using SQL

May 7th, 2013 by

Out of the box SolidWorks Enterprise PDM gives you the ability to populate your drop lists based on SQL query results. I use this functionality all the time to give my users a list of qualified suppliers from a purchasing database, lists of users in a specified group, choices of product type, etc.

The limitation is that these queries are all based off of constant values. These queries are run by the EPDM server on a predefined interval, and the results are stored in the EPDM database. This method is fast, but it eliminates the ability to populate the lists based on properties of the file itself.

Granted with EPDM’s “Controlled by variable” option,

ControlVariable

you can change the query based on one other variable, but if you want to use more than one variable or the file’s physical properties, PigeonHole makes the process very easy.

This video gives a quick demonstration showing how.

YouTube Preview Image

Jeff Sweeney

CSWE Engineering Data Specialist 3DVision Technologies

Tags: , , ,

Leave a Reply


nine × eight =

Follow
Get every new post delivered to your inbox
Join other followers
Powered By WPFruits.com
Bear