Find Patient

The Find Patient window implements the OSX predicate editor with which you can search the PSpatients.sqlite database using about 50 different treatment planning parameters. To simply list all patients in the database, perform an empty search as illustrated below. Resize the window to reveal as little or as much of the list as you wish.

The PSpatients.sqlite database also stores a file path to the most recent version of the treatment plan files. If you are receiving PS Log messages that prior patient treatment plans are no longer reachable, you have either deleted the plans or moved them from their last saved file location. There are several ways to clear these file error log messages:

  • Delete from Database: Deletes the currently selected (highlighted) patient from the database. Deletions are immediate and permanent, so be careful. Use this button to individually delete any patients from the database for which you have deleted their plans or no longer have any interest in.
  • Update Database: Selectively updates the database (considering only the currently displayed list of patients) by searching your designated Plaque Simulator Patients folder (see preferences settings) for any currently unreachable treatment plan files. Search for a patient (or group of patients) and then use this button to update the database if you have reorganized patient treatment plans within the Plaque Simulator Patients folder.
  • Clean Database: Updates the entire database by first backing up the current database file, then searching your designated Plaque Simulator Patients folder for all unreachable treatment plan files and deleting those patients which can no longer be found from the database. Use this button to update the database if you have reorganized many patient treatment plans within the Plaque Simulator Patients folder. Note: If something goes amiss, you can restore the prior database by quitting PS6, dragging the revised PSpatients.sqlite file to the trash, manually changing the file name of the backup xPSpatients.sqlite to PSpatients.sqlite (just delete the leading 'x' character from the file name), and then relaunching PS6.
  • Rebuild Database: Rebuilds the database by first backing up the current database file, then creating a new, empty database file and repopulating it by parsing your designated Plaque Simulator Patients folder for all treatment plan files. Each treatment plan found is opened, data extracted, and a new database entry created for that patient. This process requires about 6 seconds per treatment plan, so rebuilding the database from scratch this way can take a very long time if you have hundreds of patients to restore.
  • Copy to Clipboard: Copies the search results table to the clipboard from which you can then paste it into a spreadsheet or text file.
  • Clear: Clears the search results table.
  • Search: Searches the database according to the selected predicate settings.

Note: the screen captures below have been anonymized.

EmptySearch

To perform a conditional search, create a list of search conditions using the popup menus and data fields. The + button adds a new condition line. The - button removes its condition. When your list of conditions is complete, click the Search button. Below is an example of an age related search that employs two conditions, all of which must be true.

AgeSearch