Advanced Features
Advanced prompt features are available to make the executing of the profile easier for users. In this example, which was created by the Ask a Question editor, we have manually changed the query after it was entered in the query field of the Correspondence mail merge screen to change the dates to a prompt.
The query has the following lines:
SELECT DISTINCT *
FROM PATIENTS
WHERE (PATIENTS.BIRTHDATE between :BeginDate and :EndDate )
The Where statement was changed from
WHERE (PATIENTS.BIRTHDATE between 01/01/1900 and 01/01/2016 )
To read:
WHERE (PATIENTS.BIRTHDATE between :BeginDate and :EndDate )
The " : " (semi-colon) is a prompt command which we followed with the text to be used for the prompt. When a user executes the query, this change results in the display of a Prompt dialogue box in which the user can select the begin and end date for the selected data.
The calendar used can easily modify the select date when a user clicks on either the navigation arrows on each side of the calendar, or on the month or year text at the top of the calendar.
