Page 1 of 1

Custom query pop up for dates

Posted: Wed Nov 22, 2023 2:54 pm
by cheroxy
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?

Re: Custom query pop up for dates

Posted: Tue Nov 28, 2023 4:38 pm
by jsalmon
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.