I love your Query Builder for beginners, which I have stumbled upon on a reddit help page.
What is difficult to understand is how to query for missing properties or properties with empty values (as in !Property). This is also missing in the Query Builder. Maybe an idea for an upgrade for the next version?
Also, the grouping did not work out for me (it listed only the groups, but not the entries).
After grouping, you need to prepend a 'rows.' to all fields you want to have as output and all data commands that come after GROUP BY. The Query Builder does take care of that for you.
I love your Query Builder for beginners, which I have stumbled upon on a reddit help page.
What is difficult to understand is how to query for missing properties or properties with empty values (as in
!Property). This is also missing in the Query Builder. Maybe an idea for an upgrade for the next version?Also, the grouping did not work out for me (it listed only the groups, but not the entries).
After grouping, you need to prepend a 'rows.' to all fields you want to have as output and all data commands that come after GROUP BY. The Query Builder does take care of that for you.