A single row SQL widget is used to load up to 5 different SQL statements (that each return only one row of data). Once these statements are loaded, you can format the output via an HTML formatting window.
-
Go to: RADplus Utilities > Widget Management > Widget Definition
- Choose Select Widget to launch the Select Widgets screen.
- In the Widget ID field, enter the ID. (Use alphabetic or numeric characters, separate words with an underscore.)
- In the Title field, enter a name for the widget.
- Select the Widget Type (Single Row SQL).
- Select the appropriate attributes from Widget Attributes.
- In the Widget Category field, enter a descriptive category for reference.
- In the Time Limit (seconds) field, enter the maximum number of seconds that the widget will be able to run. This prevents widgets running for too long and degrading server performance. (Not applicable to URL, or URL/POST widgets.)
Note: The maximum time limit for this field is 10 seconds. User-defined widgets (including existing widgets) will be assigned the 10 second time limit by default.
- In the 'SQL Statement' fields - enter the SQL statements.
Note: To display data retrieved from the SQL statements variables are inserted into the HTML in the format:
<sqlvar:#:column_name> where # is the SQL statement number in Sub-Section 2, and Column_Name is the name of the column containing query data.
-
In the HTML Code field, enter valid HTML code.
Note: You have the ability to include LINK tags to certain forms, and/or the client chart within the HTML Code for your widget.
-
Select Submit.
- ► Additional Information
-
