programmatically control query builder

[goat]

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.

[Doc_Duke]

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

[goat]

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

[CameronLawson]

Have you tried highlighting each node in the process and copying? I'm pretty sure that used to work