Cancel
Showing results for 
Search instead for 
Did you mean: 

Sample Queries for Interrogating a Rules Database

Community Manager Community Manager
Community Manager

The attached PDF contains instructions and queries you may modify and use to interrogate a Rules database to answer the following questions:

  

  1. What application does this Part Family belong to?
  2. What application does this Part Family, or partial information of the Part Family, belong to?
  3. What Part Families contain a given property, property description, or property category?
  4. What Property Formulas contain this text?
  5. What Subpart Formulas contain this text?
  6. What Connection Formulas contain this text?
  7. What Connections use this Part Family?
  8. What Properties are outputting to this Components Database table?
  9. What Database Specs refers to this Components Database table?
  10. What Part Families contain these subparts, descriptions, etc.?
  11. What Part Families contain these Connections?
  12. What Part Families contain these specifications?

 

SQL Server.png