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:

Image

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:

Image

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.