[SQL] 纯文本查看 复制代码
SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xactivity, t0.xactivityAlias, t0.xactivityDescription, t0.xactivityName, t0.xactivityToken, t0.xactivityType, t0.xapplication, t0.xapplicationAlias, t0.xapplicationName, t0.xbooleanValue01, t0.xbooleanValue02, t0.xcompleted, t0.xcompletedTime, t0.xcompletedTimeMonth, t0.xcreatorIdentity, t0.xcreatorPerson, t0.xcreatorUnit, t0.xcurrentActivityName, t0.xdateTimeValue01, t0.xdateTimeValue02, t0.xdateTimeValue03, t0.xdateTimeValue04, t0.xdateTimeValue05, t0.xdateValue01, t0.xdateValue02, t0.xdoubleValue01, t0.xdoubleValue02, t0.xdoubleValue03, t0.xdoubleValue04, t0.xdoubleValue05, t0.xduration, t0.xempowerFromIdentity, t0.xempowerToIdentity, t0.xexpireTime, t0.xexpired, t0.xidentity, t0.xjob, t0.xjoinInquire, t0.xlatest, t0.xlongValue01, t0.xlongValue02, t0.xlongValue03, t0.xlongValue04, t0.xlongValue05, t0.xmediaOpinion, t0.xopinion, t0.xopinionLob, t0.xperson, t0.xpressActivityToken, t0.xpressCount, t0.xpressTime, t0.xprocess, t0.xprocessAlias, t0.xprocessName, t0.xprocessingType, t0.xproperties, t0.xretractTime, t0.xrouteName, t0.xserial, t0.xstartTime, t0.xstartTimeMonth, t0.xstringValue01, t0.xstringValue02, t0.xstringValue03, t0.xstringValue04, t0.xstringValue05, t0.xstringValue06, t0.xstringValue07, t0.xstringValue08, t0.xstringValue09, t0.xstringValue10, t0.xtask, t0.xtimeValue01, t0.xtimeValue02, t0.xtitle, t0.xunit, t0.xwork, t0.xworkCompleted FROM X.PP_C_TASKCOMPLETED t0 WHERE (t0.xperson = $1 AND (t0.xprocess = $2 OR t0.xprocess = $3 OR t0.xprocess = $4 OR t0.xprocess = $5 OR t0.xprocess = $6 OR t0.xprocess = $7 OR t0.xprocess = $8 OR t0.xprocess = $9 OR t0.xprocess = $10 OR t0.xprocess = $11 OR t0.xprocess = $12 OR t0.xprocess = $13 OR t0.xprocess = $14 OR t0.xprocess = $15 OR t0.xprocess = $16 OR t0.xprocess = $17 OR t0.xprocess = $18 OR t0.xprocess = $19 OR t0.xprocess = $20 OR t0.xprocess = $21 OR t0.xprocess = $22 OR t0.xprocess = $23 OR t0.xprocess = $24 OR t0.xprocess = $25 OR t0.xprocess = $26 OR t0.xprocess = $27 OR t0.xprocess = $28 OR t0.xprocess = $29 OR t0.xprocess = $30 OR t0.xprocess = $31 OR t0.xprocess = $32 OR t0.xprocess = $33 OR t0.xprocess = $34 OR t0.xprocess = $35 OR t0.xprocess = $36 OR t0.xprocess = $37 OR t0.xprocess = $38 OR t0.xprocess = $39 OR t0.xprocess = $40 OR t0.xprocess = $41 OR t0.xprocess = $42 OR t0.xprocess = $43 OR t0.xprocess = $44 OR t0.xprocess = $45 OR t0.xprocess = $46 OR t0.xprocess = $47 OR t0.xprocess = $48 OR t0.xprocess = $49 OR t0.xprocess = $50 OR t0.xprocess = $51 OR t0.xprocess = $52 OR t0.xprocess = $53 OR t0.xprocess = $54 OR t0.xprocess = $55 OR t0.xprocess = $56 OR t0.xprocess = $57 OR t0.xprocess = $58 OR t0.xprocess = $59 OR t0.xprocess = $60 OR t0.xprocess = $61 OR t0.xprocess = $62 OR t0.xprocess = $63 OR t0.xprocess = $64 OR t0.xprocess = $65 OR t0.xprocess = $66 OR t0.xprocess = $67 OR t0.xprocess = $68 OR t0.xprocess = $69 OR t0.xprocess = $70 OR t0.xprocess = $71 OR t0.xprocess = $72 OR t0.xprocess = $73 OR t0.xprocess = $74 OR t0.xprocess = $75 OR t0.xprocess = $76 OR t0.xprocess = $77 OR t0.xprocess = $78 OR t0.xprocess = $79 OR t0.xprocess = $80 OR t0.xprocess = $81 OR t0.xprocess = $82 OR t0.xprocess = $83 OR t0.xprocess = $84 OR t0.xprocess = $85 OR t0.xprocess = $86 OR t0.xprocess = $87 OR t0.xprocess = $88 OR t0.xprocess = $89 OR t0.xprocess = $90 OR t0.xprocess = $91 OR t0.xprocess = $92 OR t0.xprocess = $93 OR t0.xprocess = $94 OR t0.xprocess = $95 OR t0.xprocess = $96 OR t0.xprocess = $97 OR t0.xprocess = $98 OR t0.xprocess = $99 OR t0.xprocess = $100 OR t0.xprocess = $101 OR t0.xprocess = $102 OR t0.xprocess = $103 OR t0.xprocess = $104 OR t0.xprocess = $105 OR t0.xprocess = $106 OR t0.xprocess = $107 OR t0.xprocess = $108 OR t0.xprocess = $109 OR t0.xprocess = $110 OR t0.xprocess = $111 OR t0.xprocess = $112 OR t0.xprocess = $113 OR t0.xprocess = $114 OR t0.xprocess = $115 OR t0.xprocess = $116 OR t0.xprocess = $117 OR t0.xprocess = $118 OR t0.xprocess = $119 OR t0.xprocess = $120 OR t0.xprocess = $121 OR t0.xprocess = $122 OR t0.xprocess = $123 OR t0.xprocess = $124 OR t0.xprocess = $125 OR t0.xprocess = $126 OR t0.xprocess = $127 OR t0.xprocess = $128 OR t0.xprocess = $129 OR t0.xprocess = $130 OR t0.xprocess = $131 OR t0.xprocess = $132 OR t0.xprocess = $133 OR t0.xprocess = $134 OR t0.xprocess = $135 OR t0.xprocess = $136 OR t0.xprocess = $137 OR t0.xprocess = $138 OR t0.xprocess = $139 OR t0.xprocess = $140 OR t0.xprocess = $141 OR t0.xprocess = $142 OR t0.xprocess = $143 OR t0.xprocess = $144 OR t0.xprocess = $145 OR t0.xprocess = $146 OR t0.xprocess = $147 OR t0.xprocess = $148 OR t0.xprocess = $149 OR t0.xprocess = $150 OR t0.xprocess = $151 OR t0.xprocess = $152 OR t0.xprocess = $153 OR t0.xprocess = $154 OR t0.xprocess = $155 OR t0.xprocess = $156 OR t0.xprocess = $157 OR t0.xprocess = $158 OR t0.xprocess = $159 OR t0.xprocess = $160 OR t0.xprocess = $161 OR t0.xprocess = $162 OR t0.xprocess = $163 OR t0.xprocess = $164 OR t0.xprocess = $165 OR t0.xprocess = $166 OR t0.xprocess = $167 OR t0.xprocess = $168 OR t0.xprocess = $169 OR t0.xprocess = $170 OR t0.xprocess = $171 OR t0.xprocess = $172 OR t0.xprocess = $173 OR t0.xprocess = $174 OR t0.xprocess = $175 OR t0.xprocess = $176 OR t0.xprocess = $177 OR t0.xprocess = $178 OR t0.xprocess = $179 OR t0.xprocess = $180 OR t0.xprocess = $181 OR t0.xprocess = $182 OR t0.xprocess = $183 OR t0.xprocess = $184 OR t0.xprocess = $185 OR t0.xprocess = $186 OR t0.xprocess = $187 OR t0.xprocess = $188 OR t0.xprocess = $189 OR t0.xprocess = $190 OR t0.xprocess = $191 OR t0.xprocess = $192 OR t0.xprocess = $193 OR t0.xprocess = $194 OR t0.xprocess = $195 OR t0.xprocess = $196 OR t0.xprocess = $197 OR t0.xprocess = $198 OR t0.xprocess = $199 OR t0.xprocess = $200 OR t0.xprocess = $201 OR t0.xprocess = $202 OR t0.xprocess = $203 OR t0.xprocess = $204 OR t0.xprocess = $205 OR t0.xprocess = $206 OR t0.xprocess = $207 OR t0.xprocess = $208 OR t0.xprocess = $209 OR t0.xprocess = $210 OR t0.xprocess = $211 OR t0.xprocess = $212 OR t0.xprocess = $213 OR t0.xprocess = $214 OR t0.xprocess = $215 OR t0.xprocess = $216 OR t0.xprocess = $217 OR t0.xprocess = $218 OR t0.xprocess = $219 OR t0.xprocess = $220 OR t0.xprocess = $221 OR t0.xprocess = $222 OR t0.xprocess = $223 OR t0.xprocess = $224 OR t0.xprocess = $225 OR t0.xprocess = $226 OR t0.xprocess = $227 OR t0.xprocess = $228 OR t0.xprocess = $229 OR t0.xprocess = $230 OR t0.xprocess = $231 OR t0.xprocess = $232 OR t0.xprocess = $233 OR t0.xprocess = $234 OR t0.xprocess = $235 OR t0.xprocess = $236 OR t0.xprocess = $237 OR t0.xprocess = $238 OR t0.xprocess = $239 OR t0.xprocess = $240 OR t0.xprocess = $241 OR t0.xprocess = $242 OR t0.xprocess = $243 OR t0.xprocess = $244 OR t0.xprocess = $245 OR t0.xprocess = $246 OR t0.xprocess = $247 OR t0.xprocess = $248 OR t0.xprocess = $249 OR t0.xprocess = $250 OR t0.xprocess = $251 OR t0.xprocess = $252 OR t0.xprocess = $253 OR t0.xprocess = $254 OR t0.xprocess = $255 OR t0.xprocess = $256 OR t0.xprocess = $257 OR t0.xprocess = $258 OR t0.xprocess = $259 OR t0.xprocess = $260 OR t0.xprocess = $261 OR t0.xprocess = $262 OR t0.xprocess = $263 OR t0.xprocess = $264 OR t0.xprocess = $265 OR t0.xprocess = $266 OR t0.xprocess = $267 OR t0.xprocess = $268 OR t0.xprocess = $269 OR t0.xprocess = $270 OR t0.xprocess = $271 OR t0.xprocess = $272 OR t0.xprocess = $273 OR t0.xprocess = $274 OR t0.xprocess = $275 OR t0.xprocess = $276 OR t0.xprocess = $277 OR t0.xprocess = $278 OR t0.xprocess = $279 OR t0.xprocess = $280 OR t0.xprocess = $281 OR t0.xprocess = $282 OR t0.xprocess = $283 OR t0.xprocess = $284 OR t0.xprocess = $285 OR t0.xprocess = $286 OR t0.xprocess = $287 OR t0.xprocess = $288 OR t0.xprocess = $289 OR t0.xprocess = $290 OR t0.xprocess = $291 OR t0.xprocess = $292 OR t0.xprocess = $293 OR t0.xprocess = $294 OR t0.xprocess = $295 OR t0.xprocess = $296 OR t0.xprocess = $297 OR t0.xprocess = $298 OR t0.xprocess = $299 OR t0.xprocess = $300 OR t0.xprocess = $301 OR t0.xprocess = $302 OR t0.xprocess = $303 OR t0.xprocess = $304 OR t0.xprocess = $305 OR t0.xprocess = $306 OR t0.xprocess = $307 OR t0.xprocess = $308 OR t0.xprocess = $309 OR t0.xprocess = $310 OR t0.xprocess = $311 OR t0.xprocess = $312 OR t0.xprocess = $313 OR t0.xprocess = $314 OR t0.xprocess = $315 OR t0.xprocess = $316 OR t0.xprocess = $317 OR t0.xprocess = $318 OR t0.xprocess = $319 OR t0.xprocess = $320 OR t0.xprocess = $321 OR t0.xprocess = $322 OR t0.xprocess = $323 OR t0.xprocess = $324 OR t0.xprocess = $325 OR t0.xprocess = $326 OR t0.xprocess = $327 OR t0.xprocess = $328 OR t0.xprocess = $329 OR t0.xprocess = $330 OR t0.xprocess = $331 OR t0.xprocess = $332 OR t0.xprocess = $333 OR t0.xprocess = $334 OR t0.xprocess = $335 OR t0.xprocess = $336 OR t0.xprocess = $337 OR t0.xprocess = $338 OR t0.xprocess = $339 OR t0.xprocess = $340 OR t0.xprocess = $341 OR t0.xprocess = $342 OR t0.xprocess = $343 OR t0.xprocess = $344 OR t0.xprocess = $345 OR t0.xprocess = $346 OR t0.xprocess = $347 OR t0.xprocess = $348 OR t0.xprocess = $349) AND t0.xprocess IS NOT NULL AND (t0.xcompleted IS NULL OR t0.xcompleted = $350) AND (t0.xlatest = $351 OR t0.xlatest IS NULL)) ORDER BY t0.xcreateTime DESC
[信息未更新]
