Page History
...
The following portlets are available:
- Adapter Settings. Lets you retrieve data from a specific source.
- Portlet Upgrader. Lets you upgrade all portlets that are using the same Precise installation (source) to another Precise installation (destination).
- Refresh Rate Setting. Lets you configure how often the information displayed in the dashboard is refreshed.
...
- On the Refresh Rate Settings portlet toolbar, click the Edit Preferences icon.
- In the Page refresh rate (minutes) field, type how often you want the information displayed on the page to be refreshed.
- Click Ok OK.
| Anchor | ||||
|---|---|---|---|---|
|
The Tools Portlets provide additional utilities that expand the functionality of the Precise Custom Dashboard. The following portlets are available:IFrame Lets
- IFrame. Lets you display information from a specific URL address.
- Log
...
- In. Lets you access the My Account dialog box and modify your account settings.
- Import from
...
- Precise. Lets you create a new portlet page.
- Quick
...
- Note. Lets you add your own note or comments to a portlet page.
...
- RSS. Lets you display frequently updated Really Simple Syndication (RSS) content in a portlet. Retrieve from Database Lets you query a database and display information from it.
- Time
...
- Frame. Lets you decide the period of time that you want to analyze.
About the IFrame portlet
The IFrame portlet lets you display information from a specific URL address. You must have administrator privileges to set up this portlet. See Configuring the portlet.See , “Changing user passwords” on page 23. See “About the Main menu” on page 10.
About the Log In portlet
The Log In portlet lets you access the My Account dialog box and modify your account settings. See Configuring the portlet.See , “Changing user passwords” on page 23. See “About the Main menu” on page 10.
About the Import from Precise portlet
The Import from Precise portlet gives you the functionality to create portlets based on the view that has been exported from within Precise v9.6 using the Export to the Custom Portal Portlet feature.
| Info |
|---|
...
Prerequisites for the use of this portlet is that you need to have the rights to add portlets. |
To create a portlet with Import from Precise1 Log
- Log in to the Precise Custom Portal.
...
- Go to Add Portlet.
...
- In the portlets tree under Tools, click Add after Import from Precise.
...
- Select the data source.
...
Select the name that was used to create the Export to the Custom Portal Portlet view.
...
Info The date and time stamp will help you choose the most recent view. The last 50 saves are available.
...
- Click Generate the Portlet.
...
- Click Preferences if you want to change the default configuration. See Configuring the portlet.
About the Quick Note portlet
The Quick Note portlet lets you add your own note or comments to a portlet page.
About the RSS portlet
The RSS portlet lets you display frequently updated Really Simple Syndication (RSS) content in a portlet. You subscribe to a feed by entering the feed's URL (one per line) and the number of entries per feed.Note:
| Info |
|---|
It can take a while before content is displayed in this portlet. |
About the Retrieve from Database portlet
The Retrieve from Database portlet lets you query a database and display information from it. The Administrator must configure the database as a data source (in the Adapter Settings portlet) before you can send it a query.
In the Filter Data By field, enter the name of the data source that you want to retrieve data from and enter an SQL
statement that is used to query the database and retrieve the information. An SQL statement must begin with one of the following commands:
■ Select
■ With
You can also define the time frame for your retrieved information by entering an SQL statement. The time frame has four parameters:
■ !~timeFrameFromString~! - This parameter is the start time in yyyy/mm/dd hh:mm:ss a format
■ !~timeFrameToString~! - This parameter is the end time in yyyy/mm/dd hh:mm:ss a format
Example To define a time frame that ends at 2010/01/16 02:20:45 am, enter the following query:
select * from A where time > ‘!~timeFrameToString~!’
■ !~timeFrameFromLong~! - This parameter is the start time
■ !~timeFrameToLong~! - This parameter is the end time
Example To define a time frame that ends at 123246486, enter the following query:
select * from A where time > ‘!~timeFrameToLong~!’
Note: In certain JDBC drivers, such as in Oracle JDBC, a query containing a count(*) function, must be typed as follows:
select count(*) as c1 from table_1
Note: Adding a semi-colon (;) at the end of a query causes a query parse error in some JDBC drivers.
When you choose a display view for the information retrieved from the database, verify that you choose a view that is appropriate to the query you selected.
The following table describes how the information retrieved from a database is displayed.
Table 3-8 Available display views
Format Description
Table Displays the data in table format.
Bar chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed along the X-axis. Remaining numeric columns are displayed as values in the chart.
Multiple line chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed along the X-axis. Remaining numeric columns are displayed as values in the chart.
Combined multiple line chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed along the X-axis. Remaining numeric columns are displayed as values in the chart.
This chart has multiple Y-axes, each axis corresponding to a specific line.
Horizontal bar chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is always displayed. Remaining numeric columns are displayed as values in the chart.
Line chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed along the X-axis. Remaining numeric columns are displayed as values in the chart.
Multiple pie chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed as the name of the chart. Remaining numeric columns are displayed as values in the chart.
Each row is displayed in a different pie.
Pie chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is displayed as the name of the chart. Remaining numeric columns are displayed as values in the chart.
Only the values in the first row are displayed in the pie chart.
Table 3-8 Available display views
Format Description
Ring chart Only numeric data is displayed. Non-numeric data is ignored.
The first column of data is always displayed. Remaining numeric columns are displayed as values in the chart.
Only the values in the first row are displayed in the ring chart.
...