Overview of Portlet Data Sources

Portlet data sources contain the following components:

  • The filter fields found on the edit page for the portlet.

  • The permissions allowing editing of the portlet data source.

  • The SQL query used by the portlet definition to retrieve data from the PPM database.

    A portlet data source SQL query consists of the following:

    • SELECT/FROM. This statement is used to select columns from the designated database table.

      These columns are used by the portlet definition, such as a column in a list portlet or the x-axis in a bubble chart portlet.

      For example:

      SELECT OBJECT_TYPE, OBJECT_NAME, REVISION_NUMBER
      FROM KACC_PSFT_VC_V
    • WHERE. This clause is used to specify selection criterion.

      For example:

      WHERE LOCKED_FLAG="Y"

    • GROUP BY or ORDER BY. These keywords are used to aggregate or sort the result.

      For example:

      ORDER BY OBJECT_TYPE

    The following is a complete SQL query for a portlet data source:

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

Portlet definitions and portlet data sources have the following relationships:

  • A portlet definition can be linked to only one portlet data source.

  • A portlet data source can be linked to multiple portlet definitions.

Portlet data sources are constructed using the Data Source Workbench (sometimes called the Data Source Builder).

From the Data Source Workbench you can:

Note: Micro Focus-supplied portlet data sources can be copied but cannot be modified or deleted.