To query just those columns found in a working list (no other data from the records), you can take advantage of the views that exist in Biotics for all the working list types except Element (a separate item will be created with instructions on replicating Element Working List). The general query structure is as follows:

SELECT distinct {subject area name)_WL_VW.* FROM {subject area name}_WL_VW WHERE {subject area name}_WL_VW.ID in
(select WORKING_LIST_{subject area name}_DATA.DATA_ID from WORKING_LIST_{subject area name}_DATA, WORKING_LIST where WORKING_LIST_{subject area name}_DATA.WORKING_LIST_ID =
WORKING_LIST.WORKING_LIST_ID and
WORKING_LIST.WORKING_LIST_NAME = '{working list name}' )

Example: to query an EO working list named "vertebrates", use the following query:

SELECT distinct EO_WL_VW.*
FROM EO_WL_VW
WHERE EO_WL_VW.ID in
(select WORKING_LIST_EO_DATA.DATA_ID
from WORKING_LIST_EO_DATA, WORKING_LIST
where WORKING_LIST_EO_DATA.WORKING_LIST_ID =
WORKING_LIST.WORKING_LIST_ID and
WORKING_LIST.WORKING_LIST_NAME = 'Vertebrates' )

WARNING: Because these queries depend upon a view, they may take much longer to run than a query you construct yourself to return the same columns as appear in a working list window, especially for very large working lists. Therefore:

Attached is a document submitted by Debbie Webb of the British Columbia CDC with queries for outputting an Element, EO, and Reference working list.
(Note that the Element working list query pertains to EST working lists and does not bring back all the columns displayed in the Element window. See the Knowledge Base item QUERY: Get data in an element working list for a query that replicates all the columns and can be used for mixed EGT-ENT-EST lists.)