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 Expression and Prompt While adding criteria first select the Expression and Condition Type should be equal to and then select the Prompt which you created earlier. Add other Criteria like below Make sure here the Condition Type should...