PS Query - Extensive use of Expression and Prompts
3 way Prompts In this way user can able to run the query either by giving value or giving prompt value or some part of the value. To do so we need to, Create the Expression Create a Prompt Add criteria with Expression and Prompt Change logical mapping Group the criteria Initial Query Create the Expression Create the Expression like below and in the Express Text give only <single quote> <space> <singlequote> Create a Prompt Create a Prompt for the Field where u need a Prompt while running the Query Please note that here the Prompt Table been mentioned with “No Table Edit” as Edit Type Add criteria with ...