Return-path: Envelope-to: miguel@ssf.com.mx Delivery-date: Tue, 29 Mar 2016 10:49:03 -0600 Received: from o1678990x3.outbound-mail.sendgrid.net ([167.89.90.3]:24756) by vishnu.hosting-mexico.net with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.86_1) (envelope-from ) id 1akwp4-002mj6-K2 for miguel@ssf.com.mx; Tue, 29 Mar 2016 10:49:02 -0600 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=bitbucket.org; h=content-type:mime-version:subject:from:to:references:in-reply-to; s=s1; bh=ifT8CGF0u8LrCoBwh24J+S2J9hE=; b=x9hBJaLmeK5FDBMngjKrCQR o+LP8V5DN7FKc+mjYXs3NKFgh8EQ3a8tQPsLRCpF9+5yjGb6rJMpl2QG6DhFEzEl ZGowNiXRnSXJesORaeHnDjZhJs1yfx8JIIs6aV6xSw2ZOR6JXECNKgu3PCXlFLfZ bCO2PhFI6nUfgQEem9bQ= Received: by filter0558p1mdw1.sendgrid.net with SMTP id filter0558p1mdw1.15175.56FAB1B32E 2016-03-29 16:47:47.420005901 +0000 UTC Received: from celery-worker-101.ash1.bb-inf.net (mail-ash.bitbucket.org [104.192.143.195]) by ismtpd0006p1iad1.sendgrid.net (SG) with ESMTP id kTYx5-9hRy2Umvay3qjFbw for ; Tue, 29 Mar 2016 16:47:47.340 +0000 (UTC) Received: from celery-worker-101.ash1.bb-inf.net (localhost.localdomain [127.0.0.1]) by celery-worker-101.ash1.bb-inf.net (Postfix) with ESMTP id E6AF4120972 for ; Tue, 29 Mar 2016 16:47:44 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============4007504038714302580==" MIME-Version: 1.0 Subject: Re: [Bitbucket] Pull request #743: Reporte pedidos no surtidos (globalgassf/globalnet-app) From: "hgojim" To: miguel@ssf.com.mx Date: Tue, 29 Mar 2016 16:47:44 -0000 Auto-Submitted: auto-generated Message-ID: References: Precedence: bulk In-Reply-To: X-SG-EID: jcizN1ZJXGzc0OL9Q7wZ4g3GQhOSGfYMdoZYX2+1YtdR3T8TaqUIfSjPlScjTAhcwp+VBua0KVL4o8 SVbiDizcpxuoLSeGXBwgRLAEc4qfbAisVmWURXx+ci6MbnxCOXtv7OjETSfwckHBXYfdb3yrq7Q3xb tjWFuM3D2mtLnbefWqJ9+YhjiqgFmfejh3aj8eFHnNoj0ynN2qi4j53zgzGT2ShPVqlE/O+jJ0mRWO c= X-Spam-Status: No, score=-0.1 X-Spam-Score: 0 X-Spam-Bar: / X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see root\@localhost for details. Content preview: --- you can reply above this line --- New comment on pull request: https://bitbucket.org/globalgassf/globalnet-app/pull-requests/743/reporte-pedidos-no-surtidos#comment-16411392 [...] Content analysis details: (-0.1 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 URIBL_BLOCKED ADMINISTRATOR NOTICE: The query to URIBL was blocked. See http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block for more information. [URIs: bitbucket.org] -0.0 RCVD_IN_DNSWL_NONE RBL: Sender listed at http://www.dnswl.org/, no trust [167.89.90.3 listed in list.dnswl.org] -0.0 SPF_PASS SPF: sender matches SPF record 0.0 HTML_MESSAGE BODY: HTML included in message -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author's domain 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature -0.0 RCVD_IN_MSPIKE_H4 RBL: Very Good reputation (+4) [167.89.90.3 listed in wl.mailspike.net] -0.0 RCVD_IN_MSPIKE_WL Mailspike good senders X-Spam-Flag: NO --===============4007504038714302580== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" content-transfer-encoding: quoted-printable --- you can reply above this line ---=0D =0D New comment on pull request:=0D =0D https://bitbucket.org/globalgassf/globalnet-app/pull-requests/743/reporte-p= edidos-no-surtidos#comment-16411392=0D =0D hgojim said:=0D =0D Realmente es necesario hacer estos CONCAT? verifica como viene el par=C3=A1= metro=0D =0D --=0D =0D Unwatch this pull request to stop receiving email updates:=0D https://bitbucket.org/globalgassf/globalnet-app/pull-requests/743/unwatch/m= iguelssf/4f69a5e849889cc5fc723e3e166d9fed83448f62/ --===============4007504038714302580== MIME-Version: 1.0 Content-Type: text/html; charset="utf-8" content-transfer-encoding: quoted-printable =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D
=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D
=0D =0D =0D =0D hgojim commented on pull request #743: Reporte pedidos no surtidos=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D =0D =0D =0D =0D
Reports/Servicios= /PedidosNoSurtidos.jrxml
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D =0D
22+left join usuario u on s.usuario_alta=3Du<= wbr>.id_usuario
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D =0D
23+left join planta p on s.id_planta=3Dp.id_<= wbr>planta
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D =0D
24+left join cuenta c on s.id_cuenta=3Dc.id_<= wbr>cuenta
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D =0D
25+where s.fecha_sistema BETWEEN CONCAT($P{INITDATE},' 00:00:00') and CONCAT($P{ENDDATE},' 23:59:59')
=0D
=0D
=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D 3D"hgojim"=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D hgojim commented on pull request #= 743:=0D =0D =0D
=0D Reporte pedidos no surtidos= =0D
=0D

Realmente es necesario hacer estos CONCAT? verifica c= omo viene el par=C3=A1metro

=0D =0D
=0D
=0D =0D =0D =0D View this pull request or add a co= mment by replying to this email.=0D =0D =0D
=0D
=0D
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D
26+and s.id_planta=3D$P{FACTORY_ID}=0D
=0D
=0D =0D =0D =0D =0D = =0D =0D =0D =0D
27+and s.usuario_alta<>"dae3b62e-d807-4= 795-aef1-5ea7918364a4"
=0D
=0D =0D =0D =0D = =0D =0D =0D =0D
=0D 28+group by dayof= month(s.fecha_sistema), s.usuario_alta]]>
=0D
=0D =0D
=0D
=0D
=0D
=0D =0D =0D =0D =0D =0D =0D =0D =0D
=0D =0D =0D =0D =0D =0D =0D Unwatch this pull r= equest to stop receiving email updates.=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D 3D"Bitbucket"=0D =0D
=0D
=0D
=0D =20=20 3D"" =0D --===============4007504038714302580==--