MySQL Data Source


Apps - Datasource - MySQL icon.png This type of data source belongs to the Standard category in the data source library. It is used to retrieve data by running a query in a MySQL database.

Notes

   Open url.png  see General remarks on data sources

  • You must first define the connector for connecting to the MySQL server.

List of properties

Content

Alia/Connector: Connector used to retrieve the connection settings to the MySQL server. Note: If the connector you want is not available in the drop-down list, click EVApps - GUI - Connector icon.png to create it.

Database: Used to display a list of the databases available on the MySQL server that users are authorized to access.

SQL Query: SQL query run on the database. It can query one or more tables and return the results. You can enter the query directly in the field or click Apps - Edit icon.png to open the text editor. Note: The query must end with a semi-colon (;).
Example documentation icon EN.png 

SELECT name,surname,status,
       Date_format(date, '%d-%m-%Y') AS dateen
FROM   famille_tbl;  
Preview

Configure Field Types: Used to display a preview of the structure and data from the data source via a data editor. 

  • The button Apps - datasources Properties - Preview button.png displayed below the property indicates the number of extracted rows (up to a limit of 15) and columns. Click on it to open the editor. Open url.png See the Description.
  • The button will display No data available as long as you have not selected any of the mandatory elements of the data source.
  • In edit mode, only the first 15 data source records are displayed.
  • In execute mode, all of the data source records are displayed.
  • Data in static data sources comes from the last file upload.
  • Data in dynamic data sources is updated when you open the app in edit mode.
SelectFirstRowAsCurrentRecord

Select First Row As Current Record: Used to indicate if the first record of the data source, when displayed in widgets, is selected by default (box is checked) or if no record is selected by default (box is not checked). 

AutoRefresh

Auto Refresh (Note: Only for dynamic data sources): Used to indicate the automatic refreshment interval for a dynamic data source. The frequency is expressed in hours/minutes. The updating of data is done in execute mode or edit mode, each time the app is run and each time the page is redisplayed.

    Best Practice icon.png

  • Because the updating of data requires additional activity on the EasyVista Service Apps platform, you should define an automatic refreshment interval only if the app is required to constantly display  real-time data for long periods of time on a screen.
             Example documentation icon EN.png  Dashboards
  • You should not define an automatic refreshment interval if the app is only used for displaying a snapshot of data for short periods of time.
             Example documentation icon EN.png  A portal for consulting catalogs
NoDataMessage

No Data Message: Message displayed when no data is returned in the data source. Enter the code directly in the field or click Apps - Edit Html icon.png to open the text editor

Some MySQL commands

  • To view the list of tables
SHOW TABLES;  
  • To view the structure of the MyTable table
SHOW COLUMNS FROM mytable;  
  • To view the contents of the MyTable table
SELECT *
FROM   mytable
WHERE  title LIKE '%Happy';  
Tags:
Last modified by Unknown User on 2017/09/01 16:45
Created by Administrator XWiki on 2014/11/12 20:37

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018