Page 1 of 1
Is it possible to run query builder against a view?
Posted: Fri 01 Jul 2016 12:52
by dims
Is it possible to run query builder against a view?
I can design SQL files with graphical query builder.
Can I do the same with views (which are just stored queries on server side)?
Re: Is it possible to run query builder against a view?
Posted: Fri 01 Jul 2016 13:12
by alexa
You can design queries with views on the Query Builder diagram as well as with tables.
Re: Is it possible to run query builder against a view?
Posted: Tue 12 Jul 2016 09:51
by dims
How? I don't see a way.
Here is an example of a view, opened in sample database. Only textual representation visible:
Where is the button to call builder?
Here is an example of the same query, opened from SQL file. You can see explicit builder button:

Re: Is it possible to run query builder against a view?
Posted: Tue 12 Jul 2016 10:33
by alexa
Please right-click in the editor and select 'Design SQL...' in the popup menu.
Re: Is it possible to run query builder against a view?
Posted: Tue 12 Jul 2016 12:49
by dims
Ah, that worked, thanks!
Re: Is it possible to run query builder against a view?
Posted: Tue 12 Jul 2016 13:35
by alexa
Please let us know if any questions arise.