1. 

   Mark Tetrode, Member

   Hi MyDBR Team

   I have quite some parameter queries, and I suspect some are not used anymore. Is there a way to find out which reports use which parameter query?

   Also, this could be a feature that you could add to MyDBR on the parameter queries page, when selecting a parameter query, show all reports that use this parameter query.

   Thanks

   Mark
2. 

   myDBR Team, Key Master

   This query will show you the unused parameters:

   select q.name
   
   from mydbr_param_queries q
   
   where q.name not in (
   
     select if (q.coltype=3, p.default_value, p.query_name )
   
     from mydbr_params p
   
     where if (q.coltype=3, p.default_value, p.query_name ) is not null
   
   )
   
   

   We'll add the functionality to the parameter page so you can directly see which one are not used / used and if used, where.

   --
   myDBR Team
3. 

   nsepetys, Member

   This would be helpful! Thanks for the idea Mark Tetrode. And thank you myDBR team for incorporating this into the platform.
4. 

   myDBR Team, Key Master

   This functionality is included into latest build.

   --
   myDBR Team

Reply

You must log in to post.