Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Paolo F Cantoni on September 06, 2018, 03:44:27 pm

Title: Forcing additional Fields in Query Builder searches
Post by: Paolo F Cantoni on September 06, 2018, 03:44:27 pm
Is there any way to force the inclusion/exclusion of specific fields in the query result of the Model Search?
For example, a lot of our searches benefit from including the Version field in the output.  However, it's not there by default and we have to add it via the Field Chooser.

Must I throw away the Query Builder and do everything via direct SQL queries to get the specific fields and sort orders I need?

TIA,
Paolo
Title: Re: Forcing additional Fields in Query Builder searches
Post by: Geert Bellekens on September 06, 2018, 03:49:07 pm
Must I throw away the Query Builder and do everything via direct SQL queries to get eth specific fields and sort orders I need?
Yes, why would you bother with the query builder if you can simply write the query in SQL  ;D
(or maybe that's just me  :P)

Geert
Title: Re: Forcing additional Fields in Query Builder searches
Post by: Paolo F Cantoni on September 06, 2018, 04:15:45 pm
Must I throw away the Query Builder and do everything via direct SQL queries to get the specific fields and sort orders I need?
Yes, why would you bother with the query builder if you can simply write the query in SQL  ;D
(or maybe that's just me  :P)

Geert
My users like the Query Builder and I was wondering if it was just not knowing where the functionality was hidden.

Paolo