Failing on ordering by a field whose class is not in the select

[danielabutano]

Example:
<query model="genomic" view="Cases.geoLocation.id" constraintLogic="A and B" sortOrder="Cases.date DESC"> <constraint path="Cases.geoLocation.country" value="United Kingdom" op="=" code="A"/> <constraint path="Cases.date" value="2020-04-03" op=">=" code="B"/> </query>
Error message:
org.intermine.objectstore.ObjectStoreException: Field a1_.intermine_date in the ORDER BY list must be in the SELECT list, or
the whole QueryClass org.intermine.model.bio.Cases must be in the SELECT list, or the query made non-distinct"