Link to eChart and Other Areas from RBT Result

How to link to a patient’s eChart or other areas in OSCAR that require query parameters (such as demographic #) from an RBT?

When you need a quick link to a patient’s chart from an RBT (i.e. when you are reporting a list of patients that fit X criteria and need to enter the chart from RBT results), you can use this in the <query>:

    CONCAT(
        "<a href=\"javascript:window.open('../../oscarEncounter/IncomingEncounter.do?demographicNo=",
        demographic_no,
        "','eChartPopup','width=1150,height=650');\">",
        "eChart",
        "<a/>"
    ) AS "eChart"

It is better than <a … target=”_blank”…> which opens a new tab, since that hides the RBT behind the tab. This one opens the eChart as a popup window so it’s in front of the RBT.