Addon:QueryGramplet - Revision history

Patsyblefebre at 06:31, 1 November 2025

2025-11-01T06:31:09Z

Gioto: /* Issues */

2025-08-26T01:26:37Z

‎Issues

CallMeDave: /* Examples */

2025-07-04T05:24:29Z

‎Examples

CallMeDave: /* Issues */

2025-07-04T05:23:34Z

‎Issues

CallMeDave at 05:18, 4 July 2025

2025-07-04T05:18:01Z

CallMeDave: /* See also: */

2025-07-04T05:16:27Z

‎See also:

CallMeDave at 05:08, 4 July 2025

2025-07-04T05:08:26Z

Gioto at 00:51, 28 December 2024

2024-12-28T00:51:35Z

GaryGriffin: Change Heading level to one level deeper so no H1 on page. Needed for printed document

2024-06-08T23:21:07Z

Change Heading level to one level deeper so no H1 on page. Needed for printed document

Bamaustin: /* See also: */

2024-01-22T21:16:45Z

‎See also:

@@ Line 1: / Line 1: @@
 {{Third-party addon}}
-{{man warn|Advanced use only|''[[{{Version manual}}_Addons#Manually_installed_Addons|Manually install]] [https://github.com/gramps-project/addons-source/tree/maintenance/gramps60/Query only]''. The contributor has marked this preliminary addon as "partially working with some functionality, but much more work is needed; needs testing"
+{{man warn|Advanced use only|''[[{{man version}}_Addons#Manually_installed_Addons|Manually install]] [https://github.com/gramps-project/addons-source/tree/maintenance/gramps60/Query only]''. The contributor has marked this preliminary addon as "partially working with some functionality, but much more work is needed; needs testing"
 Back up your family tree or use on a copy only.}}
@@ Line 7: / Line 7: @@
 ==Usage==
-Once [[{{Version manual}}_Addons#Manually_installed_Addons|installed manually]], you can access the {{man label|Query Gramplet}}:
+Once [[{{man version}}_Addons#Manually_installed_Addons|installed manually]], you can access the {{man label|Query Gramplet}}:
 * On the Dashboard by right clicking and selecting {{man label|Query Gramplet}}
 * Any of the categories by adding a Gramplet and selecting {{man label|Query}} from the drop down list.

@@ Line 292: / Line 292: @@
 QuickView Error: plugin does not load
 </pre>
 ==See also:==

@@ Line 18: / Line 18: @@
 == Examples ==
-The {{man label|Query Gramplet}}Q in Gramps 5.0 can SELECT, UPDATE, and DELETE. Some examples (keywords are shown
+The {{man label|Query Gramplet}} in Gramps 5.0 can SELECT, UPDATE, and DELETE. Some examples (keywords are shown
 capitalized, but the SQL parser is case-insensitive; fields that are capitalized are ''macros'' and must be capitalized, see below for more information):

@@ Line 277: / Line 277: @@
 ==Issues==
 * {{bug|11671}} QueryGramplet: Plugin error (from 'QueryQuickview'): No module named 'gramps.gen.lib.handle'
 ==See also:==

@@ Line 3: / Line 3: @@
 Back up your family tree or use on a copy only.}}
-[[File:QueryGramplet-default-51.png|450px|thumb|right|Query Gramplet - default prompt]]
+[[File:QueryGramplet-default-60.png|450px|thumb|right|Query Gramplet - default prompt]]
 The {{man label|Query Gramplet}} takes SQL-like queries and shows the results in a Quick View.

@@ Line 282: / Line 282: @@
 * [https://sourceforge.net/p/gramps/mailman/message/31782888/ (Gramps-devel) SQL-like API for Gramps gen.lib], From: Doug Blank - 2013-12-24 16:22:09
 ** Which mentions feature request {{bug|6513}} ''tool option needed to edit database''
-* [http://gramps.1791082.n4.nabble.com/query-py-td1804467.html#a1804468 GRAMPS - Dev - query.py] 2009
+* [https://sourceforge.net/p/gramps/mailman/message/22758178/ Re: (Gramps-devel) query.py] From: Doug B. - 2009-06-15 23:41:01 - ''The experiment was largely a failure; the code takes way too long to run to be very useful. ''

← Older revision		Revision as of 00:51, 28 December 2024
Line 1:		Line 1:
−	{{Third-party ~~plugin~~}}	+	{{Third-party addon}}
	{{man warn\|Advanced use only\|''[[{{Version manual}}_Addons#Manually_installed_Addons\|Manually install]] only''. The contributor has marked this preliminary addon as "partially working with some functionality, but much more work is needed; needs testing"		{{man warn\|Advanced use only\|''[[{{Version manual}}_Addons#Manually_installed_Addons\|Manually install]] only''. The contributor has marked this preliminary addon as "partially working with some functionality, but much more work is needed; needs testing"

@@ Line 16: / Line 16: @@
 {{-}}
-= Examples =
+== Examples ==
 The {{man label|Query Gramplet}}Q in Gramps 5.0 can SELECT, UPDATE, and DELETE. Some examples (keywords are shown
@@ Line 65: / Line 65: @@
 I'd be interested in any limitations you find, or enhancement ideas.
-= SQL =
+== SQL ==
 Here is the grammar for the subset of SQL supported. The SELECT, UPDATE, DELETE, and LIMIT clauses may be in any order. The WHERE clause (if used) must be last.
@@ Line 117: / Line 117: @@
 A ''macro'' is a low-level text replacement system. We could add other macros, and even allow users to define their own.
-== Pre-Defined Functions and Libraries ==
+=== Pre-Defined Functions and Libraries ===
 The following are defined for use in your queries:
@@ Line 141: / Line 141: @@
   UPDATE person SET tag_list=Tag("Smith") WHERE SURNAME == "Smith";
-== Lists ==
+=== Lists ===
 When a attribute is a list, you can select elements from items in the list, and also filter the list. For example, consider a person's parent_family_list. You can select only a single component, say private, of the parent family like:
@@ Line 169: / Line 169: @@
   UPDATE note_list[0]=None from person;
-= Notes =
+== Notes ==
 Some notes on use:
@@ Line 241: / Line 241: @@
 ) If you know that only one value will match, then a "LIMIT 1" may be a way to speed up the query.
-= Older documentation for the QueryGramplet in Gramps 3.4 =
+== Older documentation for the QueryGramplet in Gramps 3.4 ==
 This has different table names (people rather than person), and other names that are different (surname vs primary_name.surname_list[0].surname).
@@ Line 275: / Line 275: @@
 </pre>
-=Issues=
+==Issues==
 * {{bug|11671}} QueryGramplet: Plugin error (from 'QueryQuickview'): No module named 'gramps.gen.lib.handle'
-=See also:=
+==See also:==
 Original announcement about "Query Gramplet" from developer "Doug Blank"(2013)
 * [https://sourceforge.net/p/gramps/mailman/message/31782888/ (Gramps-devel) SQL-like API for Gramps gen.lib], From: Doug Blank - 2013-12-24 16:22:09

@@ Line 294: / Line 294: @@
 * [https://www.datacamp.com/community/tutorials/pickle-python-tutorial Pickle Python Tutorial] - '''''not''' specific to Gramps'' (2018)
 [[Category:Plugins]]
 [[Category:Developers/General]]