SOLIDWORKS Enterprise PDM SQL Lists

SOLIDWORKS Enterprise PDM contains list functionality where you can build lists of metadata to be reused on files in your PDM.  Many times this is an on going list that grows over time.  The list is displayed back to the user in the order that it was entered by the admin.  What if you could make it so the list was returned in alphabetic order regardless of how it was entered by the administrator!

You need to simply create two lists in EPDM.  One that is specified as data type of “Text”.  This list is where you define the raw data that goes into your list.  You will need another list of data type of “From SQL Database”.  This is the list you will reference on your data card.  The SQL query that is used in this list is the following:

Select CardListValues.Value From CardLists, CardListValues

Where CardLists.Name =’Name of your list here’

And Cardlists.Id = CardListValues.CardListId

Order by CardListValues.Value

In the admin tool it looks like this:

List1

Your master list (This list does not get referenced on your data card)

List2

This is your SQL list (This list gets directly referenced on your data cards.)

Just like that you no longer have to maintain the ordering of your list!

Symmetry Solutions
Symmetry Solutions, Inc. is your official SOLIDWORKS 3D CAD software and training provider for the Upper Midwest. We serve Minnesota, Wisconsin, North Dakota and South Dakota with premier SOLIDWORKS training, support and implementation services for the complete suite of SOLIDWORKS 3D design solutions. For more information on SOLIDWORKS, visit: www.symsolutions.com - Learn more about SOLIDWORKS Training or SOLIDWORKS Online Training - Learn more about SOLIDWORKS Solutions: 3D CAD, Simulation & Design Validation, Technical Communications, Product Data Management, Electrical Design, Quality Control, Education Edition, Free SOLIDWORKS Tools, 3DExperience
Symmetry Solutions
Symmetry Solutions
Symmetry Solutions

Latest posts by Symmetry Solutions (see all)