getattachrec.exe for specific modified date

 6 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Lorena
Advanced Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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