Difference between revisions of "Addon:QueryGramplet"
(New page: Category:Plugins Category:Developers/General The Query Gramplet takes SQL-like queries and produces a Quick View. Image:QueryGramplet.jpg SQL-like: select FIELDS from TABL...) |
|||
Line 18: | Line 18: | ||
Examples: | Examples: | ||
+ | |||
+ | $ select * from people where surname.startswith("Smith") | ||
+ | |||
+ | [[Image:QuerySmith.png]] | ||
$ select given_name, surname from people; | $ select given_name, surname from people; | ||
− | $ select * from | + | $ select * from sources; |
+ | |||
+ | $ select * from events; | ||
+ | |||
+ | $ select * from families; |
Revision as of 12:20, 15 March 2010
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;