Exclude element type from ModelView List

[skiwi]

I have just started using ModelView lists on a diagram.


I have the default query with two attributes removed, and would like to exclude Note elements from the list

Code: [Select]

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name
FROM t_object INNER JOIN (t_diagram INNER JOIN t_diagramobjects ON t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID)
ON t_object.Object_ID = t_diagramobjects.Object_ID
WHERE t_diagram.ea_guid='{61343AF8-BEDE-4782-B0A9-72E8F32131BE}' ORDER by t_object.Name

tia


Simon


http://www.sparxsystems.com/enterprise_architect_user_guide/11/reporting/define_a_model_view_chart.html
http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/navigate_search_and_trace/reportview.html
http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/navigate_search_and_trace/diagram_list.html

[Eve]

Add the following to your condition:

and Object_Type not in ('Note')

I've used "not in" under the assumption that you'll want to remove other types eventually. Otherwise it would be Object_Type <> 'Note'