Part Type Queries

Part Type Queries offers database library users another option for organizing Parts displayed in Altium's Components Panel.

In the Parts Access Backend Database

Queries can be added, for example . . .

Select Create > Query Design

Build the Query

Or you can create Queries from the SQL View

Select Home > SQL View > Enter a SQL statement.

SELECT Parts.Part_Type, Parts.*

FROM Parts

WHERE (((Parts.Part_Type)="Resistor"));

Close and Save the Query as Resistors

Another SQL statement example for Capacitors

SELECT Parts.Part_Type, Parts.*

FROM Parts

WHERE (((Parts.Part_Type)="Capacitor"));

Another SQL statement example for Inductors

SELECT Parts.Part_Type, Parts.*

FROM Parts

WHERE (((Parts.Part_Type)="Inductor"));

Open and edit the Altium DBLib after the queries have been created in the database.

Select the new tables (actually queries)

And set the Single key lookup =  ID field

That's it !