QueryGramplet

From Gramps
Revision as of 03:08, 3 March 2012 by Romjerome (Talk | contribs)

Jump to: navigation, search

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;