Difference between revisions of "Addon:QueryGramplet"

From Gramps
Jump to: navigation, search
m
(2 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|thumb|300px|left]]
+
[[Image:QueryGramplet.jpg|thumb|400px|left]]
 +
{{-}}
  
 
SQL-like:
 
SQL-like:
Line 18: Line 19:
 
  $ select * from people where surname.startswith("Smith")
 
  $ select * from people where surname.startswith("Smith")
  
[[Image:QuerySmith.png|thumb|left|300px]]
+
[[Image:QuerySmith.png|thumb|left|400px]]
 +
{{-}}
  
 
  $ select given_name, surname from people;
 
  $ select given_name, surname from people;
Line 30: Line 32:
 
[[Category:Plugins]]
 
[[Category:Plugins]]
 
[[Category:Developers/General]]
 
[[Category:Developers/General]]
 +
[[Category:Reports]]
 +
[[Category:Gramplets]]

Revision as of 10:08, 3 March 2012

The Query Gramplet takes SQL-like queries and produces a Quick View.

QueryGramplet.jpg


SQL-like:

select FIELDS from TABLE where PYTHON-BOOLEAN-EXPRESSION;

TABLES: FIELDS:

  1. people: given_name, surname, suffix, title, birth_date, death_date, gender, birth_place, death_place, change, marker
  2. families:
  3. sources:
  4. events:

Examples:

$ select * from people where surname.startswith("Smith")
QuerySmith.png


$ select given_name, surname from people;

$ select * from sources;
$ select * from events;
$ select * from families;