rhettc

Home  Welcome to the Open Dental Query Examples Page

These query examples were written for other practices, usually for a specific purpose. There may be additional changes needed to return the results you want.
Queries are sorted chronologically, with queries written for older versions listed first and queries written for newer versions listed last.
We recommend looking at higher numbered queries first, because older queries may not work in new versions.

If you find a query you like, copy/paste the query into Open Dental to run it. See User Queries
If needed, change
any required variables before running. Look at the query comments for variable descriptions.

rhettc

Home  Welcome to the Open Dental Query Examples Page

These query examples were written for other practices, usually for a specific purpose. There may be additional changes needed to return the results you want.
Queries are sorted chronologically, with queries written for older versions listed first and queries written for newer versions listed last.
We recommend looking at higher numbered queries first, because older queries may not work in new versions.

If you find a query you like, copy/paste the query into Open Dental to run it. See User Queries
If needed, change
any required variables before running. Look at the query comments for variable descriptions.

rhettc

##########
# Tweaked Win10 Initial Setup Script
# Primary Author: Disassembler <disassembler@dasm.cz>
# Modified by: alirobe <alirobe@alirobe.com> based on my personal preferences.
# Version: 2.20.2, 2018-09-14
# Primary Author Source: https://github.com/Disassembler0/Win10-Initial-Setup-Script
# Tweaked Source: https://gist.github.com/alirobe/7f3b34ad89a159e6daa1/
# Tweak difference:
#
#    @alirobe's version is a subset focused on safely disabling telemetry, some 'smart' features and 3rd party bloat ...

rhettc

Async Await Best Practices Cheat Sheet

Summary of Asynchronous Programming Guidelines

Name	Description	Exceptions
Avoid async void	Prefer async Task methods over async void methods	Event handlers
Async all the way	Don't mix blocking and async code	Console main method
Configure context	Use ConfigureAwait(false) when you can	Methods that require con­text

rhettc

void setupButton(int pin, Bounce debouncer)
{
  pinMode(pin, INPUT_PULLUP);
  // configure the de-bounce for this button
  debouncer.attach(pin);
  debouncer.interval(5); 
}

void setup() {

rhettc

# given the structure
../foo/bar
../fizz/bang
../beep
# move into the beep child dir and run the command
cd beep
find ../ -mindepth 1 -type d  -printf "%P\0" | xargs  --null mkdir
# now beep has the same structure 
./foo/bar
./fizz/bang

rhettc

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TemplateFoo
{
    class Program
    {

rhettc

du -chd1 -t1G
# include grand total, friendly sizes, max depth 1, greater than 1G

rhettc

const int c = 261;
const int d = 294;
const int e = 329;
const int f = 349;
const int g = 391;
const int gS = 415;
const int a = 440;
const int aS = 455;
const int b = 466;
const int cH = 523;

rhettc

SELECT procpid as pid,
         usename as user,
         datname as db,
  application_name as app, waiting as wait, current_query as query
FROM pg_stat_activity
WHERE datname <> 'postgres';