TIL two things about union queries in Query Builder I thought I'd share...
Query Builder is not the worst tool ever but if they only documented the limitations, it would save me hours of time. I've been working with union queries recently to get around some of the limitations (10.2) of the UI when dealing with queries across the 3 main data types (Parts, Docs and CAD Docs). For all those who do not know, do make a union, you need to create your queries separately in Query Builder and export them to a .qml file. This is an XML file that contains the query definition. You will see some header stuff but your query will be wrapped in a "<Statement>" clause. Create a new qml file with this template:
These messages scare the crap out of me b/c i fear DB integrity. It was as simple change I made to turn of bypassing of access rights: <qml bypassAccessControl="false". I wanted to make sure results were only what the person running it could see but this cause the error I saw. I set it back to true and it was fine. Phew!
2. I also saw this message on import when I ran my union query: