Completing the Select/From Tab

The Select/From tab allows you to construct the SQL query the portlet data source executes.

  • Select. This statement identifies one or more columns to be included in the query.

    For example, the following shows a complete SQL query for a portlet data source (the SELECT statement 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

    Note: PPM allows using wildcard (*) in the select statement. However, if you do so, PPM switches off pagination for some request portlets, which may result in performance issue.

  • From. This clause selects the table from which the columns are selected.

    For example, the following shows a complete SQL query for a portlet data source (the FROM clause 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 Select section on the Select/From tab in the Query Definition window:

  1. (Optional) To change the settings for any existing column:

    1. Select a column.

    2. Click Edit in the Select section.

      The Data Source Column. <Column Name> windows opens.

    3. The information that should be provided depends on the Column Type. See Supplemental Details for the Data Source Column Window for the details associated with each column type.

    4. Click Save to commit any interim changes. Click OK to save your changes and close the window.

  2. (Optional) To include a new column.

    1. Click Add in the Select section.

      The Data Source Column: New window opens.

    2. The information that should be provided depends on the Column Type. See Supplemental Details for the Data Source Column Window for the details associated with each column type.

    3. Click Save to commit any interim changes. Click OK to save your changes and close the window.

  3. Repeat Step 1 and Step 2 until all the desired columns are included.

  4. In the From Clause section of the Select/From tab of the Query Definition window, complete the associated clause.

    This is a free-form SQL entry area.

    Tip: Click Enlarge to create a larger text entry field.

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