Open Dental Forum

we have a great tool and people might put comments, tx images everywhere. i like to see a google like search option on the database. this is where i can specify implant consults in search and it will give me everything that has implant consults, in appointments, comm log, emails, images, or any where else. it be also nice if images can use ocr capabilities to store and index image files. And then ability to do search on those would be awesome.

Creating a Google-like search for a database is neigh impossible. Most tables will not have what you are looking for stored as a string but instead will store it as a key to another table so it would be EXTREMELY complicated to search through the entire database. That and not all of our "foreign key" columns in the database are named in a searchable fashion. E.g. the patient FK in some cases is named "subscriber"