Dashboard with Chromecast

(2 posts) (2 voices)

Tags:

No tags yet.

  1. jcushman, Member

    Hi,

    Currently, we are casting a report to a TV in our work area, which shows progress for the day and refreshes every 3 minutes. We're using chromecast and it works great.

    My Question: Is it possible to "loop" two or more reports? I'd like it to work like this:

    Report 1 shows on the screen. After x minutes, the pages refreshes and shows Report 2. After x minutes, the page refreshes and shows report 1....back to 2....back to 1....etc.

    Any help would be great. Thank you.

  2. myDBR Team, Key Master

    Sure, one way of doing it would be to use separate report which refeshes itself and calls the new report on each turn. You can store the called report to a separate table.

    create procedure sp_DBR_chromecast()
    begin declare v_cc_id int; select id into v_cc_id
    from chromecast_report; if (v_cc_id>3) then
    set v_cc_id = 1;
    else
    set v_cc_id = v_cc_id + 1;
    end if; update chromecast_report
    set id = v_cc_id; case v_cc_id
    when 1 then call sp_ chromecast_report_1();
    when 2 then call sp_ chromecast_report_2();
    when 3 then call sp_ chromecast_report_3();
    end case; select 'dbr.refresh', 180; end


Reply

You must log in to post.