Skip to main content

Create a Multiple Row SQL Widget

  1. Last updated
  2. Save as PDF

Similar to Single Row SQL, the Multiple Row SQL statement displays in a word wrap fashion with no line breaks. You may prefer to use an SQL editor to format the statement for easier reading and modification. There are a number of popular SQL editors including RazorSQL, Universal SQL Editor, WinSQL and SQL Explorer.

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.

To use your Multiple Row SQL widget with Templates On Demand functionality, see Enable Templates On Demand for SQL Widgets. 

  1. Go to: RADplus Utilities > Widget Management > Widget Definition
  2. Choose Select Widget to launch the Select Widgets screen.
  3. Select Add New.
  4. In the Widget ID field, enter the ID.
    Note: Use alphabetic or numeric characters, separate words with an underscore.
  5. In the Title field, enter a name for the widget.
  6. Choose the Widget Type (Multiple Row SQL).
  7. In the Widget Attributes field, select the attributes that apply.
  8. In the Multiple Row SQL Statement field, enter all of the SQL statements applicable to your widget.
  9. In the Widget Category field, enter a descriptive category for reference.
  10. 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.)
  11. Select Submit.

Note: Notice when you are creating multiple row widgets is that there is no HTML code frame. Rather, all HTML functionality needs to be called out in the SQL statement.