Difference between revisions of "User:WikiSysop/Sandbox/Badquery"

MyWikiBiz, Author Your Legacy — Sunday November 24, 2024
Jump to navigationJump to search
 
(31 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==Query Problems==
 
==Query Problems==
 +
  
 
===Character set conversion problems===
 
===Character set conversion problems===
Line 39: Line 40:
 
{{#ask: [[Fatalities::>0]]
 
{{#ask: [[Fatalities::>0]]
 
|
 
|
 +
| ?Date=Date
 +
| ?Accident_Cause=Cause
 +
| ?Aircraft_Type=Aircraft
 +
| ?Airline=Airline
 +
| ?Airport_Code=Airport involved
 +
| ?Miles_Traveled=Miles Traveled
 +
| ?State_Code=State of incident
 +
| ?Survivors=Survivors
 +
| ?Fatalities=Deaths
 +
}}
 +
 +
===Page not shown as a link===
 +
The page/article name table doesn't contain a clickable link back to that page. The first line in the return result is the name of the first column field which should also be, in this case, the page name.
 +
 +
=====query=====
 +
<nowiki>[[Fatalities::>0]][[Fatalities::<1001]]</nowiki>
 +
 +
=====result=====
 +
{{#ask: [[Fatalities::>0]][[Fatalities::<1001]]
 +
|
 +
| ?Date=Date
 +
| ?Accident_Cause=Cause
 +
| ?Aircraft_Type=Aircraft
 +
| ?Airline=Airline
 +
| ?Airport_Code=Airport involved
 +
| ?Miles_Traveled=Miles Traveled
 +
| ?State_Code=State of incident
 +
| ?Survivors=Survivors
 +
| ?Fatalities=Deaths
 +
}}
 +
 +
====Good Query:====
 +
 +
=====query=====
 +
<nowiki>[[Fatalities::>0]]</nowiki>
 +
 +
=====result=====
 +
{{#ask: [[Fatalities::>0]]
 +
|
 +
| ?Date=Date
 +
| ?Accident_Cause=Cause
 +
| ?Aircraft_Type=Aircraft
 +
| ?Airline=Airline
 +
| ?Airport_Code=Airport involved
 +
| ?Miles_Traveled=Miles Traveled
 +
| ?State_Code=State of incident
 +
| ?Survivors=Survivors
 +
| ?Fatalities=Deaths
 +
}}
 +
 +
===Correct category===
 +
 +
Best choice (category set to : <nowiki>[[Category:Accidents and incidents on commercial airliners in the United States]]</nowiki>
 +
Query set to :  <nowiki>[[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]</nowiki>
 +
 +
{{#ask: [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]
 +
|
 +
| ?Date=Date
 +
| ?Accident_Cause=Cause
 +
| ?Aircraft_Type=Aircraft
 +
| ?Airline=Airline
 +
| ?Airport_Code=Airport involved
 +
| ?Miles_Traveled=Miles Traveled
 +
| ?State_Code=State of incident
 +
| ?Survivors=Survivors
 +
| ?Fatalities=Deaths
 +
}}
 +
 +
 +
===Linkable result for page in the first result column===
 +
 +
{{#ask: [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]
 +
| mainlabel=Airline/Flight
 +
| link=subject
 
| ?Date=Date
 
| ?Date=Date
 
| ?Accident_Cause=Cause
 
| ?Accident_Cause=Cause

Latest revision as of 22:49, 10 October 2010

Query Problems

Character set conversion problems

Incorrect

Incorrect character encoding: Aeroméxic Flight 498

Correct

Correct character encoding: Aeroméxico Flight 498

Ask query syntax

The query used Fatalities (deaths) as the search term.

Original Query:

query

[[Fatalities::>0]][[Fatalities::<1001]]

result
 Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941

Good Query:

query

[[Fatalities::>0]]

result
 Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Air Canada Flight 7972 June 1983Mechanical (fire)DC-9Air CanadaCVG814Ohio2323
Air Florida Flight 9013 January 1982Weather (icing)737Air FloridaDCA1District of Columbia574
Air Midwest Flight 54818 January 2003Mechanical (elevators)1900Air MidwestCLT1North Carolina021
Alaska Airlines Flight 26131 January 2000Mechanical (jackscrews)MD83Alaska AirlinesSFO1320California088
Allegheny Airlines Flight 8539 September 1969Air trafficDC-9Allegheny AirlinesIND90Indiana082
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941
Continental Flight 340712 February 2009Weather (icing)Dash 8ContinentalBUF280New York050

Page not shown as a link

The page/article name table doesn't contain a clickable link back to that page. The first line in the return result is the name of the first column field which should also be, in this case, the page name.

query

[[Fatalities::>0]][[Fatalities::<1001]]

result
 Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941

Good Query:

query

[[Fatalities::>0]]

result
 Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Air Canada Flight 7972 June 1983Mechanical (fire)DC-9Air CanadaCVG814Ohio2323
Air Florida Flight 9013 January 1982Weather (icing)737Air FloridaDCA1District of Columbia574
Air Midwest Flight 54818 January 2003Mechanical (elevators)1900Air MidwestCLT1North Carolina021
Alaska Airlines Flight 26131 January 2000Mechanical (jackscrews)MD83Alaska AirlinesSFO1320California088
Allegheny Airlines Flight 8539 September 1969Air trafficDC-9Allegheny AirlinesIND90Indiana082
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941
Continental Flight 340712 February 2009Weather (icing)Dash 8ContinentalBUF280New York050

Correct category

Best choice (category set to : [[Category:Accidents and incidents on commercial airliners in the United States]] Query set to : [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]

 Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Air Canada Flight 7972 June 1983Mechanical (fire)DC-9Air CanadaCVG814Ohio2323
Air Florida Flight 9013 January 1982Weather (icing)737Air FloridaDCA1District of Columbia574
Air Midwest Flight 54818 January 2003Mechanical (elevators)1900Air MidwestCLT1North Carolina021
Alaska Airlines Flight 26131 January 2000Mechanical (jackscrews)MD83Alaska AirlinesSFO1320California088
Allegheny Airlines Flight 8539 September 1969Air trafficDC-9Allegheny AirlinesIND90Indiana082
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941
Continental Flight 340712 February 2009Weather (icing)Dash 8ContinentalBUF280New York050


Linkable result for page in the first result column

Airline/FlightDate"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.CauseAircraftAirlineAirport involvedMiles TraveledState of incidentSurvivorsDeaths
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Aeroméxico Flight 49831 August 1986Air trafficDC-9AeroméxicoLAX135California064
Air Canada Flight 7972 June 1983Mechanical (fire)DC-9Air CanadaCVG814Ohio2323
Air Florida Flight 9013 January 1982Weather (icing)737Air FloridaDCA1District of Columbia574
Air Midwest Flight 54818 January 2003Mechanical (elevators)1900Air MidwestCLT1North Carolina021
Alaska Airlines Flight 26131 January 2000Mechanical (jackscrews)MD83Alaska AirlinesSFO1320California088
Allegheny Airlines Flight 8539 September 1969Air trafficDC-9Allegheny AirlinesIND90Indiana082
Aloha Airlines Flight 24328 April 1988Mechanical (decompression)737Aloha AirlinesOGG100Hawaii941
Continental Flight 340712 February 2009Weather (icing)Dash 8ContinentalBUF280New York050
Retrieved from "https://mywikibiz.com/index.php?title=User:WikiSysop/Sandbox/Badquery&oldid=128025"