Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Help!!!

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Bob
Basic Member
Posts: 7
Basic Member
10/26/2011 1:23 PM
    Is there any easier to perform the following without using multiple branches and assign to accomplish this?

    SQL statement executed via PFI
       SELECT WHLO, RGDT, substring(String(RGTM),0,2) AS HOUR, COUNT(RIDN) AS RIDN05
       FROM *LIBL.MITADI
       WHERE RIDI > 1 AND RGDT = 20100208
       GROUP BY WHLO, RGDT, HOUR;

    Thanks
      
    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
    10/28/2011 1:45 PM
      Is there some reason you can't just use a SQL node and use exactly what you wrote? That's what we do here...
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      Bob
      Basic Member
      Posts: 7
      Basic Member
      10/28/2011 4:18 PM
        I use the SQL node to run this statement, however, I have encountered multiple instance of error that I have not encounter before. Anyhow, I have finally resolve this issue. Right now, I am facing a certain formatting issue within PFI. A query result return 2 numbers. I need one of them in the format of Z,ZZZ,ZZZ and the other one in the format of $9,999,990.99. How can this be accomplish?
        SP
        Veteran Member
        Posts: 122
        Veteran Member
        10/28/2011 5:53 PM
          your int = math.floor(your double)

          On Fri, Oct 28, 2011 at 12:32 PM, wrote:

          > [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> Lawson
          > ProcessFlow Forum Notification A message was posted to a thread you are
          > tracking. *RE: Help!!!* Posted by: *Bob*
          > 10/28/2011 11:18 AM I use the SQL node to run this statement, however, I
          > have encountered multiple instance of error that I have not encounter
          > before. Anyhow, I have finally resolve this issue. Right now, I am facing a
          > certain formatting issue within PFI. A query result return 2 numbers. I need
          > one of them in the format of Z,ZZZ,ZZZ and the other one in the format of
          > $9,999,990.99. How can this be accomplish?
          > ------------------------------
          >
          > To view the complete thread and reply via your browser, please visit:
          > https://www.lawsonguru.co...n/lawson-pflow/help/
          >
          > You were sent this email because you opted to receive email notifications
          > when someone posted and/or responded to a message on this forum.
          > To unsubscribe to this thread please visit your user profile page and
          > change your subscription options.
          >
          > Thank you,
          > LawsonGuru.com
          >