Open Dental Forum

Hi All,
I am working on code that requires me to pull Only Bite wing image or image that are associated only with the BW's folder.
For example, here is how my tree looks:

[BWs]

• image1
  image2

[FMXs]

• image3

[Panos]

• image4

How can i identify only image1 and image2 so that I can operate on them?
Does anyone know how is the reference between folders and X-Ray images done?

I'm confused because all of my X-Ray images are stored in a single folder but somehow the software knows where to display them?
Thank you for your help?

Each image in a patient's folder is represented by an entry in the document table. The document table has a DocCategory column which is a foreign key to definition.DefNum. Your folders in the tree are entries in the definition table. So when pulling images, you will want to retrieve all of the documents for the patient from the DB that have a DocCategory that equals the DefNum of your BWs Image Category definition. Once you have the documents, you can use document.FileName to identify which files in the patient's folder belong to the BWs category.

thank you for your reply!!!