Datasources

5min

Datasources are sets of data used in 
﻿ solutions and are used to reference data from the various Data Providers﻿. 
Types
There are three types of datasources available in 
﻿.
SQLite - Using the SQLite datasource provides the ability to write SQL queries to get data from 
﻿ and local data providers. For code examples and snippets, see sqlite﻿.
Static - Static lists are typically used when data needs to be accessed but hardly ever changed. Static Data is helpful because it can be created quickly inside the 
﻿, and there is no need to specify any database connections or set up tables. The amount of records that can be created in Static data is unlimited. Static data is commonly used to bind data to the UI components. For code examples and snippets, see Static﻿.
System - The system datasource is used to get a list of icons for 
﻿ components. For code examples and snippets, see system﻿.
Where and how to use datasources
In a Global file
Datasources are defined once and are available throughout your solution to be reused in multiple 
﻿s. Adding a global datasource improves performance as the data is retrieved once rather than multiple times. 
Global datasource
﻿
Open your solution in 
﻿ and navigate to the datasources folder of your solution.
 Create a new file called <your_datasource_name>.jigx.
Invoke IntelliSense (ctrl+space) for the list of available datasources.
Select the datasource you want to use and configure the properties with values. When choosing 
﻿or SQL data, you can write SQL queries to return the data you want to use in the solution.
Next, open the 
﻿s where you want to use the data, use expressions with the datasource option to reference the global datasource file, for example, [email protected].
Local within a 
﻿﻿
The data sets are defined in the datasources inside the individual 
﻿ generally under the datasources: property. Use datasources locally if you only need the data in that specific 
﻿.
Local datasource
﻿
Open your solution in 
﻿ and navigate to the 
﻿.
 Under the datasources: property, replaces the mydata: property with a unique name for the data set. 
Invoke IntelliSense (ctrl+space) next to the mydata: property for the list of available datasources.
Select the datasource you want to use and configure the properties with values. When choosing 
﻿or SQL data, you can write SQL queries to return the data you want to use in the 
﻿. Tip: only return the specific data you need in the datasource.
The data is now available to use in that 
﻿ by using expressions with the datasource option to reference the local datasource using the unique name you gave it, for example, [email protected].
See Also
﻿static﻿ datasource examples
﻿sqlite﻿ datasource examples
﻿system﻿﻿
﻿File handling﻿﻿
﻿