SQL Reporting Workbench for FreeCAD

[mario52]

hi

- removed the mm and make the fields number
- filtered Length,Width,Height for 16mm entries, because these are the furniture plates. (40mm are the sidewalls..) and gave them a 4. filter attribute
- for all these furniture entries I simply calculated the volume and devided by 16 to get the total plate area. done

try also this macro, you split like you want Macro_FCTreeView but FreeCAD version 0.17 no yet upgraded

mario

[dcapeletti]

Columns
Columns is a comma separated list of properties you want in the result for each object.

* is a special property that returns the whole object instead of a single property. This might be useful when you want to perform certain operations on some objects in python. You can select them with a select statement, and process them afterwards.

When you use a function (Sum, Min, Max, Count) here, only a single row will be returned with the function applied to each object. You can not mix single Properties and functions. But it should be possible to use multiple functions in a single select statement.

Hello, if I add a new property to the object called Provider, can I access it by means of an sql instruction? How can I do it?

Code: Select all

select Provider from document where Name = 'Box'
select Base_Provider from document where Name = 'Box'

None of the above instructions work.

Thanks

[furti]

You mean the property is called "Provider"?
If so, the first query should work.

What is the problem with the query?

[dcapeletti]

You mean the property is called "Provider"?
If so, the first query should work.

What is the problem with the query?

It's a dynamic property that I add to the object myself.
Attached is a sample video https://www.youtube.com/watch?v=g3Bs_jz ... e=youtu.be

The first query does not throw an error but no result is shown, in the second query, the next error is thrown.

Code: Select all

ERROR:root:
Traceback (most recent call last):
  File "/home/dcapeletti/.FreeCAD/Mod/Reporting/report.py", line 352, in __init__
    self.statement = SQL_PARSER.parse(plainTextStatement)
  File "/home/dcapeletti/.FreeCAD/Mod/Reporting/sql/sql_parser.py", line 1149, in parse
    sqlStatement = sql_grammar.parse(sqlString, actions=ParserActions())
  File "/home/dcapeletti/.FreeCAD/Mod/Reporting/sql/sql_grammar.py", line 1958, in parse
    return parser.parse()
  File "/home/dcapeletti/.FreeCAD/Mod/Reporting/sql/sql_grammar.py", line 1942, in parse
    raise ParseError(format_error(self._input, self._failure, self._expected))
  File "<string>", line None
sql.sql_grammar.ParseError: Line 1: expected [a-zA-Z0-9\.], [ \t\r\n], [ \t\r\n], ","
Select Label, Base_Provider from document where Name = 'Box'
                  ^

But as shown in the spreadsheet, through Box.Base_Provider I can recover the data without any problem.

Greetings

[furti]

Now I can see what is wrong here. The character _ is not allowed in Property names right now. I created a Issue for this. https://github.com/furti/FreeCAD-Reporting/issues/27

Is it possible that you rename the Property to something Alphanumeric like "BaseProvider" instead of "Base_Provider"?

[dcapeletti]

Now I can see what is wrong here. The character _ is not allowed in Property names right now. I created a Issue for this. https://github.com/furti/FreeCAD-Reporting/issues/27

Is it possible that you rename the Property to something Alphanumeric like "BaseProvider" instead of "Base_Provider"?

Hello, the query works correctly if I create the property but do not add it to any group, as shown in the image. That way if you can access it directly with Provider, but if I add it to a group, FreeCAD adds the group name separated by _.

[dcapeletti]

I think this project is very powerful when it comes to creating reports and not only that, but using object manipulation instructions via the freecad API using SQL directly.

[fredericleuba]

Hello,

Great workbench Thanks.

But it seems that something is missing somehow.
It would be absolutely great to add the following (illustration with picture bellow).

I have a query that gets all objects and get a property from them.
It finds original objets and their links.

But I have links to more complex structures than simple object.
In particular, links to Assembly3 organisation, which itself contains a subtree of groups and objects.
I would expect the SQL-like query to also follow these Assembly3 links, and scan deeper inside.
Indeed, I would expect the query to return 10 links to the part "80x40L-4N 100".

I hope you understand.
I may help, as I'm a developer. But my free time is super limited.

[stefano1]

Hi!
I've just tried this WB..exactly what I was looking for but..

this works:
Select Label,Length from document where IfcType = 'Pipe Segment' and Description = 'whatever' and Diameter = 16;

this, doesn't:
Select Label,Length from document where IfcType = 'Pipe Segment' and Description = 'whatever' and Diameter = 1.6; #(or 1,6)

File "/home/stefano/.local/share/FreeCAD/Mod/Reporting/sql/sql_grammar.py", line 1990, in parse
raise ParseError(format_error(self._input, self._failure, self._expected))
sql.sql_grammar.ParseError: Line 1: expected [0-9], [ \t\r\n], [ \t\r\n], ";"
Select Label,Length from document where IfcType = 'Pipe Segment' and Description = 'multistrato' and Diameter = 1.6
^

- I guess Diameter is defined as decimal so what am I doing wrong? I'm using the weekly build 35759.
- how can I be aware of the consistency, unit-wise?

cheers!
stefano