Sample queries

From Inventing aviation

Jump to navigation Jump to search

See also Chart experiments

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

Patent US-1884-305190

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)

Retrieved from "http://econterms.net/aero/index.php?title=Sample_queries&oldid=208430"