1 Reply Latest reply on Aug 21, 2017 10:16 AM by Gaspare Provenzano

    How to find templates where they are being applied to analysis?

    Anthony Doyle

      Hi all, I need to find all analysis which have been created using a specific analysis template?   Not sure how to search for these easily in the search function.  Any tips?

       

      Thanks

      Anthony Doyle

        • 1. Re: How to find templates where they are being applied to analysis?
          Gaspare Provenzano

          Hello Anthony,

           

          With this SQL query you can list all your analyses, grouped by template:

           

          select
              pt.name as templ_name,
              p.name as analysis_name,
              a.name as used_in_domain,
              p.plotid,
              a.appid
          from
              plot p,
              plot_template pt,
              appl_plot ap,
              application a
          where
              p.plottemplid = pt.plottemplid
              and p.plotid = ap.plotid
              and a.appid = ap.appid
          order by
              pt.name,
              p.name
          

           

          This query produces an output like:

            

           

          Once you identified the analyses you need, you can search them in the Search box with the syntax:

           

          plotid:id (to search for one analysis)

           

          or

           

          appid:id (to search for one domain)

           

          For example:

          will return the first analysis, in my example.

           

          Hope it helps,

          Regards,

          G.

          1 of 1 people found this helpful