How can I find which reports use a specific parameter query

(4 posts) (3 voices)


No tags yet.

  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.



  2. myDBR Team, Key Master

    This query will show you the unused parameters:

    from mydbr_param_queries q
    where 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


You must log in to post.