User's manual

This plugin adds a new button to the system administrator area.

  • In the "Adminitration" home tab, a new "Data source explorer" icon is available in the "Application" group.

  • When the "Data source" tool is open and a data source SQL is selected, the "Explore" button is available in the "Data source explorer" contextual tab of the ribbon.

Content of data sources

Once open, a tool is displayed listing all supported data sources, and when the nodes are opened, the contents can be viewed.

For example, for a data source SQL, the list of tables is displayed.

You can then select the table of your choice and click on the "Explore" button in the "Data source explorer" contextual tab.

You can also double-click on the name of the table to be opened.

Table contents SQL

The tool that displays the contents of a table takes the form of a grid.

The tool title contains: the name of the table SQL followed (in brackets) by the name of the data source.

Each column of the grid represents a column of the table SQL whose label contains :

  • the column name SQL,
  • the data type of the SQL column,
  • the nullable attribute of the SQL column,
  • the primary key attribute of the column SQL where applicable.

Column headers can be clicked to sort the column in ascending order, then re-clicked to sort in descending order.
Column headers also feature a menu for sorting and hiding columns.

Each row in the grid represents an entry in the SQL table.

Texts are truncated to 255 characters. In this case, the "..." character is displayed to symbolize this.


The pagination bar displays in order

  • The back button to the first page of results
  • Back to previous results page button
  • The number of the page currently displayed: the number of the page to be consulted can be directly entered here.
  • The number of the last page of results
  • The button to go to the next page of results
  • The button to go to the last page of results
  • The button for refreshing the grid content while remaining on the currently visible page
  • A field for entering a WHERE clause sql. For example "Profile_Id like 'admin%'".
  • A field for entering the number of results per page. Default is 10.
  • A text showing the results currently displayed. In the example above, lines 1 to 10 of the SQL database are displayed, out of the 430 existing lines.

 

Back to top

Datasources Explorer