How can I find which reports use a specific parameter query

(4 posts) (3 voices)
  • Started 2 years ago by Mark Tetrode
  • Latest reply from myDBR Team

Tags:

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.

    Thanks

    Mark

    Posted 2 years ago #
  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

    Posted 2 years ago #
  3. nsepetys, Member

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

    Posted 2 years ago #
  4. myDBR Team, Key Master

    This functionality is included into latest build.

    --
    myDBR Team

    Posted 2 years ago #

Reply

You must log in to post.