A SQLLibrary data group gather data from a database using a SQL query obtained from a shared library of queries.

To create a SQLLibrary data group, first select the database connection is selected from a list of “connection” type sources registered in fAdmin.

A list of available queries will be provided from which you can select one.

fData will analyse the query and provide a list of the placeholders required by the query including those that are missing from the list of available placeholders for the data group.