Settings query

The Settings query shows the general settings and the FBO location-specific settings.

If the FBO location field is empty in the report, it’s the general setting only, otherwise, it’s an FBO location-specific setting.

The Code field is the name of the setting.
The Value field is what is filled in, for example, an address or email.
The Type field refers to the part of FBO One where the setting has effect, either the application itself, the reporting or the emailing.

You can download the Settings using the default ‘Settings’ report.

Filters

There are no required filters for this query.

There are no data provider settings for this query.

Column	Description	Example
Code	The name of the setting.	AllowLiveUpdates
FBO location	FBO location where the FBO location setting is set. If blank, the row is the global default setting for locations without specific FBO location setting set.	Harrods Aviation - Stansted
FBO location ID	The FBO location’s unique ID in GUID format.	4e72f72c-b4bb-479f-b376-cb232c9947b4
FBO setting ID	The FBO location settings’ unique ID in GUID format.	585a299b-a1ca-4216-9a57-1757e507de4e
Setting ID	The general settings' unique ID in GUID format. Note: This will be blank if setting is an FBO location setting. See ‘FBO setting ID’ column.	96e441c1-b2ef-452b-867d-5591409b4671
QRCode	Allows generating a QR code using data from other columns, see How to add a QR code to a report. Example shown: Settings: ShowBarCodeOnEveryRow=true; MultipleValuesSeparator=" \| " Columns: Code, Value, FBO location, Type
Type	The type of setting, and where the setting has an effect. Application = Application Settings (Administration) Email = Email Message Settings (Administration) Reports = Report Settings (Settings)	Application
Value	The entered value for the setting.	True