FNT Command Query Editor

FNT Command Query Editor

Prerequisite: FNT Command Basic Course

The Query Editor allows Command users to create, save and publish their own queries based on FNT Command data.
The meta-schema of the FNT Command database serves as basis for compiling the reports. It is also possible to establish database connections to database instances other than FNT Command. This allows queries to be created to data outside FNT Command or include data from systems outside FNT Command in queries.
The individual steps for compiling the report are performed with a wizard with "Forwards" and "Backwards".

Content overview:
- Creation and processing of database connections
- Use of the Meta-Viewer
- Creation and processing of individual reports based on the FNT Command meta-schema
- Use of Unions and Joins in a query
- Creation of a "Published" report and of a "Jobs" report
- Report export/import functionality

Course duration: 1 day

Welcome to FNT Academy