BulletinBoardMessages query

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters on FBO location. Single or multiple FBO locations can be selected.

YES

Start date / Before date

Filters to show Bulletin board message’s between the start and end date based upon either the Posted date or Last modified date.

YES

Data provider settings

The following ‘Data provider settings’ can be set in Reports (Administration) for the query, if not specified the default applies. All settings must be separated by a semi-colon ';'.

Setting

Type

Default

Description

Setting

Type

Default

Description

IncludeHandlingOrders

Boolean

False

Include messages that are attached to an order only.

IncludeContacts

Boolean

True

Include messages that are attached to a contact only.

IncludeRegistrations

Boolean

True

Include messages that are attached to a registration only.

IncludeAircraftTypes

Boolean

True

Include messages that are attached to an aircraft type only.

IncludeStations

Boolean

True

Include messages that are attached to a station only.

IncludeUnassigned

Boolean

True

Include messages that are unassigned - this includes OPS Bulletin Board messages and Calendar messages.

OnlyExpiryDate

Boolean

False

By default messages both with and without an Expiry will show. When set to 'True', this will show messages that contain an expiry date. If the Expiry date field is blank these massages will not be shown.

OnlyReviewDate

Boolean

False

By default messages both with and without a Review date will show. When set to 'True' only messages that contain a Review date will be shown

IncludeExpired

Boolean

True

By default, messages that have expired, will be included

IncludeMerged

Boolean

True

By default, messages that have been automatically generated through the merge of two contacts, will be included

C# filter expressions

To show/hide Expired or past review date messages, and to exclude merged contact messages appearing on the bulletin board
1 2 3 row["Is expired"].ToString().ToLower() == "true" || row["Is review date past due"].ToString().ToLower() == "true" || row["Message text"].ToString().ToLower().Contains("was merged into")
To show messages that have an expiry or review date
1 2 row["Expiration date"] != null || row["Review date"] != null

Columns

Name

Description

Example

Aircraft type short name

Aircraft type’s ‘Shortname’ if the message applies to an aircraft type only. See Add Aircraft Type - add/edit screen.

TBM900

AircraftTypeId

The Aircraft type’s unique ID in GUID format. If the message applies to an aircraft type only.

490f45c7-21e4-4edb-a97e-568d156ebebb

Applies to

Where the message is applied to, possible options: Contact, AircraftRegistration, AircraftType, Station, HandlingOrder, Unassigned

Contact

Applies to All Fbo locations in administration

Indicates if the message applies to all FBO locations in an Administration

TRUE

Applies to All Fbo locations in administration name

Displays the FBO locations in an Administration.

 

Applies to Fbo location group Id

The FBO location groups unique ID in GUID format. If the message applies to specific FBO location group only.

723345c7-2234-4e2b-a92a-568aasdabexs

Applies to Fbo location group is active

Indicates if the FBO location group is active and can be chosen for ‘Visible to FBO’. See Bulletin Board FBO Location Group (Administration) and How to restrict the visibility of a Bulletin board message to a FBO location group.

TRUE

Applies to Fbo location group name

Displays the FBO location group that can be chosen for ‘Visible to FBO’. See Bulletin Board FBO Location Group (Administration) and How to restrict the visibility of a Bulletin board message to a FBO location group.

USA

Applies to Fbo location Id

The FBO location’s unique ID in GUID format. If the message applies to a single FBO.

4e72f72c-b4bb-479f-b376-cb232c9947b4

Applies to Fbo location short name

The FBO location’s ‘Short name’, for this message. Note: For messages that apply for multiple locations, individual rows will show.

EHAM

Attachment created by

Displays the 'User’s display name' for the user who first created and attached the attachment.

Adam Marriott

Attachment created date

Message attachment's created date/time in UTC.

06/02/2019 09:56

Attachment description

Message attachment's description defined on upload.

VAT EXEMPTION

Attachment download Url

Direct link to download the attachment directly from FBO One. Note: Login to FBO One is required.

https://*****.fbo.one//DownloadBulletinboardAttachment.ashx?bulletinboardattachmentid=7a90ba49-6d66-4e42-bd0a-91ed0e195bdf&writeoption=inline

Attachment file name

Message attachment’s file name, with file type.

vatexemption2020.pdf

Attachment to invoice

Indicates if the message attachment is marked true for ‘To be attached to invoice’, as True/False.

TRUE

BulletinBoardMessageId

The bulletin board message’s unique ID in GUID format.

68f4b060-3ad2-48fc-b51d-b06dc1fb4347

Category name

Message’s category name. See How to add a new Bulletin Board category

Alert

Category type

Message category type. Possible options are:

  • Calendar items: are visible in the calendar of the OPS Order Grid, OPS Browse- and FUEL screen

  • OPS Bulletin Board: are visible in the Bulletin Board of the OPS browse and FUEL screen

  • Plan board messages: are visible in the order grid of the OPS browse screen (if column is added)

  • Regular messages: are visible in the left side bar of the order screen

  • Finance messages: are visible in the finance Bulletin Board tab of the order screen

OPS Bulletin Board

Contact number

Contact’s ‘Contact number' if the message applies to a contact only. See Add Organization - add/edit screen.

100418

Contact short name

Contact’s ‘Short name' if the message applies to a contact only. See Add Organization - add/edit screen.

Eagle European

ContactId

The contact's unique ID in GUID format. If the message applies to a contact only.

f0bc034d-25eb-489a-ad7c-1550ae3bb2dd

Expiration date

Message’s expiry date in UTC, if added by the user. See ‘Expiry date' field in message. Also see How to set an expiry or review date for a bulletin board message for more information.

28-May-21

Handling orderKey

The primary order’s Order key if the message applies to an order only.

FBO-12345

Is expired

Indicates if the message’s expiry date is now in the past, see ‘Expiry date' field in message. Also see How to set an expiry or review date for a bulletin board message for more information.

FALSE

Is new

Indicates if the message is new and has not been modified, as True/False.

TRUE

Is review date past due

Indicates if the message’s review date is now in the past, see ‘Review date' field in message. Also see How to set an expiry or review date for a bulletin board message for more information.

TRUE

Last modified by primary user default FboLocation short name

The 'Default FBO location' short name for the primary user who last created the message.

AMS

Last modified by primary user full name

The full name for the primary user name for the user last modified the message. This may be a group user name.

Adam Marriott

Last modified by primary username

The primary user name for the user who last modified the message. This may be a group user name.

AMarriott

Last modified by secondary user default FboLocation short name

The 'Default FBO location' short name for the secondary user who last created the message.

AMS

Last modified by secondary user full name

The full name for the secondary user name for the user last modified the message.

Adam Marriott

Last modified by secondary username

The secondary user name for the user who last modified the message. This may be a member of a group user.

AMarriott

Last modified date UTC

Message’s last modified date/time in UTC.

21/05/2020 12:36

Message calendar time UTC

Calendar message’s date/time in UTC. See Calendar / Bulletin board (Ops)

08/07/2020 11:51

Message priority

The message’s set priority.

Important

Message status

The message’s current status based upon the current workflow. See How to edit Bulletin board / Calendar task states

Calendar | Completed

Message text

The message text for the bulletin board message.

FUEL ON HANDLING BILL**

Posted by primary user default FboLocation short name

The 'Default FBO location' short name for the primary user who created the message.

AMS

Posted by primary user full name

The full name for the primary user name for the user who created the message. This may be a group user name.

Adam Marriott

Posted by primary username

The primary user name for the user who created the message. This may be a group user name.

AMarriott

Posted by secondary user default FboLocation short name

The 'Default FBO location' short name for the secondary user who created the message.

AMS

Posted by secondary user full name

The full name for the secondary user name for the user who created the message.

Adam Marriott

Posted by secondary username

The secondary user name for the user who last created the message.. This may be a member of a group user.

AMarriott

Posted date UTC

Message’s posted/created date/time in UTC.

01/07/2020 08:23

Registration code

Registration code if the message applies to an aircraft registration only.

P4HEI

RegistrationId

The aircraft registration’s unique ID in GUID format. If the message applies to an aircraft registration only.

1d36eb8b-8809-45b8-91cc-06830505bd4e

Restricted to Fbo location Id

The FBO location is restricted to unique ID in GUID format the message is restricted to.

4e72f72c-b4bb-479f-b376-cb232c9947b4

Restricted to Fbo location short name

Restricted to FBO location ‘Short name’. Possible options are:

  • FBO location short name (if restricted to single FBO)

  • Restricted to FBO location group' (see 'Applies to Fbo location group name’ column)

  • Restricted to all FBO locations in administration’ (see ‘Applies to All Fbo locations in administration name’ column)

  • All FBO locations’ (if unrestricted to ‘All FBO locations’)

AMS

Review date

Message’s review date in UTC, if added by the user. See ‘Review date' field in message. Also see How to set an expiry or review date for a bulletin board message for more information.

12-May-21

Show message after expiry

Indicates if the message is shown to the user after the expiry date has passed. See ‘Show message after expiry' field in message. Also see How to set an expiry or review date for a bulletin board message for more information.

TRUE

Station short name

Station’s ‘Station name’ (the ICAO code and IATA code), if the message applies to a station only.

EDLW (DTM)

StationId

The station’s unique ID in GUID format. If the message applies to a station only.

b7e0c188-428e-455f-b16f-323a27c0f1e7

View bulletin board message Url

Direct link to the bulletin board location in FBO One. Note: Login to FBO One is required.

https://*****.fbo.one/editmessage.aspx?msgid=01967654-93e2-4ba6-8f44-acd5f6c8decf