AnsweredAssumed Answered

How to put link to VIA reports on Dashboard

Question asked by Ece YILDIRIM on Jun 3, 2016
Latest reply on Jun 13, 2016 by Ece YILDIRIM

Like • Show 1 Like1
Comment • 12

Hello,

We are trying to figure out if it is possible to insert links (URLs) for custom Reports directly on user Dashboard.

Right now, we see that there is only 1 style option which is "Inline display".

1- Instead of inline reports, we would like to be able set parametric links so that every user which is eligible to access a certain report can access it via this URL on dashboard.

2- Also, since the url is to be parametric, every user will see a personalized result set from the same query.

Just to give you an idea, let's say that we want to create a report in order to display all subordinates (including indirect ones) of a manager. There will be a link belonging to this report in the user dashboard of Managers. Moreover, clicking the URL each manager will see only their subordinates. Hence every user will get a different result set from the same query.

Is this feasible with VIA?

Moreover, we observed there is an attribute named "URL parameters" in "Add component to Dashboard" popup. Is this attribute useful for reports as well? How?

Andrew Ulliani

Jun 4, 2016 10:31 PM

Correct Answer

Instead of creating the component on your dashboard, first create the component on it own under the Dashboard Components tab. It won't trim the Full URL string if you do it that way. Then add the component to the dashboard.

See the reply in context

No one else had this question

Outcomes

Andrew Ulliani

Jun 3, 2016 12:49 PM

When you click "Create New Component" under Dashboard Components, there is an option for a User Custom Link. You can point the URL string to the report URL. For example, /aveksa/main?Oid=199&ReqType=Dialog&PageID=ViewReportDialogData_save&Action=New&ObjectClass=com.aveksa.gui.objects.report.GuiReport.

Replace 199 with the Oid of your report.

For this type of Dashboard Component, there is no separate "URL Parameters" field. You can put the URL params directly in the URL.

1 person found this helpful

Actions

Ece YILDIRIM @ Andrew Ulliani on Jun 4, 2016 2:36 PM

Hello Andrew,

Thanks. We tried adding URL of report as in below picture.

But when we paste the URL and clicked somewhere around the popup, the URL is transformed as in below picture. Therefore we cannot add custom report link with the suggested approach.

Any comments, please?

Actions

Sean Miller

@ Ece YILDIRIM on Jun 4, 2016 7:30 PM

Do you see any messages in the aveksaServer.log when you see 'Request could not be handled'?

Actions

Andrew Ulliani

@ Ece YILDIRIM on Jun 4, 2016 10:31 PM

1 person found this helpful

Actions

Ece YILDIRIM @ Andrew Ulliani on Jun 5, 2016 8:27 AM

It worked.

As a quick note, it also works when you start with "?Oid=" in URL field.

Actions

Edwin Mullie

Jun 3, 2016 12:59 PM

In the report you can use the :CurrentUserID variable to get the filtered result of the user that is logged in. In the URL you point to the right report, the variable arranges what he then sees in that report

Edwin

Actions

Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 6:19 AM

Hi Edwin,

I tried using :CurrentUserId which is shown below figure.

However, criteria is not applied after running report. I check Filter Criteria again and see that it disappears.

Have i done something wrong?

Actions

Edwin Mullie

@ Ece YILDIRIM on Jun 13, 2016 7:25 AM

Yes the :CurrentUserID goes into the SQL statement on the query tab

Edwin

Actions

Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 8:02 AM

I can not put where clause in it. It just allows table name, a view name, a JOIN clause, and SELECT statement surrounded by parentheses.

Actions

Ece YILDIRIM @ Ece YILDIRIM on Jun 13, 2016 8:04 AM

Example:

MY_VIEW WHERE So = ':CurrentUserID' -NOT WORKING-

Actions

Edwin Mullie

@ Ece YILDIRIM on Jun 13, 2016 8:18 AM

here is an example:

(select * from (select cr.name || ' - ' || cr.description as RequestName, cr.total_approval_time_days || 'd ' ||

trunc(mod(cr.total_approval_time_value * 24 ,24)) || 'h ' ||

trunc(mod(cr.total_approval_time_value * 24 * 60,60)) || 'm ' as "Approval Time",

cr.total_approval_time_text,

cr.total_fulfillment_time_days || 'd ' ||

trunc(mod(cr.total_fulfillment_time_value * 24 ,24)) || 'h ' ||

trunc(mod(cr.total_fulfillment_time_value * 24 * 60,60)) || 'm ' as "Fulfillment Time",

cr.total_fulfillment_time_text

from avuser.pv_change_request cr where cr.source_type='ExplicitAccess' and cr.requestor_id=:CurrentUserID order by RequestName) where ROWNUM <11)

the :CurrentUserID is the ID in Via

Edwin

2 people found this helpful

Actions

Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 8:58 AM

Great, it works.

Thank you for support.

Actions

12 Replies

Andrew Ulliani Jun 3, 2016 12:49 PM
Mark Correct
Correct Answer
When you click "Create New Component" under Dashboard Components, there is an option for a User Custom Link. You can point the URL string to the report URL. For example, /aveksa/main?Oid=199&ReqType=Dialog&PageID=ViewReportDialogData_save&Action=New&ObjectClass=com.aveksa.gui.objects.report.GuiReport.

Replace 199 with the Oid of your report.

For this type of Dashboard Component, there is no separate "URL Parameters" field. You can put the URL params directly in the URL.
1 person found this helpful
Like • Show 0 Likes0
Actions
- Ece YILDIRIM @ Andrew Ulliani on Jun 4, 2016 2:36 PM
  Mark Correct
  Correct Answer
  Hello Andrew,
  Thanks. We tried adding URL of report as in below picture.
  
  But when we paste the URL and clicked somewhere around the popup, the URL is transformed as in below picture. Therefore we cannot add custom report link with the suggested approach.
  Any comments, please?
  Like • Show 0 Likes0
  Actions
  - Sean Miller @ Ece YILDIRIM on Jun 4, 2016 7:30 PM
    Mark Correct
    Correct Answer
    Do you see any messages in the aveksaServer.log when you see 'Request could not be handled'?
    Like • Show 0 Likes0
    Actions
  - Andrew Ulliani @ Ece YILDIRIM on Jun 4, 2016 10:31 PM
    Unmark Correct
    Correct Answer
    Instead of creating the component on your dashboard, first create the component on it own under the Dashboard Components tab. It won't trim the Full URL string if you do it that way. Then add the component to the dashboard.
    
    1 person found this helpful
    Like • Show 1 Like1
    Actions
    - Ece YILDIRIM @ Andrew Ulliani on Jun 5, 2016 8:27 AM
      Mark Correct
      Correct Answer
      It worked.
      As a quick note, it also works when you start with "?Oid=" in URL field.
      
      Like • Show 1 Like1
      Actions
Edwin Mullie Jun 3, 2016 12:59 PM
Mark Correct
Correct Answer
In the report you can use the :CurrentUserID variable to get the filtered result of the user that is logged in. In the URL you point to the right report, the variable arranges what he then sees in that report

Edwin
Like • Show 0 Likes0
Actions
- Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 6:19 AM
  Mark Correct
  Correct Answer
  Hi Edwin,
  I tried using :CurrentUserId which is shown below figure.
  However, criteria is not applied after running report. I check Filter Criteria again and see that it disappears.
  Have i done something wrong?
  Like • Show 0 Likes0
  Actions
  - Edwin Mullie @ Ece YILDIRIM on Jun 13, 2016 7:25 AM
    Mark Correct
    Correct Answer
    Yes the :CurrentUserID goes into the SQL statement on the query tab
    
    Edwin
    Like • Show 0 Likes0
    Actions
    - Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 8:02 AM
      Mark Correct
      Correct Answer
      I can not put where clause in it. It just allows table name, a view name, a JOIN clause, and SELECT statement surrounded by parentheses.
      Like • Show 0 Likes0
      Actions
      - Ece YILDIRIM @ Ece YILDIRIM on Jun 13, 2016 8:04 AM
        Mark Correct
        Correct Answer
        Example:
        MY_VIEW WHERE So = ':CurrentUserID' -NOT WORKING-
        Like • Show 0 Likes0
        Actions
        Edwin Mullie @ Ece YILDIRIM on Jun 13, 2016 8:18 AM
        Mark Correct
        Correct Answer
        here is an example:
        
        (select * from (select cr.name || ' - ' || cr.description as RequestName, cr.total_approval_time_days || 'd ' ||
        trunc(mod(cr.total_approval_time_value * 24 ,24)) || 'h ' ||
        trunc(mod(cr.total_approval_time_value * 24 * 60,60)) || 'm ' as "Approval Time",
        cr.total_approval_time_text,
        cr.total_fulfillment_time_days || 'd ' ||
        trunc(mod(cr.total_fulfillment_time_value * 24 ,24)) || 'h ' ||
        trunc(mod(cr.total_fulfillment_time_value * 24 * 60,60)) || 'm ' as "Fulfillment Time",
        cr.total_fulfillment_time_text
        from avuser.pv_change_request cr where cr.source_type='ExplicitAccess' and cr.requestor_id=:CurrentUserID order by RequestName) where ROWNUM <11)
        
        the :CurrentUserID is the ID in Via
        
        Edwin
        2 people found this helpful
        Like • Show 2 Likes2
        Actions
        Ece YILDIRIM @ Edwin Mullie on Jun 13, 2016 8:58 AM
        Mark Correct
        Correct Answer
        Great, it works.
        Thank you for support.
        Like • Show 0 Likes0
        Actions