Viewing 1 post (of 1 total)
  • Author
    Posts
  • #37385
    Pioneer Software
    Keymaster

      The “Duplicate Primary Emails” report will list any duplicate emails that exist in your database. This is useful if you’re using the ClinicOffice Online Diary which requires each patient to have a unique email address.

      Before you can import this report you will first need to create some custom views in your database function. Please follow these steps :-

      1) Go to the Tools menu (tab) and click Advanced DB Operation

      2) Make sure the “As Administrator” check box is ticked

      3) Delete any code present in this window and copy & paste the code below into the “Advanced Database Operation” window

      create or replace view xview_primary_emails as
      select id, trim(split_part(email, ';', 1)) as email from per where trim(split_part(email, ';', 1)) <> '';

      4) Click Execute, OK

      5) Delete the code and copy & paste the code below

      create or replace view xview_duplicate_primary_email_per_ids as
      select id from xview_primary_emails where email in (select email from xview_primary_emails group by email having count(*)>1);

      6) Click Execute, OK

      7) Delete the code and copy & paste the code below

      select fix_permissions();

      8) Click Execute, OK and then Close

       

      Now that you’ve created the required database VIEWS, please download and install the attached report file.

      For instructions on how to import the downloaded report, please see the article via the following link:-
      https://pioneersoftware.co.uk/forums/topic/how-do-i-import-a-report-file-into-my-database

      Attachments:
      You must be logged in to view attached files.
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.