The URL for my MyDBR instance is under https://
Here is the sql code in my stored procedure:
SELECT 'dbr.text', CONCAT('
<table border=0 width=60% align=center><tr><td><b>Direct Reports</b></td></tr>');
SELECT 'dbr.report', 'sp_DBR_processlist_single_user', '4', 'employee=[id]', 'show_direct_report=1';
SELECT 'dbr.hidecolumn', 'id';
SELECT 'dbr.hidecolumn', 'answer';
SELECT
'1' as answer,
CONCAT('"', a.id, '"') as id,
CONCAT('dbr.purehtml:
') as Image,
CONCAT (a.firstname,' ',a.lastname) as 'Employee Name',
a.title as 'Title',
b.name as 'Unit',
-- CONCAT(d.firstname, ' ', d.lastname) as 'Reports To',
CONCAT('dbr.purehtml:', lower(a.email), '') as 'Email',
a.phone_office as 'Phone - Office',
a.phone_mobile as 'Phone - Mobile',
a.phone_other as 'Phone - Other',
c.name as 'Position'
FROM datawarehouse.employees a
JOIN processes.units b ON a.unit = b.id
JOIN processes.positions c ON a.position = c.id
LEFT JOIN datawarehouse.employees d ON a.reports_to_id = d.id
WHERE (a.deleted <> '1' OR a.deleted IS NULL)
AND a.reports_to_id=REPLACE(employee,'"','')
ORDER BY a.lastname ASC;
The report it's linking to is sp_DBR_processlist_single_user. If I view-source this page, here is the html that is generated that shows the link to the linked report:
<tr class="odd" data-set="0">
<td class="ReportOutCell align_l" >
</td>
<td class="ReportOutCell align_l" >MacKenzie Frei</td>
<td class="ReportOutCell align_l" >Marketing Specialist</td>
As you can see, the link to 'mydbr/report.php' is http, not https.
I can provide screenshots if that would help. Thanks
