Peoplesoft Query Creating a simple drillable query and deploying it in under 3 minutes! use these drillable queries to up your query game. What is a ‘drillable query’? the idea of a drillable query – adding hyperlinks to the query results so that users can go directly to a peoplesoft page – is something that excites end users greatly.
Peoplesoft Query Tables The Complete List Explanations Drilling urls allow you to attach hyperlinks to a field in the ps query results. the hyperlink (url) can link to another query, a peoplesoft page (component) or an external website (as well as a few other types). Searching for query selecting query columns for existing drilling urls processing existing drilling urls at runtime steps used to select a query to build drilling urls. Step 1: once the query is created, click expression > add expression button. step 2: select the expression type as drilling url. step 3: once drilling url is selected as the expression type, types will be highlighted.choose anyone url type based on the requirement. It is a peoplesoft query expression type that creates code to drill down to another object. drilling urls are defined by selecting a drill down query, a menu component page combination, url of choice, etc.
Peoplesoft Query Tables The Complete List Explanations Step 1: once the query is created, click expression > add expression button. step 2: select the expression type as drilling url. step 3: once drilling url is selected as the expression type, types will be highlighted.choose anyone url type based on the requirement. It is a peoplesoft query expression type that creates code to drill down to another object. drilling urls are defined by selecting a drill down query, a menu component page combination, url of choice, etc. In this case, we will create 2 queries and try to link them using drilldown url. here i am creating 2 new queries. now, i will add edit prompts on our 2nd query aka "the receiving query". save that and go back to our 1st query aka "the sending query". A drilling url is a url found in the search results when using peoplesoft search framework. when clicked, it displays the appropriate peoplesoft application page, with appropriate data populated in the page. Knowing the tables underlying ps queries will be handy when you have to write a query to fetch some details about queries; for example, to see what other queries are there at your organisation that match a certain pattern or what other queries query a particular table. Dive deep into query manager with this comprehensive guide for technical and functional users. learn advanced tips, features, and best practices to maximize efficiency in your system.
Psquery Peoplesoft Tricks In this case, we will create 2 queries and try to link them using drilldown url. here i am creating 2 new queries. now, i will add edit prompts on our 2nd query aka "the receiving query". save that and go back to our 1st query aka "the sending query". A drilling url is a url found in the search results when using peoplesoft search framework. when clicked, it displays the appropriate peoplesoft application page, with appropriate data populated in the page. Knowing the tables underlying ps queries will be handy when you have to write a query to fetch some details about queries; for example, to see what other queries are there at your organisation that match a certain pattern or what other queries query a particular table. Dive deep into query manager with this comprehensive guide for technical and functional users. learn advanced tips, features, and best practices to maximize efficiency in your system.
Managing Ps Queries Peoplesoft Wiki Knowing the tables underlying ps queries will be handy when you have to write a query to fetch some details about queries; for example, to see what other queries are there at your organisation that match a certain pattern or what other queries query a particular table. Dive deep into query manager with this comprehensive guide for technical and functional users. learn advanced tips, features, and best practices to maximize efficiency in your system.
Comments are closed.