PeopleSoft Reporting Course - PS Query Prompts Tutorial

Subscribe - 👉https://tinyurl.com/peoplesoftchannel #peoplesoft #peopletools The video is a tutorial on how to use prompts in PS Query. Prompts allow users to input runtime parameters for a query, making it more flexible. Here's a summary: Introduction to Prompts: -------------------------------------- The video starts by explaining how prompts can be used to make queries more dynamic, so that users don't have to manually edit the criteria each time 00:00. Creating Prompts: ---------------------------- The video explains how to create prompts for fields like business unit and requisition ID [02:10]. This includes setting properties like field type, heading text, and whether to enable a prompt table for value selection. Assigning Prompts: -------------------------------- The tutorial details how to assign created prompts to specific fields in the query criteria [05:31]. Testing Queries with Prompts: ------------------------------------------------ The video demonstrates how to run a query with prompts, showing how the user is prompted to enter values for the defined fields [06:27]. Use Case: Date Range Prompts: ---------------------------------- The video explains how to create a query report to show header details of purchase orders created in a specific date range, where the date range is not fixed [07:16]. Creating Date Prompts: ------------------------------------- The tutorial explains how to create prompts for date ranges, including setting the correct data type and format [09:02]. Applying Date Prompts: The video explains how to apply the created date prompts to the query criteria, using the "between" condition to filter data within the specified date range [10:37]. Testing Date Range Query: The video shows how to run and test the query with date range prompts, demonstrating how to input the desired date range and retrieve the corresponding results [11:17].