{"id":30961,"date":"2022-12-18T12:33:24","date_gmt":"2022-12-18T12:33:24","guid":{"rendered":"http:\/\/kovaion-new1.local\/peoplesoft-drill-down-ps-query\/"},"modified":"2026-01-06T13:34:27","modified_gmt":"2026-01-06T13:34:27","slug":"peoplesoft-drill-down-ps-query","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/peoplesoft-drill-down-ps-query\/","title":{"rendered":"Peoplesoft | Drill Down PS Query"},"content":{"rendered":"

\"\"<\/p>\n

 <\/p>\n

Introduction<\/strong><\/h2>\n

How often users run queries and write down values returned to navigate to the appropriate page and view the underlying details of those vouchers, journals, vendors, etc?Wouldn\u2019t it be nice if just on a click of a hyperlink embedded within the query results ,have a page pop up in a separate browser window instead. As a solution to this,Drill down PS query can be used .
\nDrill down PS Query is a type of expression which returns the respective URL for the column along with the PS Query Search Results.By clicking the URL or Mapped Fields users are redirected to the respective peoplesoft page.<\/p>\n

 <\/p>\n

Business Benefits<\/strong><\/h2>\n

Eliminates the need of noting down the value and navigating to the component manually to enter the data and open up the page for editing, resulting in a time saver<\/p>\n

 <\/p>\n

Types of Drill-down PS Query<\/strong><\/h2>\n
    \n
  • Query URL<\/li>\n
  • Component URL<\/li>\n
  • External URL<\/li>\n
  • Attachment URL<\/li>\n
  • Free Form URL<\/li>\n<\/ul>\n

     <\/p>\n

    Development of a Drill Down PS Query<\/strong><\/h2>\n

    A Drill Down PS Query can be developed in few simple steps:<\/p>\n

      \n
    • Step 1<\/strong>: Once the query is created, Click Expression -> Add Expression Button.<\/li>\n<\/ul>\n

      \"\"<\/p>\n

       <\/p>\n

        \n
      • Step 2:<\/strong> Select the expression type as Drilling URL.<\/li>\n<\/ul>\n

         <\/p>\n

        \"peoplesoft-drill-down-ps-query-2\"<\/p>\n

         <\/p>\n

          \n
        • Step 3<\/strong>: Once Drilling URL is selected as the Expression type, types will be highlighted.Choose anyone URL type based on the requirement.<\/li>\n<\/ul>\n

           <\/p>\n

          \"peoplesoft-drill-down-ps-query-step-3\"<\/p>\n

           <\/p>\n

            \n
          • Step 4<\/strong>: After all the fields were entered, click the search keys button to populate all the search keys which is in record.<\/li>\n<\/ul>\n

             <\/p>\n

            \"peoplesoft-drill-down-ps-query-step-4\"<\/p>\n

             <\/p>\n

              \n
            • Step 5:<\/strong> After search keys are populated, provide the respective key value. The Selection flag for the particular field name should be selected to fill their key value. These values will be used to By-pass the search key values while the component is redirected.<\/li>\n<\/ul>\n

               <\/p>\n

              \"peoplesoft-drill-down-ps-query-step-5\"<\/p>\n

               <\/p>\n

                \n
              • Step 6:<\/strong> Click the Map column button to populate all the fields from the query record.
                \nSelect the field that needs to be mapped. While the query is executed, on clicking a mapped field the component will be redirected in a separate tab.<\/li>\n<\/ul>\n

                 <\/p>\n

                \"peoplesoft-drill-down-ps-query-step-6\"<\/p>\n

                 <\/p>\n

                  \n
                • Step 7:<\/strong> (optional):\u00e2\u20ac\u0153Use as field\u00e2\u20ac hyperlink will be used to make the drilling URL expression as a new field .<\/li>\n<\/ul>\n

                   <\/p>\n

                  \"peoplesoft-drill-down-ps-query-step-7\"<\/p>\n

                   <\/p>\n

                    \n
                  • Step 8:<\/strong> Click the mapped fields or drilling URL hyperlink to redirecting the respective component in a new tab in our browser.<\/li>\n<\/ul>\n

                     <\/p>\n

                    \"peoplesoft-drill-down-ps-query-step-8\"<\/p>\n

                     <\/p>\n

                    \u00a0 \u00a0Author,<\/div>\n
                    \u00a0 \u00a0Chandru Asokan<\/div>\n
                    \u00a0 \u00a0Kovaion-Peoplesoft Consulting Practice<\/div>\n
                    \u00a0 \u00a0Email:chandru.asokan@kovaion.com<\/div>\n","protected":false},"excerpt":{"rendered":"

                      Introduction How often users run queries and write down values returned to navigate to the appropriate page and view the underlying details of those vouchers, journals, vendors, etc?Wouldn\u2019t it be nice if just on a click of a hyperlink embedded within the query results ,have a page pop up in a separate browser window […]<\/p>\n","protected":false},"author":1,"featured_media":21420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-30961","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-peoplesoft"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=30961"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30961\/revisions"}],"predecessor-version":[{"id":30962,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30961\/revisions\/30962"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/21420"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=30961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=30961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=30961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}