Skip to main content

Querying your data

This page is for you if you extract or correct data in bulk

Looking for something else? See Where to start.

Availability

This page concerns organisations running GraphlakeThe Stonal interface for viewing and managing plans: it is what the Plans tab displays..

What it is for​

The Query tool lets you view and export all the information held in the platform, and update your data in bulk to improve your portfolio.

It is the free-form query tool: you define a scope with filters, you choose the information you are interested in, then you export or you correct.

Before you start​

This module is generally open to Graphlake organisations. If you do not have access to it and you need it, ask your internal contactThe person in your organisation who knows the configuration chosen for Stonal: permissions, access to a module, contents of a report..

The screen explained​

The list of saved queries

The home page lists your saved queries, with their description and the date they were last changed. The query's author is also shown, for queries created since September 2026. From the table you can:

  • open a query, adjust its settings and see its results;
  • create a new query;
  • download the results as CSV;
  • edit the name and description, or delete — depending on your permissions.
Saved queries are shared

A query you save becomes visible to every user in your organisation, not just to you. That is what makes it worth saving — a useful query benefits everyone — but keep it in mind when naming it.

Step by step​

1. Define the scope with filters​

This first step is where you narrow things down to what interests you: a few properties rather than the whole portfolio, one specific equipment type, the dwellings built before a given date… Everything you see afterwards covers that scope, and only that scope.

A filter has four parts: a component (the type of item: property, building, unit, equipment…), a property, an operator (greater than, less than, equal to…) and a value.

You combine them with AND or OR, including across several components.

  1. "Add a component" to choose the type of item.
  2. "Add a filter" to set a condition. Repeat to stack them.

A concrete example: equipment in "poor condition" or "dangerous condition", in buildings acquired before 2020 with an EPC rating of C.

You can select several sub-types of the same component in a single query — equipment, level, graphical building, space, wall, zone. This lets you target, for instance, sanitary fittings and lighting equipment in one go. The filters then apply to the whole selection.

2. Choose the columns​

Some information is already selected: whatever you used to narrow down your scope at the previous step.

You can add anything else you want. The overall condition of your equipment, its power rating, the construction date of a building: select that information and it appears as extra columns in your results.

To do so:

ActionEffect
Add a columnAdd properties of a component
Add a componentAdd new columns
CrossRemove a property
BinRemove every property of a component
PreviewSee a preview at any time

You can also drag the components to change their order.

Filters and columns are independent

Adding or removing a column does not change the filtered scope. You can filter on a property without showing it, and the other way round.

At any point, "Preview" shows you a sample of the result without leaving the settings. It is the habit worth forming before running the query: you check you have the right scope and the right information, rather than finding out across thousands of rows.

Show the validity period of a value​

A value is not always valid forever: an energy performance certificate (DPE) expires, a unit leaves the portfolio. On a property, a building or a piece of equipment, you can add the effective date and expiration date columns, like any other column. They show from when and until when the value is valid.

For a property, click "Add effective date and expiration date" when you add it as a column.

These columns appear in the preview, in the results and in exports. They are ignored if you re-import the file. A value with no end date shows the ∞ symbol.

For instance, to spot the DPEs due for renewal, add the expiration date column on the DPE property: you read the deadlines directly, without setting a filter.

Filtering on these dates

By default, the query tool only keeps what is valid today. When you filter on these dates yourself, that default filter no longer applies on top of yours.

To anticipate units leaving the portfolio (units sold, leases ending), you can therefore filter on an upcoming expiration date, for example within three months. You get the units concerned, including those that are hidden by default once expired.

This filter applies to the component, not yet to a specific property.

3. Read, save and export the results​

The next page shows all the results of your query: one row per item found, one column per piece of information selected.

A query's results page

Each column matches a piece of information you chose at the previous step. Its name is prefixed by the component it belongs to:

What you are afterThe column name
The property's nameProperty – Name
A boiler's conditionBoilers – Condition

That prefix is what tells you what each value attaches to, even when two components carry information of the same name.

Three actions are available on this page:

  • Save the query — it then becomes available to your whole organisation, so it is easily reusable and shareable. You will not have to rebuild it next time.
  • Export — the button offers three choices. "Export (CSV)" gets every result in a file, with the same columns as on screen. It is the format that opens in Excel and any spreadsheet: enough to rework the data, pass it on, or compare it with another tool's. "Export for modification (CSV)" and "Export for creation (CSV)" prepare a file to re-import (see step 5). The exported file is named after the query.
  • Edit the query — you go back to the settings, filters and columns intact, to adjust and run it again.

4. Multiple actions​

The query tool is not only for reading your data: you can also change or fill in the information recorded, across as many rows as you like, without leaving the results page. It is the quickest way to correct a missing or wrong value on a large number of items at once.

If your permissions allow it, this happens straight from the results.

  1. Select the rows: the pencil on a row for a single correction, the box at the top left for the whole table, or the boxes row by row. A bar appears at the bottom of the screen reminding you how many results are selected. Shift + click on a box ticks every row between the last one ticked and this one.
  2. Click "Edit data". A panel opens on the right, in two steps: first choose the component type concerned, then edit the data.

The bulk edit panel, in two steps

The panel reminds you how many rows are selected, and offers one field per property shown as a column — with the right input type, a date picker for a date for instance.

Only the columns shown can be edited

The edit window only offers the columns present in your table. If you want to correct a property, add it as a column first.

Bulk editing can take several minutes. A notification at the top right keeps you informed of its progress.

5. Modify or create components by CSV import​

When there are many corrections, or they differ from one row to the next, it is often easier to make them in a spreadsheet, then re-import the file. From the results page, the "Import data" button offers two types of import, still in beta.

Modify or enrich existing components​

  1. Add the columns to correct to your query. To change the type of components, also add the Code meta. column.
  2. Export the query with "Export for modification (CSV)".
  3. Correct the values in the file, with Excel or another spreadsheet.
  4. Click "Import data", choose "Modify or enrich existing components", then drop your file.

To change the type of one or more components, replace their code in the Code meta. column. For example, to change bathtubs into showers, replace KA0211 with KA0111. The end-of-export message contains a link to the meta-code library, to find the right code. The same file can both change types and correct properties.

Changing a component's type is not trivial

Properties common to both types are kept. Those that only exist on the old type are deleted, those of the new type are added empty.

Never change the Stonal identifier column: it is used to find each component, and the import would be invalid.

Create new components​

Build a query that returns the location of the future components (site, building, level, room), then export it with "Export for creation (CSV)". Fill in the meta code of each new component, then import the file with "Import data" and "Create new components". For now, this creation covers equipment, and equipment created this way does not appear on plans.

An import can take several minutes. The import history lists the imports in progress and finished, with the detail of the rows processed and in error.

Importing data depends on the permissions you have been given: you may not have access to it. If you need it, ask your internal contact.

6. Delete components in bulk​

An import or a manual entry has created components that should not be there: wrong type, duplicates, units integrated by mistake. Rather than deleting them one by one, you find them with a query and delete them in one go, from the results.

  1. Select the rows, as you would for an edit.
  2. In the bar at the bottom of the screen, click "Delete".
  3. If your selection mixes several component types, choose the one to delete.
  4. A confirmation screen lists the components concerned and everything deleted along with them (sub-equipment, associated plans). Read it through, then confirm.
Deletion is permanent

Deleted components cannot be restored, and neither can what is deleted along with them. Take the time to read the confirmation screen before you confirm.

This action depends on a dedicated permission, "Asset deletion", which no group has by default: you may not have access to it. If you need it, ask your internal contact.

Good to know​

Changes, from the results or by import, only apply to the portfolio you have permissions on.

Automatically calculated areas (floor area, SHAB, SDP) are indicative and do not replace a certified measurement.

See also​