VetLink PRO

Connecting Veterinary Professionals with Smarter Solutions

Skip to content
English - Australia
Sign in
Contact us
  • There are no suggestions because the search field is empty.

Find Animals without Due Reminders (SQL)

v6,v7

See Create Export to CSV using SQL Query for information on using query below for export to csv.
 
SELECT am."Ref_Number" AS "Patient Number",
(SELECT gad."Name" FROM "Get_Animal_Details"(am."Ref_Number") gad) AS "Patient Name",
(SELECT gad."Type" FROM "Get_Animal_Details"(am."Ref_Number") gad) AS "Species",
(SELECT gad."Breed" FROM "Get_Animal_Details"(am."Ref_Number") gad) AS "Breed",
(SELECT gad."Gender" FROM "Get_Animal_Details"(am."Ref_Number") gad) AS "Gender",
(SELECT gad."Neuter" FROM "Get_Animal_Details"(am."Ref_Number") gad) AS "Desexed",
am."Date_Birth" AS "Date of Birth",
am."Owner" AS "Owner Number",
(SELECT gcd."First_Name" FROM "Get_Client_Details"(am."Owner") gcd) AS "Owner First Name",
(SELECT gcd."Last_Name" FROM "Get_Client_Details"(am."Owner") gcd) AS "Owner Last Name",
(SELECT gcd."Mobile" FROM "Get_Client_Details"(am."Owner") gcd) AS "Mobile",
(SELECT gcd."Email" FROM "Get_Client_Details"(am."Owner") gcd) AS "Email"
FROM "Animal_Main" am
WHERE am."Status" = 'A'
AND (am."Deceased" IS NULL OR am."Deceased" <> 'Y')
AND NOT EXISTS (
    SELECT 1
    FROM "Reminders" r
    WHERE r."Sub_Num" = am."Ref_Number"
    AND r."Status" = 0
    )
and am."Ref_Number" > 10000001000
ORDER BY am."Ref_Number"