View Query Builder query as SQL

[skiwi]

Is it possible view a query builder query as SQL?


I'm trying to develop a query for a document along the lines of


Keywords IS NULL OR Keywords LIKE "<value> OR Keywords LIKE "<anothervalue>"


thanks


Simon

[skiwi]

I think I am getting close thanks to this helpful post

Code: [Select]

SELECT
t_object.ea_guid AS CLASSGUID,
t_object.Object_Type AS CLASSTYPE,
t_Package.Name as Package_Name,
t_object.Name,
t_object.PData5 as Keyword,
t_object.Object_ID
FROM t_object, t_package
where t_object.package_id = t_package.package_id
and ((t_object.PData5 IS NULL) OR (t_object.PData5 LIKE '#WC#cloud#WC#'))

[skiwi]

And now something that appears to work - and is being tested:

Code: [Select]

SELECT
t_package.Package_ID AS ExcludePackage,
t_package.Name as Package_Name,
t_object.Name,
t_object.PData5 as Keyword,
t_object.Object_ID
FROM t_object, t_package
WHERE t_package.Package_ID = #PACKAGEID#
AND t_object.Object_ID = #OBJECTID#
AND NOT ((t_object.PData5 IS NULL) OR (t_object.PData5 LIKE '#WC#cloud#WC#'))with reference to http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_publishing/exclude_package_query_and_scri.html