Desktop productivity for business analysts and programmers

programmatically control query builder

Reply
Contributor
Posts: 29

programmatically control query builder

The advantage of the query builder is that I can add and drop columns via the builder without having to memorize the dozens of tables and hundreds of variables available. I run a standard query that joins 9 tables and takes a long time to set up in the query builder. A view will not help in this instance because I want to choose needed columns for each project. Is there a way to populate the query builder with a standard set of tables and join logic? Please advise.
Valued Guide
Posts: 2,111

Re: programmatically control query builder

Not sure if this will help...

You could create a "shell" project with the query builder task in it that has the tables and joins and then copy that to start the new project.

Doc Muhlbaier
Duke
Contributor
Posts: 29

Re: programmatically control query builder

Duke - Thanks for the quick response. That's exactly what I do now. I wish you could copy/paste an entire process flow from one project to another.

Thanks again for your help!
goat
Contributor
Posts: 66

Re: programmatically control query builder

Have you tried highlighting each node in the process and copying? I'm pretty sure that used to work
Ask a Question
Discussion stats
  • 3 replies
  • 122 views
  • 0 likes
  • 3 in conversation