QueryGramplet - Revision history

Romjerome at 10:08, 3 March 2012

2012-03-03T10:08:00Z

Romjerome at 09:58, 3 March 2012

2012-03-03T09:58:05Z

Daleathan at 06:05, 28 October 2011

2011-10-28T06:05:55Z

Daleathan at 06:05, 28 October 2011

2011-10-28T06:05:11Z

Dsblank at 12:20, 15 March 2010

2010-03-15T12:20:38Z

Dsblank: 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...

2010-03-15T11:59:46Z

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...

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 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 given_name, surname from people;

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

← Older revision		Revision as of 10:08, 3 March 2012
Line 33:		Line 33:
	[[Category:Developers/General]]		[[Category:Developers/General]]
	[[Category:Reports]]		[[Category:Reports]]
		+	[[Category:Gramplets]]

← Older revision		Revision as of 09:58, 3 March 2012
Line 32:		Line 32:
	[[Category:Plugins]]		[[Category:Plugins]]
	[[Category:Developers/General]]		[[Category:Developers/General]]
		+	[[Category:Reports]]

@@ Line 1: / Line 1: @@
 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:
@@ Line 18: / Line 19: @@
   $ 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;

@@ Line 1: / Line 1: @@
 The Query Gramplet takes SQL-like queries and produces a Quick View.
-[[Image:QueryGramplet.jpg]]
+[[Image:QueryGramplet.jpg|thumb|300px|left]]
 SQL-like:
@@ Line 21: / Line 18: @@
   $ select * from people where surname.startswith("Smith")
-[[Image:QuerySmith.png]]
+[[Image:QuerySmith.png|thumb|left|300px]]
   $ select given_name, surname from people;
@@ Line 30: / Line 27: @@
   $ select * from families;

@@ Line 18: / Line 18: @@
 Examples:
   $ select given_name, surname from people;
-  $ select * from people where surname.startswith("Smith")
+  $ select * from sources;