FreeCAD-Reporting | SQL Like Reporting for FreeCAD Documents | Dashboard library

This file contains a simple House with some rooms and doors. Its not pretty, but it should be good enough to extract some data out of it ;). What do we see here?.
First you should install the Reporting Workbench. It is available from the addon manager directly in FreeCAD. Go to Tools > Addon Manager, scroll down select the Reporting entry and click Install. It's best to restart FreeCAD after the installation is done.
Next you should download the sample File Simple_House.FCStd and open it in FreeCAD. Now you should see something like this.
Now that the file is set up, we should fire up the report workbench and create our first report.
Now we have a empty Report object. Lets fill it with data. Lets say we want to query some informations about the rooms inside the house. Double click the Report object in the Treeview and the configuration shows up. Click Add Statement to add a new statement.
Now fill in "Rooms" into the Header field and the following statement into the Statement field
Click OK. The Task dialog closes and the report recomputes.
Expand the Report in the Treeview and you should see a Spreadsheet named Result. Double click on it to see its content.
(1) The header we added in the Report Config
(2) The column names extracted from our statement
(3) The list of objects matching our statement and the values extracted for each column
This is pretty good. But I think we can do even better. Double click the Report in the Treeview again. Click on Add Statement and add "Living Area" in the Header field. Also enable Skip empty rows after statement here and add the following in the Statement field:
Click Add Statement once again and leave the Header field empty. Enable Skip Column Names and Print Result in Bold and add the following to the Statement field:
If you look at the Result Spreadsheet again you see that there is some more data below the room list now
(1) The living area on the upper floor
(2) The living area on the ground floor
(3) And the overall living area for the entire building
This is the end of the getting started guide. Whats next?
Feel free to play around and add more Reports or more statements to the Report we created right now.
If you are familiar with the Python in FreeCAD, you might want to read the Getting started with python section
Read the SQL Reference section for an overview of the supported SQL Features
This section gives you a step by step introduction on how to get startet with the sql module in python. This file contains a simple House with some rooms and doors. Its not pretty, but it should be good enough to extract some data out of it ;).
First you should install the Reporting Workbench. It is available from the addon manager directly in FreeCAD. Go to Tools > Addon Manager, scroll down select the Reporting entry and click Install. It's best to restart FreeCAD after the installation is done.
Next you should download the sample File Simple_House.FCStd and open it in FreeCAD. Now you should see something like this.
Now that everything is set up, open the python console and import the SQL Parser and create a new instance. The parser can be used to parse as may statements as you want.
Now use the sql_parser to parse a statement. You can execute a parsed statement as often as you want.
Now execute the statement. This will give you a list of all objects in the document.