Difference between revisions of "Addon:QueryGramplet"

From Gramps
Jump to: navigation, search
(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 people where surname.startswith("Smith")
+
  $ 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.

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;