Цитата:
какой план запроса на рабочем сервере?
SELECT A.ACCOUNTNUM,A.TRANSDATE,A.VOUCHER,A.INVOICE,A.TXT,A.AMOUNTCUR,A.SETTLEAMOUNTCUR,A.AMOUNTMST,
A.SETTLEAMOUNTMST,A.CURRENCYCODE,A.DELPOSSIBLECASHDISC,A.DELUTILIZEDCASHDISC,A.DELCASHDISCDATE,
A.DUEDATE,A.LASTSETTLEVOUCHER,A.LASTSETTLEDATE,A.CLOSED,A.TRANSTYPE,A.APPROVEDBY,A.APPROVED,
A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.EXCHADJUSTMENT,A.DOCUMENTNUM,A.DOCUMENTDATE,A.LASTEXCHADJ,
A.CORRECT,A.SETTLEMENT,A.DEL_OPENTRANS,A.INTEREST,A.COLLECTIONLETTER,A.POSTINGPROFILECLOSE,A.FROMACCOUNT,A.TOACCOUNT,
A.DELOPEN,A.PAYMMODE,A.PAYMREFERENCE,A.PAYMMETHOD,A.CASHPAYMENT,A.CONTROLNUM,A.DELIVERYMODE,A.POSTINGPROFILE,
A.OFFSETRECID,A.EUROTRIANGULATION,A.ORDERACCOUNT,A.CASHDISCCODE,A.PREPAYMENT,A.DEL_EXCHADJUSTMENTTOTAL,A.PAYMSPEC,
A.CUSTEXCHADJUSTMENTREALIZED,A.CUSTEXCHADJUSTMENTUNREALIZED,A.OCRLINE,A.PAYMMANLACKDATE,A.PAYMMANBATCH,A.PAYMID,
A.BILLOFEXCHANGEID,A.BILLOFEXCHANGESTATUS,A.BILLOFEXCHANGESEQNUM,A.BANKREMITTANCEFILEID,A.COLLECTIONLETTERCODE,A.PREPAYMENTINVOICE_RU,
A.CASHPAYMENT_RU,A.SETTLESALESTAXONPAYMENT_RU,A.SALESTAXONPAYMENT_RU,A.RTAX25AMORTISATION,A.RCONTRACTCODE,
A.RCONTRACTACCOUNT,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,A.CREATEDTIME,
A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECVERSION,A.RECID,B.RCONTRACTPARTNERTYPE,B.RCONTRACTACCOUNT,B.RCONTRACTNUMBER,
B.CONTRACTDATE,B.CONTRACTSTARTDATE,B.CONTRACTENDDATE,B.CONTRACTAMOUNT,B.CONTRACTVATAMOUNT,B.CURRENCYCODE,
B.CONTRACTPAYMCODE,B.RCONTRACTPARTNERCODE,B.RCONTRACTSTATUS,B.CONTRACTPOSTINGPROGILE,B.CONTRACTPREPAYMENTPOSTING16014,
B.CONTRACTRESPONSIBLEPERSON,B.CONTACTPERSONID,B.CONTRACTPAYMMODE,B.CONTRACTPAYMSPEC,B.CONTRACTPAYMENTSCHED,
B.CONTRACTCASHDISC,B.CONTACTPHONE,B.LINEOFBUSSENESID,B.CONTACTTELEX,B.CONTACTURL,B.CONTACTEMAIL,B.CONTACTTELEFAX,
B.CONTACTCELLULARPHONE,B.CONTACTPHONELOCAL,B.CONTRACRTHRMORGANISATIONID,B.RCONTRACTCODE,B.RCONTRACTPAYMDAYID,
B.RCONTRACTACCOUNTBASIC,B.RCONTRACTCODEBASIC,B.RCONTRACTPARTNERCODEBASIC,B.PERIODEXPOSINVOICE4PAYM,
B.PERIODGRANTEVIDENCE,B.DAYSHOOTEVIDENCE,B.PERIODADVANCEPAYMENT,B.FACTOREXCESS,B.BANKACCOUNTID,
B.GROUPFINANCID,B.DECEMBER,B.NOVEMBER,B.OCTOBER,B.SEPTEMBER,B.AUGUST,B.JULY,B.JUNE,B.MAY,B.APRIL,B.MARCH,
B.FEBRUARY,B.JANUARY,B.PERCENTADVANCE,B.SOURCE,B.PARAMETERWARNING,B.TYPECONTRACT,B.CONTRACTNUMBERDATE,
B.EXPOSEPAYMENT,B.ACCEPTANCE,B.PERIODACCEPT,B.TERMPAYMENT,B.PERIODPAYMENT,B.DELIVERY,B.CONTRACTFORM,B.PROLONG,
B.VIEWWARNING,B.ISWARN,B.PARMADVANCECALC,B.REGIONNETID,B.PRINTMARK,B.SPGESCONTRACTADD,B.SPGESGRUZOPOKUP,B.SPGESSITE,
B.MODIFIEDDATE,B.MODIFIEDTIME,B.MODIFIEDBY,B.CREATEDDATE,B.CREATEDTIME,B.CREATEDBY,B.RECVERSION,B.RECID,B.RCONTRACTSUBJECT
FROM CUSTTRANS A,RCONTRACTTABLE B
WHERE ((A.DATAAREAID='Company')
AND (A.TRANSDATE<={TS '2008-12-31 00:00:00.000'}))
AND ((B.DATAAREAID='Company')
AND (((((B.GROUPFINANCID='ТСЖ 1')
AND (B.RCONTRACTPARTNERTYPE=0))
AND (A.ACCOUNTNUM=B.RCONTRACTPARTNERCODE))
AND (A.RCONTRACTACCOUNT=B.RCONTRACTACCOUNT))
AND (A.RCONTRACTCODE=B.RCONTRACTCODE)))
ORDER BY A.DATAAREAID,A.TRANSDATE,A.ACCOUNTNUM,A.VOUCHER OPTION(FAST 7)
Цитата:
И ещё увидел у вас в коде
X++:
rangeDimension = queryRun.query().dataSourceTable(tableNum(CustTrans)).rangeField(fieldId2ext(fieldnum(CustTrans, Dimension),2)).value();
Вы этот фильтр не используете. он пустой во время тестирования?
да, пустой..не использую..