Malvineous: Query examples

2016-03-18T09:13:45Z

Query examples

New page

The method used to record devices on this wiki means they can be used for running queries. Here are some examples of different types of queries you might wish to run.

== Looking for a device to obtain ==

For simple queries, you can look at the device pages and sort by column headings. For example to see all sound cards that have genuine OPL FM synthesis (as opposed to one of the clones), you can look at [[Audio]] and sort by the "FM synth" column. All the "OPL" cards will be grouped together in the middle.

For more complex questions, you can build a query. Here are some examples you can edit to alter or extend:

* [http://www.vogonswiki.com/index.php?title=Special:Ask&q=%5B%5BIs+8-bit+ISA+compatible%3A%3AYes%5D%5D%0A%5B%5BHas+CD+interface%3A%3AMatsushita+MKE%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D...-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FChipset%0A%3FFM+synth%0A%3FRequires+-5VDC%0A&eq=no List of 8-bit compatible devices that support the Panasonic proprietary CD interface]

* [http://www.vogonswiki.com/index.php?title=Special:Ask&q=%5B%5BIs+secondary+floppy%3A%3AYes%5D%5D%0A%5B%5BNumber+of+IDE+buses%3A%3A%3E1%5D%5D%0A&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D...-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FChipset%0A%3FNumber+of+IDE+buses%0A%3FRequires+-5VDC%0A&eq=no Controllers that can be set to the secondary floppy address, and have at least one IDE bus]

* [http://www.vogonswiki.com/index.php?title=Special:Ask&q=%5B%5BHas+total+PCI+slots%3A%3A%3E1%5D%5D%0A&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D...-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FChipset%0A%3FHas+32-bit+33MHz+PCI+slots%3D32b%2F33MHz%0A%3FHas+32-bit+66MHz+PCI+slots%3D32b%2F66MHz%0A%3FHas+64-bit+33MHz+PCI+slots%3D64b%2F33MHz%0A%3FHas+64-bit+66MHz+PCI+slots%3D64b%2F66MHz%0A%3FHas+64-bit+133MHz+PCI+slots%3D64b%2F133MHz%0A%3FHas+total+PCI+slots%3DTotal%0A%3FRequires+-5VDC%0A&eq=no Motherboards that have at least four PCI slots]

== Looking for a device you own with a certain capability ==

If you have a large number of devices, it can be time consuming to look up each model to find out whether it is capable of performing a certain task. However if you add each device you own to a list on your userpage, then you can run queries against the wiki that only show devices you already own.

Here are some examples you can use to base your own queries from:

* Malvineous wishes to build an XT which only has 8-bit ISA slots → [http://www.vogonswiki.com/index.php?title=Special:Ask&q=%5B%5B-Owns+device%3A%3AUser%3AMalvineous%5D%5D%0A%5B%5BIs+8-bit+ISA+compatible%3A%3Atrue%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D...-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FChipset%0A%3FRequires+-5VDC%0A&eq=no All 8-bit compatible cards owned by Malvineous]

* Malvineous is given a CD drive that uses the Panasonic proprietary (non-IDE) interface. How can it be tested to see if it still works? → [http://www.vogonswiki.com/index.php?title=Special:Ask&q=%5B%5B-Owns+device%3A%3AUser%3AMalvineous%5D%5D%0A%5B%5BHas+CD+interface%3A%3AMatsushita+MKE%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D...-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FChipset%0A%3FFM+synth%0A%3FRequires+-5VDC%0A&eq=no Interface cards owned by Malvineous which have a Panasonic CD interface]

This of course requires that you have listed all the devices you own on your userpage. You can list them in any form, as long as the "Owns device" syntax is used. See the wiki code on [[User:Malvineous]] for examples.

Vogons Wiki:Running queries - Revision history

Malvineous: Query examples