Direct URL

(2 posts) (2 voices)

Tags:

  1. alexandrepupo, Member

    Hi.

    The direct URL available in myDBR version 1.5 looks like a hash and I would to know if the function is also available to user.
    I'm asking because I'm embedding myDBR reports inside a custom tool and I would like to build a dynamic report tree inside my tool.
    The reports folder's structure is available because it is a set of rows inside mydbr_folders table, but direct URL to reports is not recorded in mydbr_reports table and ad-hoc generation is not opened to final users.
    It's possible to release the link generation function to users, or record the link as an additional field in mydbr_reports table when next version of myDBR is released?

    Thank you,

    Alexandre Pupo
    E-mail: alexandrepupo@yahoo.com.br

  2. myDBR Team, Key Master

    Hi,
    bit of an explanation how the report's direct URL works, since one report can have different hashes.

    myDBR provides direct URL's to reports. The URL will contain all the information needed to run the report, i.e. which report to run with which parameters. Parameters are divided into user modifiable parameters and myDBR given parameters. In addition to the report Id and the parameters, a hash is calculated for each URL to make sure the URL is generated by a trusted source.

    As an example you might have a business report which shows relevant information for each person using the report. Report has parameters like Business_Area and start and end date. User is allowed to change the dates, but the Business_Area is fixed for each user. The hash is in this case calculated based on the report ID and Business_Area. User is now allowed to change the dates in URL, but changing Business_Area would not be allowed.

    We'll investigate opening the hash generation algorithm in myDBR to admins and allow admin to provide own seed values for the hash generation. This would allow anyone with admin rights to generate the URL's without the need to copying URL's from myDBR.

    --
    myDBR Team


Reply

You must log in to post.