On 17 May 2006, at 09:53, Damian Smedley wrote:
On Wed, 17 May 2006, David Withers wrote:
When I send the following query:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Query>
<Query virtualSchemaName="default" count="0">
<Dataset name="hsapiens_gene_ensembl">
<Filter name="gene_stable_id" value="ENSG00000100031" />
</Dataset>
<Dataset name="hsapiens_genomic_sequence">
<Attribute name="cdna" />
</Dataset>
<Dataset name="hsapiens_gene_ensembl_structure">
<Attribute name="gene_stable_id" />
</Dataset>
<Links source="hsapiens_gene_ensembl"
target="hsapiens_gene_ensembl_structure"
defaultLink="hsapiens_internal_transcript_id" />
<Links source="hsapiens_gene_ensembl_structure"
target="hsapiens_genomic_sequence" defaultLink="cdna" />
</Query>
to http://www.biomart.org/biomart/martservice?query=
the results I get back are ordered: 'gene_stable_id', 'cdna'.
I was expecting the results to be in the order that the attributes are
specified in the query. How can I determine the order in which the
results will be returned?
attributes within the same dataset certainly maintain the order they
are
added but the order of datasets in the final result table is
determined by
the linking order by the nature of how out software works (ie)
structure
dataset links to seqence so you will get all the attributes you added
to
structure in order followed by the sequence atts. We have been having
discussion about how to do this but we decided mixing up attributes
from
different datasets would be confusing to the user. Whether we can do
something about the final dataset order though remains to be seen
just a small comment. With a coming 0.5 you will have full control
over the order because you'll only be required to specify
visible datasets. The order of those datasets and attributes within
them will decided about your final attribute order
a.
best wishes
Damian
David.
--
David Withers
School of Computer Science, University of Manchester,
Oxford Road, Manchester, M13 9PL, UK.
Tel: +44(0)161 275 0145
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------