Search component

Keyi Zhang

• April 10, 2019 17:50

 

My purpose is searching component on database which display all related components. For instance, if I search 3 pole, 240 VAC, C-CURVE circuit breaker, it will show all 3 pole, 240 VAC, C_CURVE circuit breakers on searching.

I select three Class, Component name, description on Component Search Configuration of Zuken Components SQL. I create database as shown below.

   

Is anyone knowing how to set database?

Was this Helpful?

0

• 

  Paul Guillaume

  • April 11, 2019 07:01

  From your description it is not clear how you set up the database.

  The Search configuration does not reflect the tree structure of the view of the database.

  What I think is that in your database, "Kateeva-Circuit Breaker" is the Class. "240 VAC, 40A, D-CURVE" is the Description and "0201-00613-00" is the Component name. Did you create a sub-class attribute for the number of poles (the "3 POLE")? If yes, you could add an new sub-class attribute where you define the voltage and another one where you define the curve. And then adapt the tree structure by adding these attributes.

   

  Was this Helpful?

  0

Please sign in to leave a comment.