What are missed X-rays costing your office?

Run one read-only query in Open Dental, drop the result here, and see what the bitewings, panos and PAs that fit the plan limits on file but weren’t taken at your periodic exams were worth at your insurance fees. Or look at the next 4 weeks and find the X-rays you can still add.

1Choose what to check

2Run the query in Open Dental

The query (read-only)

Click to copy it.
Open Open Dental. In the menu along the top of the main window, click Reports, then User Query. The User Query window opens.
Look at the large text box at the top of that window. If it already has writing in it, click inside the box, press Ctrl+A, then press Delete so it’s empty.
Click the Paste button near the top of the window (or click inside the box and press Ctrl+V). The query appears in the box.
Click Submit Query. In a few seconds, rows starting with DX1| fill the results area below. A busy office’s 12 months can take up to a minute.
At the bottom of the window, click Export .csv (Export .txt works too). Save the file to your Desktop so it’s easy to find. Don’t use Print or Print Preview: a PDF can’t be read here.

Works with Open Dental 23.2 (October 2023) and newer.

Having trouble?

Open Dental won’t let me paste into the box: Pasting a query needs Open Dental’s User Query Admin permission. Ask whoever manages Open Dental security (often the office manager or the dentist) to run these steps, or to give you that permission. Diastema itself doesn’t need anyone’s permission: it connects through Open Dental’s API.
Open Dental shows an error when I click Submit Query: The query reads each plan’s X-ray frequencies from Open Dental’s code groups, which came with version 23.2 (October 2023). On an older version it stops with an error such as “Table 'codegroup' doesn't exist”. You can see your version in Open Dental under Help › About. GapCheck reads the same code groups, so it needs 23.2 or newer too.
I can’t find the file I exported: If Open Dental didn’t ask where to save it, it went to your office’s Open Dental export folder. You can see which folder that is in Open Dental under Setup › Data Paths.

3Drop the exported file here

Choose the exported file or drag it hereThe .csv or .txt file from Export, not a PDF.

Or paste the results instead

Select every row of the results in Open Dental, copy them, and paste them here.

Uses the same rules as GapCheck, Diastema’s X-ray check: each plan’s bitewing and pano/FMX frequencies from Open Dental, X-rays taken here or recorded as done elsewhere, and a comprehensive exam with 4 bitewings and 3 or more PAs counted as an FMX.