Custom query pop up for dates

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
cheroxy
Posts: 57
Joined: Mon Aug 13, 2007 5:52 pm
Contact:

Custom query pop up for dates

Post by cheroxy » Wed Nov 22, 2023 2:54 pm

Can anyone help me know what I have to do to have the custom query create the pop up that asks the user to input the dates instead of going in and manually changing the code each time?

User avatar
jsalmon
Posts: 1594
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Custom query pop up for dates

Post by jsalmon » Tue Nov 28, 2023 4:38 pm

It sounds like you are referring to the "Prompt for SET statements" feature behind Query Favorites. Check out the "Run a Favorite Query" section at the bottom of https://www.opendental.com/manual/queryfavorites.html

It might be as simple as needing to change your query to start using SET statements if it isn't already.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply