Do I need custom SQL queries just to select interfaces in report?

[mse]

I need to get information on provided and required interfaces in the currently selected package. with the new report template, I can go through elements. However, I want to create a section where I list provided interfaces and another where I list required interfaces.

Do I have to go with a custom SQL query here?

[Geert Bellekens]

I think they might show up in the embedded elements section, but it might be hard to make different sections for required and provided.

Geert

[mse]

I got a SQL query working, however, the type output is not performing the way I expected. I have successfully return the correct list of results, namely all ports in a class that start with 'P_'. However, I want the type of those ports (I typed them with an interface in the model). I thought t_object.Classifier would do the trick, but Classifier only outputs 0s. How can I output the interface name as the type of the port? Here is my query:

Code: [Select]

select * FROM t_object o WHERE (o.Object_Type='Port' AND o.Package_ID = #Package# AND (o.Name LIKE 'P_%'))