Overview

The NHS Choices Layer links are set to HTTP by default. Changing these to HTTPS is not that difficult as an extra Workflow Task can be added to the NHS Choices Job to change the links from HTTP to HTTPS. 

Step-by-step guide

• Open iShare Studio
• Expand the Workflow node in the Explorer tree
• Expand the Jobs node and find the NHS Choices Job.
• Right click on the NHS Choices Job entry and select New Task.
• Select Stored Procedure Task
• Give the Task a Name, select the DataShare database and the at_wkf_executecmd function (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).
• In the Edit parameter box enter the following SQL.
  
  

UPDATE nhschoices_all SET link = replace(link, 'http:', 'https:') where lower(link) not like 'https%' and lower(link) like 'http%

You may need to change the name of the table (nhschoices_all) if yours is called something different when you created the Task to download the NHS Choices data.

• Save your new Task.
• Now we just need to move this new Task after the Task to Download the NHS Choices data by using the up and down arrows and make the Task Dependant on the previous Task completing successfully.

If you also wish to change the Image link for the NHS Choices logo in My House to be HTTPS then this is done from your My House NHS Choices Virtual Layer Configuration in the Row Settings e.g.

<img src="https://www.nhs.uk/img/header/choices-logo.gif" alt="" /><p>Data supplied by <a href="https://www.nhs.uk" target="_blank">NHS Choices</a></p>