getattachrec.exe for specific modified date

 6 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Lorena
Advanced Member
Posts: 37
Advanced Member
    Hi,
    I have a PF that get the attachment for an specific job code from JOBCODE table. I am using WebRun for this.
    I would like to get the attachment only if the attachment was modified today. There is a field on L_HJBC name MODDATE that contains the modification date.
    Does someone know how to do this?
    Thanks,
    Lorena
    Robert Spurr
    Veteran Member
    Posts: 130
    Veteran Member
      Attachments are tricky. I normally have to play with the options to see what is returned. Are you needing information on how to extract a comment or just how to get a date? I created a presentation which includes pulling comments for PO's but in this case I didn't care about the date. If that is what you need let me know.
      Robert Spurr
      Veteran Member
      Posts: 130
      Veteran Member
        If all you need is the URL call, you can go to a form that has a comment and click the comment button. Once in the screen click crtl-alt-a. The Drill XML tab you will see CDATA wrapping a URL string. Copy contents and add prefix of the URL like https://prodcutline.com/ whatever works for you. paste into browser address and review return. When I just tested it I found date and time included within the XML.
        Lorena
        Advanced Member
        Posts: 37
        Advanced Member
          Thank you so much Robert. I am able to pull the date now. My call was missing some parameters. Do you use Process Flow to pull your comments? If you have an example, I would like to look at it. The result is in XML format and I do not know how to parse it.
          Thanks a lot.
          Lorena
          Robert Spurr
          Veteran Member
          Posts: 130
          Veteran Member
            I created a presentation for CUE on PO Email confirmations and it includes a detailed explanation on parsing comments. It will require some tweaking on your part as I excluded date/time from my return. I tried uploading the file and the system kept locking so if you provide me a email address I will just send it to you (2 megs in size zipped)
            Lorena
            Advanced Member
            Posts: 37
            Advanced Member
              Thank you so much Robert.
              I was able to parse the xml with your example. You were really helpful
              Preston Burdwell
              Advanced Member
              Posts: 33
              Advanced Member
                Robert, would you be willing to provide the example to me as well? My email is preston.burdwell@stvin.org Thanks!!
                Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR