Page History
...
- Go to Control Panel>Portal>Communities.
- Click Add.
- Fill in the relevant information for the community, such as Name and Description.
- Select the community type:
- Open. Available for all users.
- Restricted. Available for a restricted group of users.
- Private. Only available for you.
- Mark the checkbox to make the community active.
- Optionally, add one or more tags.
- Click Save.
...
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
- 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~!
...
'
Info |
---|
...
In certain JDBC drivers, such as in Oracle JDBC, a query containing a count(*) function, must be typed as follows:
|
...
Info |
---|
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 8 Available display views
Format Description
Table Displays
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 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.
...