Difference between revisions of "Sample queries"

From Inventing aviation
Jump to navigation Jump to search
(comments on letters query; focus attention by putting them at top)
(Changed HOLDS to =)
Line 1: Line 1:
  
 
; List of letters sent by Octave Chanute:
 
; List of letters sent by Octave Chanute:
<pre>{{#cargo_query:table=Letters|fields=_pageName|where=Sender HOLDS 'Octave Chanute'|format=ul}}</pre>
+
<pre>{{#cargo_query:table=Letters|fields=_pageName|where=Sender = 'Octave Chanute'|format=ul}}</pre>
{{#cargo_query:table=Letters|fields=_pageName|where=Sender HOLDS 'Octave Chanute'|format=ul}}
+
{{#cargo_query:table=Letters|fields=_pageName|where=Sender = 'Octave Chanute'|format=ul}}
  
 
; List of letters received by Octave Chanute:
 
; List of letters received by Octave Chanute:
<pre>{{#cargo_query:table=Letters|fields=_pageName|where=Recipient HOLDS 'Octave Chanute'|format=ul}}</pre>
+
<pre>{{#cargo_query:table=Letters|fields=_pageName|where=Recipient = 'Octave Chanute'|format=ul}}</pre>
{{#cargo_query:table=Letters|fields=_pageName|where=Recipient HOLDS 'Octave Chanute'|format=ul}}
+
{{#cargo_query:table=Letters|fields=_pageName|where=Recipient = 'Octave Chanute'|format=ul}}
  
  

Revision as of 17:27, 15 November 2016

List of letters sent by Octave Chanute
{{#cargo_query:table=Letters|fields=_pageName|where=Sender = 'Octave Chanute'|format=ul}}
List of letters received by Octave Chanute
{{#cargo_query:table=Letters|fields=_pageName|where=Recipient = 'Octave Chanute'|format=ul}}


Here is a query giving the patents by Charles T. Holloway
{{#cargo_query:table=Patents|fields=_pageName|where=Inventors HOLDS 'Charles T. Holloway'|format=ul}}
Patents by Octave Chanute or Octave CHANUTE
{{#cargo_query:table=Patents|fields=_pageName|where=Inventors HOLDS 'Octave CHANUTE' OR Inventors HOLDS 'Octave Chanute'|format=ul}}
This query would list US patents in this wiki which were granted in 1911
{{#cargo_query:table=Patents|fields=_pageName|where=YEAR(Year_granted)=1911 AND Office='US'|format=ul}}
This query would show German patents from 1911
{{#cargo_query:table=Patents|fields=_pageName|where=YEAR(Year_granted)=1911 AND Office='DE'|format=ul}}
French patents from 1909
{{#cargo_query:table=Patents|fields=_pageName|where=YEAR(Year_granted)=1909 AND Office='FR'|format=ul}}

(not shown; it's long)