search

intermine / intermine

A powerful open source data warehouse system
http://intermine.org
Other
254 stars 348 forks source link

If a query has more than 26 constraints, you run out of letters #585

Open julie-sullivan opened 10 years ago

julie-sullivan commented 10 years ago

from Joe If a query has more than 26 constraints, you run out of letters

julie-sullivan commented 7 years ago

Here is an example query that a user sent me. this does happen!

<query name="" model="genomic" view="Gene.symbol Gene.name Gene.secondaryIdentifier Gene.mRNAExpressionResults.mRNAExpressionTerms.name" longDescription="" 
constraintLogic="A and B and C and (I or J or K or L or M or N or O or P or Q or R or S or T or U or V or W or X)">
<constraint path="Gene" code="A" op="IN" value="DNA binding TFs expressed stage 4 to 16"/>
<constraint path="Gene.mRNAExpressionResults.expressed" code="B" op="=" value="true"/><constraint path="Gene.mRNAExpressionResults.dataSet.name" code="C" op="=" value="BDGP in situ data set"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="I" op="CONTAINS" value="nervous"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="J" op="CONTAINS" value="mesectoderm"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="K" op="CONTAINS" value="neuron"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="L" op="CONTAINS" value="neuroblast"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="M" op="CONTAINS" value="neurectoderm"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="N" op="CONTAINS" value="brain"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="O" op="CONTAINS" value="nerve"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="P" op="CONTAINS" value="ventral ectoderm"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="Q" op="CONTAINS" value="visual"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="R" op="CONTAINS" value="cerebrum"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="S" op="CONTAINS" value="mushroom body"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="T" op="CONTAINS" value="ganglion"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="U" op="CONTAINS" value="neuroderm"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="V" op="CONTAINS" value="glia"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="W" op="CONTAINS" value="ventral midline"/>
<constraint path="Gene.mRNAExpressionResults.mRNAExpressionTerms.name" code="X" op="CONTAINS" value="sensory"/></query>