Open Dental Forum

graham_mueller

Hi all,

I'd like to tag a +1 on statement generation; I would like to, given a patient id, generate and send a statement like the statement window email button. The GET endpoints right now seem to offer only a "fetch existing" statements function, but we're looking for a way to automate sending.

graham_mueller

Hello, just wanted to bump a need for some additional context again. We had a situation today where a procedure was booked via our application as a new patient, but for a two year old. We explicitly disallow child sign up right now, so there was concern at the clinic as to how this happened. Unfortu...

graham_mueller

Ah, it looks like there's a "preference" for this based on this thread. I'll use that for now, although including it in the status endpoint could still be useful.

graham_mueller

Hello all, as mentioned in a previous thread , I've reached the point where some of my clients have migrated to version 24 while some remain on version 23, breaking my queries. Given there is no halfway step, I need to maintain two separate queries based on which version clients are running, but I d...

graham_mueller

Followed up with support; ProcedureLogs are not archived, but the clinics I'm working with didn't associate them with Appointments prior to 2019, so I have to tie up another way, likely just by date.

graham_mueller

This is sort of a follow on to this topic regarding billing . In another portion of our software, we're trying to do some patient balance work, which had been using ProcedureLog as the source for "ProcFee," but it appears that after ~5 years, this data no longer exists? A simplified version of my qu...

graham_mueller

Heck, I can run that query with just the word CREATE, DROP, or SET and it works. It only fails with ROLE.

graham_mueller

I understand the limitations of your query API, but if you're going to search for the text "role," could you at least make it "freestanding," prefixed by a non-word character or something sane to prevent this sort of failure? This behavior is different for (eg) SET, searching for a patient named Set...

graham_mueller

A weird, random thing we ran into today. A user searched for a patient named Carole... Query cannot contain "ROLE" I thought surely I must have made a mistake somewhere and that it wasn't that, but searching "Caole" (or something real, like John) works fine. This is from a call to the ShortQuery end...

graham_mueller

Unfortunately as you may have gathered from my trying to piece together tables above... no API for what I'm trying to do here, currently working via ShortQuery bandaids that will break on update. Would be happy to see a GET Appointments/Planned or etc, though. That and TreatPlans that provide the sa...

graham_mueller

Ok, so to clarify, it isn't being deprecated in version 24.2, it's just going to be removed at that point. Not sure if you're in a position to ask this of the dev team, but it would be useful if the planned table could be maintained for an additional version when the new field is added so that I can...

graham_mueller

Hi Justine, Could you confirm that my understanding of the NextAptNum link is correct? You can determine that a PlannedAppt is complete by looking for a Appointment that has a NextAptNum that's the AptNum in the PlannedApt table? If you're deprecating it in 24.2, I would expect that to mean it conti...

graham_mueller

If I'm understanding you (and the data I'm seeing), it appears that the appointments that are linked to the PlannedAppointments do not ever have a NextAptNum, but there are appointments that are linked to *those* appointments via the NextAptNum. So if PlannedAppointment has Appointment 1 linked to i...

graham_mueller

Hello, Trying to understand Planned Procedures now as well. I have a patient that has six items in the Planned Appointment view. Four of the six are "complete" in the OD UI. What is used to mark this? The PlannedAppt table has four columns, I initially expected that AptNum would be empty for incompl...

graham_mueller

You can see our DB Schema for the difference between ProcedureLog.ProcFee and ClaimProc.BaseEst. ProcedureLog.ProcFee: Procedure fee. ClaimProc.BaseEst: Always has a value. Used in TP, etc. The base estimate is the ((fee or allowedOverride)-Copay) x (percentage or percentOverride). Does not include...

graham_mueller

Procedure.ProcFee - Claimproc.InsEstTotalOverride or Claimproc.BaseEst for Primary Insurance - Claimproc.InsEstTotalOverride or Claimproc.BaseEst for Secondary Insurance - Claimproc.WriteOffEstOverride or Claimproc.WriteOffEst - Procedure.Discount + Procedure.TaxAmt = Patient Portion Comparing to w...

graham_mueller

Ok, spend a bit more time this morning. From the API docs, it appears ProcTP is only for *saved* / inactive plans, which is why I can't see them for the patient I'm looking at. Is there a way for *active* plans to see the cost information from my screenshot? I've not been able to find an endpoint th...

graham_mueller

Unfortunately the group that told me that the Break didn't log was apparently mistaken, I've tried now and see the same. I looked at the security log table now, and it is what I thought, just a message and a patient link more or less. Their initial complaint was the lack of detail in the messages. I...

graham_mueller

Hi Justine, What you've linked sounds like what I'm looking for, but the instance I'm looking at doesn't seem to align with that. I have a test patient that I've been using as an example, and in the Tx Plan tab of open dental, I can see both a series of groupings by priority, the individual procedur...

graham_mueller

Hello, We're working on a feature to allow patient to schedule treatment based on what providers have entered in their transaction plan region. I'm not sure if this is displayed via plugin, seems like it's a built in feature - the treatment plan shows a base Fee amount, which is list price, as well ...

graham_mueller

Hi Justine, Back to ask about this again - as a third party, it would still be great for us to be able to write more detailed / specific audit entries to the audit trail. Haven't looked a bit more into what is being logged, it seems that what OD reports isn't super detailed in some cases and we'd pr...

graham_mueller

Great, thanks Justine. Things do seem to be resolved on our end as well.

graham_mueller

Thanks for the update Justine. If possible while working on that status page, could a status endpoint be added so that we can check this sort of thing programmatically as well?

graham_mueller

Is there an endpoint we can hit to check the Open Dental API status? We're currently seeing a major slowdown seemingly across all of our clinics, and the hang up seems to be at the API layer, but I can't find anywhere to check status.

graham_mueller

Hi Justine,

Could *some* sort of audit mechanism be exposed? It would be useful as a 3rd party to be able to say "here's a snapshot of an action we took" as well.

graham_mueller

There currently exists an endpoint called SecurityLogs that I am able to read from. I would like to be able to write audit items to the system as well. Is this something that could be added?

graham_mueller

Unfortunately after playing a bit more with my query, I've realized that I actually can't work around this for the query that I'm hoping to use, which is effectively as follows. ( select ... from commlog cl join patient p on cl.PatNum = p.PatNum where cl.Mode_ = 5 and cl.CommLogNum in (a set of ids)...

graham_mueller

You are correct that this problem is perhaps not limited to union, and in fact running even a single (select 1) statement in the parentheses has the same behavior. I could retitle to "parenthetical query being treated as not read-only" if you'd prefer. There's evidently some difference between runni...

graham_mueller

I don't really understand your reply; it looks like you got a different error based on a lack of permission? I'm attaching my query window, minus the actual rows since they're patient info. I'm running against an instance OD version 23.2.52.0 for this particular query.

graham_mueller

Whoops, sorry - thought I had posted to API. The error I see does not occur when I post in the query interface in the Open Dental client. Here's a more specific example you could test with. (select * from patient where PatNum = 1) union all (select * from patient where PatNum = 2) This returns the r...

graham_mueller

A further example, the analyzer considers this a valid read-only statement.

Code: Select all

select foo from table
union all
(select bar from table)
limit 10
offset 0

graham_mueller

I'm making a request to the ShortQuery endpoint that contains a union, which is surrounded by parentheses to add a limit at the end, ala (select foo from table) union all (select bar from table) limit 10 offset 0 The API returns the message "Query command must either be read-only or execute on a tem...

graham_mueller

With regard to "break," I just meant delete. Apparently this language is only used in the API for appointments, and perhaps has a different connotation than I realized. We're just looking for a mechanism to either replace an existing document with a new version, or delete an old document and then ad...

graham_mueller

It appears the documents api does not support updating, "breaking," or deleting documents. Am I missing an option for this? Could this be added otherwise? I'm also unable to do so via the ShortQuery API, I hadn't realized this was readonly.

graham_mueller

Since our backend is using Node.js, and our OD calls are made using Axios, I found this StackOverflow post that was able to solve the problem, so perhaps not an issue here at all.

graham_mueller

Hi Justine, These are "short" queries, I'm not getting a timeout - the API is resetting my connection. The appointment endpoint doesn't provide the data I need, or rather doesn't provide the filter controls I needed. We discussed this is another thread about Appointment Slots. The issue isn't the qu...

graham_mueller

I started to try to loop through result sets today, because one query is getting a set of appointments with length > 100. When I make a second request with Offset=100, the OD API server seems to be killing my connection each time. I'm hitting [PUT] https://api.opendental.com/api/v1/queries/ShortQuer...

graham_mueller

In the desktop client, you can specify whether the system displays in 5/10/15 minute intervals. Is this setting exposed via the API? I'm not sure what name to search, and I haven't been able to find something that seems appropriately named. ETA: Specifically, in the Open Dental desktop application, ...

graham_mueller

works almost identically to the standard appointment search found within Open Dental. Perhaps I was unclear with what I meant here, I expected this to be the case and it was not. I was not getting similar results; when I would search via the OD UI, I was presented with many more options for the sam...

graham_mueller

Which fields would you like to filter the results by? For my specific scenario, I would like to filter by the preferred field that doesn’t currently exist. The non human would make a possible alternative, but more generally on all the endpoints, having the ability to filter by any of the keys that ...

graham_mueller

I'm interested in what the intended use of the Slots API is. My expectation is that it would provide me with *all* slots that fit a certain set of criteria (eg operatory + appt length in the simplest case), but it instead only appears to return one slot per day, and doesn't line up with what the sch...

graham_mueller

Hi all, New to the forums, going to bundle a couple things here under a primary question. Let me know if you prefer things broken up. The gist of my goal here is, I'm hoping to surface referral options to users as they book appointments. The clinic I'm working with has many referrals set up; I want ...

Search found 42 matches