furti wrote: ↑
Mon Feb 17, 2020 6:01 am
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
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
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.