searchplan.yaml

---
secret: "/dbsecrets/pgadmin@cfom_db_int"
database_name: cfom_db_int
search:
  prefix: |
    SELECT "physicians"."PHYSICIANID",
         "physicians"."FIRSTNAME",
         "physicians"."MIDDLENAME",
         "physicians"."LASTNAME",
         "physicians"."MAIDENNAME",
         "physicians"."YEAROFBIRTH",
         "physicians"."YEAROFDEATH",
         "physicians"."BIOGRAPHY",
         "physicians"."ETHNICITY",
         "physicians"."SHOWWEBSITE",
         "physicians"."INSPIRATIONMASK"
    FROM "physicians"
  suffix: |
    ORDER BY "physicians"."LASTNAME" ASC, "physicians"."FIRSTNAME" ASC, "physicians"."MIDDLENAME" ASC
  filters:
    location:
      join: |
         INNER JOIN "locations" ON ("physicians"."PHYSICIANID" = "locations"."PHYSICIANID")
      field: "locations"."STATE"
detail:
  prefix: |
    SELECT "physicians"."PHYSICIANID",
         "physicians"."FIRSTNAME",
         "physicians"."MIDDLENAME",
         "physicians"."LASTNAME",
         "physicians"."MAIDENNAME",
         "physicians"."YEAROFBIRTH",
         "physicians"."YEAROFDEATH",
         "physicians"."BIOGRAPHY",
         "physicians"."ETHNICITY",
         "physicians"."SHOWWEBSITE",
         "physicians"."INSPIRATIONMASK"
    FROM "physicians"
  id: |
    "physicians"."PHYSICIANID"