Почему из
X++:
ret = (select firstOnly startDate from UKS_VillageTask
where UKS_VillageTask.VillageID == this.VillageID
&&
UKS_VillageTask.TaskType == _type
).startDate;
получается вот такой SQL?
Код:
SELECT A.VILLAGEID,A.TASKTYPE,A.STARTDATE,A.ENDDATE,A.ENABLED,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECVERSION,A.RECID FROM UKS_VILLAGETASK A WITH( INDEX(I_50984VILLAGETASKIDX)) WHERE ((DATAAREAID=?) AND ((VILLAGEID=?) AND (TASKTYPE=?))) OPTION(FAST 2)
CacheLookup == None