How To Prompt In Query Builder

Once you have added your fields to your query you can prompt for a specific value based on a field by entering Criteria in the Criteria Column in the lower grid of the developer.

For example from vw_CLMSDETAILS_REPv1.DetailDateInitiated for a specific date. In the Criteria Column enter the following

=@Enter Initiation Date

Your prompt will show up on the query as

Enter_Initiation_Date: then you must supply the date in yyyy-mm-dd format for this prompt.

Keep in mind that your prompts can have no spaces therefore use underscores for readability.