All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Hi Doug, An EDM report will have access to the ADM data. So, if your OE.ORD query responses are being recorded in ADM.PAT.ccdqr.response, then you can access that field from your EDM report: xx.adm.pat.ccdqr.respomse DAT=FREE LEN=25 [EMAIL PROTECTED],"QUERY"] You can then use that xx field as a Sort Field. Good luck, Brian Schmit Sr. Programmer, Picis Direct: 781 557 3315 Fax: 781 557 3140 100 Quannapowitt Parkway Suite 405 Wakefield, MA 01880 [EMAIL PROTECTED] www.picis.com Please visit www.picis.com/meditech for additional information about our NPR Report Writing Trainings. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access or use by any other person to this internet email is not authorized and may be unlawful. If you are not the intended recipient, please delete or destroy this email. If you do not wish to receive future emails from the sender, please reply directly to this email requesting you be removed from any mailing list. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Howard Chase Sent: Friday, April 21, 2006 2:41 PM To: McGaw, Douglas Cc: [email protected] Subject: Re: [MEDITECH-L] NPR Question - Creating Key field from Query responsein another DPM All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== Hey Doug, Don't know if you received any replies. Seems to me you should be able to use it as a sort, although I've not done it yet. I've often used Query responses from another DPM as a select. Learned it from one of Joel Berman's readmission reports. If you can get a value into a computed field you should be able to use it. If you have an answer from someone who really knows I'd like to hear it. If not, I'm interested enough to probably write an example. Let me know. Howard Chase, RN Androscoggin Valley Hospital 59 Page Hill Road Berlin, NH 03570 (603)326-5669 McGaw, Douglas wrote: > All messages should be posted in plain text. HTML will be converted to > attachments. The meditech-l web site is MTUsers.com > ====================================== > > Here's one that I've never had occasion to try previously.... Any > assistance is greatly appreciated. > > We have a report in EDM.PAT that, among other things, pulls over a query > response from OE.ORD via a fragment. > > Now they want me to use that response as a key field to sort and total > by in another EDM.PAT report. > > I've played with using OE.ORD and then fragging from EDM, but > unfortunately the higher-level sort of registration.date is an EDM field > and we need to stay there. > > What I'm trying to determine is whether it is feasible to use the OE > query response in the EDM.PAT report in this manner and how to do it. I > suspect that a macro and/or an MV array will be needed, but would need > some guidance here. > > Douglas B. McGaw > Hospital Info Svcs Coordinator > Newman Regional Health > 1201 W. 12th Ave. > Emporia, KS 66801 > > Voice: 620-343-6800 x 1130 > Fax: 620-340-6133 > Email: [EMAIL PROTECTED] > > > _______________________________________________ > meditech-l mailing list > [email protected] > http://mtusers.com/mailman/listinfo/meditech-l > _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
