Difference between revisions of "QueryGramplet"
From Gramps
m |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
The Query Gramplet takes SQL-like queries and produces a Quick View. | The Query Gramplet takes SQL-like queries and produces a Quick View. | ||
| − | [[Image:QueryGramplet.jpg]] | + | [[Image:QueryGramplet.jpg|thumb|400px|left]] |
| + | {{-}} | ||
SQL-like: | SQL-like: | ||
| Line 21: | Line 19: | ||
$ select * from people where surname.startswith("Smith") | $ select * from people where surname.startswith("Smith") | ||
| − | [[Image:QuerySmith.png]] | + | [[Image:QuerySmith.png|thumb|left|400px]] |
| + | {{-}} | ||
$ select given_name, surname from people; | $ select given_name, surname from people; | ||
| Line 30: | Line 29: | ||
$ select * from families; | $ select * from families; | ||
| + | |||
| + | [[Category:Plugins]] | ||
| + | [[Category:Developers/General]] | ||
| + | [[Category:Reports]] | ||
| + | [[Category:Gramplets]] | ||
Latest revision as of 03: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;
