Forum Discussion

Netrelemo's avatar
Netrelemo
Helper IV
6 years ago

How do I see ALL queries in one code window?

I have 25 data sources to work with, and each data source needs a whole heap of manipulation. 

 

I can use the "advanced editor" to just write the code, instead of waiting for screen refreshes etc. But each data source has to be edited indivisually. Is there no way to just see ALL the code in one window. IF taht was possible, I should be able to do in 1 hour what currently takes me a whole day to do. 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    It is possible! While in Desktop, go to File, then About, then you'll see an option to "Copy session diagnostics to clipboard". Paste that information into a text file, and you'll have access to all of your queries in one spot. It's not the 'perfect' solution, but with Find and Replace, you can update all your code at once, and then paste it back into the individual queries.

    • Netrelemo's avatar
      Netrelemo
      Helper IV

      ...and then I can separate the all out afterwards again.. ğŸ¤•🤕🤕🤕

       

      Just when I thought I understood the extent of the admin overhead, it goes to a whole new level 

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support

        Hi Netrelemo ,

         

        It's impossible to achieve your idea in current version( 2.81.5831.821 64-bit (May 2020) ).

        Unless you merge the tables of all data sources into one table.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.