Difference between revisions of "Addon:QueryGramplet"
m |
m |
||
Line 33: | Line 33: | ||
[[Category:Developers/General]] | [[Category:Developers/General]] | ||
[[Category:Reports]] | [[Category:Reports]] | ||
+ | [[Category:Gramplets]] |
Revision as of 10:08, 3 March 2012
The Query Gramplet takes SQL-like queries and produces a Quick View.
SQL-like:
select FIELDS from TABLE where PYTHON-BOOLEAN-EXPRESSION;
TABLES: FIELDS:
- people: given_name, surname, suffix, title, birth_date, death_date, gender, birth_place, death_place, change, marker
- families:
- sources:
- events:
Examples:
$ select * from people where surname.startswith("Smith")
$ select given_name, surname from people; $ select * from sources;
$ select * from events;
$ select * from families;