Completing the Group By/Order By Tab

The Group By/Order By tab allows you to refine the SQL query the portlet data source executes.

  • GROUP BY. Adds a keyword to aggregate the result.

  • ORDER BY. Adds a keyword to sort the result.

For example, the following shows a complete SQL query for a portlet data source (the ORDER BY portion of the SQL query is shown in italics):

SELECT OBJECT_TYPE, OBJECT_NAME, REVISION_NUMBER
FROM KACC_PSFT_VC_V
WHERE LOCKED_FLAG="Y"
ORDER BY OBJECT_TYPE

To complete (or update) the Group By/Order By tab in the Query Definition window:

  1. In the Group By Clause section, provide the GROUP BY or ORDER BY terms.

    This is a free-form SQL entry area.

  2. In the Having Clause section, provide the HAVING terms.

    This is a free-form SQL entry area.

  3. In the Default Order By Clause section, provide the default ORDER BY terms.

    This is a free-form SQL entry area.

  4. Click Apply to commit your changes. Click OK to save your changes and close the window.