International tooth numbering in queries

[Mifa]

We're using OD 6.7. I'm building a custom query for the procedurelog table. I need to show the tooth number using the international system numbering, not the US one. Is there a simple way to do that? Has this been addressed in a more recent version?

Thanks

[jordansparks]

I don't think that has been addressed.

[Lorita]

Open office does not have the ability to use FDI World Dental Federation Two-Digit Notation (international)?
We primarily use this in Canada, please advise as I am considering to use Open Office and this would be a definite consideration.
Thanks in advance.

[jordansparks]

Open Dental definitely does have very good support for FDI notation. I was wrong. I just tested it, and as long as you run the query from inside Open Dental, it will reformat the tooth numbers.

[Mifa]

I guess I will have to upgrade to a newer version to get it to work, it definitely does not in 6.7.

Thanks.

[jordansparks]

The column name in the result must be toothnum; capitalization is not important. I don't think anything has changed in newer versions. So it sort of depends on how you write the query. For example, it won't work in the WHERE clause, only in the result set.

[Mifa]

That was it. Leaving the column header to toothnum fixed it. That works for me. Thanks!