Extraction (GET statement)

  • Published on Mar 26, 2026
  • 1 minute(s) read
  • Axel Palmaers
 Prev Next
This content is currently unavailable in English. You are viewing the default (French) version.

GET statement

Using BQL you can export exactly the data that you need from one or multiple models as a single IFC file.

When exporting multiple models to IFC, all the source models must be of the same IFC schema

Examples



GET     property.*.IsExternal WHERE     type = IFCWALL


GET     property.Pset_WallCommon.* WHERE     type = IFCWALL


GET     property.*,     classification WHERE     type = IFCSPACE

Extracted values

By default only QIDs are extracted. By providing a GET statement you can define additional data fields. Below is an example that basically fetches all known data of an object.



GET         qid,         niceType,         typeObject.attribute.*,         typeObject.property.*,         typeObject.niceType,         model.*,         niceType,         calculated.*,         classification.*,         attribute.*,         quantity.*,         property.*,         layer.*,         material.*,         system.attribute.Name,         port.niceType,         port.qid,         port.attribute.Name,         port.attribute.FlowDirection,         port.portConnectedTo.qid,         port.portConnectedTo.attribute.Name,         port.portConnectedTo.niceType,         port.portConnectedTo.portContainedIn.qid,         port.portConnectedTo.portContainedIn.attribute.Name,         port.portConnectedTo.portContainedIn.niceType,         portContainedIn.qid,         portContainedIn.attribute.Name,         portContainedIn.niceType,         spaceBoundary.qid,         spaceBoundary.attribute.Name,         spaceBoundary.relatedBuildingElement.qid,         spaceBoundary.relatedBuildingElement.niceType,         space.qid,         space.attribute.Name,         relatedBuildingElement.qid,         relatedBuildingElement.niceType,         relatedBuildingElement.attribute.Name,         decomposition,         zone.attribute.Name WHERE     qid = [YOUR QID] (or use IN (qid1, qid2, qid3...)