RE: [MEDITECH-L] NPR - Is it possible to do a lookup in Select on CDSgroup response field

[Brian Schmit]

Hi Aamer,   I know this is possible in 5.5, but I don't think it is available in earlier versions of Meditech CS.  Here is how it would be done:   Using option # 9 in the Process Reports routine to Edit Screen Elements, add the following attribute to your field:   ID=%Z.id(^&(G)GGL["GROUP"]E,A,"Mnemonic":16L,"CD:16L","","",{"N"})   Z.id is the general lookup program in Meditech CS.  You will need to replace "GROUP" with the mnemonic of your Meditech MIS Group Response.    The first argument, ^&(G)GGL["GROUP"]E, specifies which table (or segment) should be used as the basis for the "lookup".  &(G) is the prefix connected to your Meditech MIS dictionaries.  GGL is the name of the MIS.GROUP.RESP main table.  "GROUP" is the subscript for this table.  E is the hard-coded portion of the physical address for the child table that stores the elements of the Group Response.   The second argument is simply the point at which the "lookup" should begin.  In the case of your NPR Screens, A is the value that the end-user enters into that field.   The third argument is the display string, "Mnemonic" will be formatted to appear in a string of 16 characters and it will be left-justified.  : is the format operator, and L specifies left-justification.   The fourth argument "CD:16L" is the data to display.  CD symbolizes the mnemonic of the "lookup"  In this case, the subscript of the elements table is the mnemonic of the lookup, so it will be formatted to appear in a string of 16 characters and will be left-justified.   The fifth argument is the Lookup Argument, which is usually "AR" (Active Restricted) or "BR" (Both Active and Inactive Restricted").  R for Restricted specifies that you are restricted to only selecting the entries in the "lookup" table, you CANNOT create new ones.  You can only do that through the Meditech MIS Group Response dictionary Enter/Edit routine.   The sixth argument is the Lookup Title.   The last argument is a queued string.  I only needed the first piece of the queued string.  It is an "N" to instruct the "lookup" program Z.,id to NOT check for the active flag.  The elements segment in MIS.GROUP.RESP does NOT have an active field, so our "lookup" program should not bother checking for it.   Please let me know if you have any questions.   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 http://www.picis.com/services/technical/npr.asp# 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]On Behalf Of Mustafa Aamer Sent: Wednesday, November 01, 2006 1:40 AM To: meditech-l@MTUsers.com Subject: [MEDITECH-L] NPR - Is it possible to do a lookup in Select on CDSgroup response field Importance: High Hello:   We are C/S 5.1. I have a question about NPR report which I am doing in ADM.PAT, is it possible to do a lookup in SELECT on CDS Group Response field?   Any comments will be much appreciated.     Thank you,    aamer Aamer, Mustafa Application Support HIS Direct: +9712 610 3745 (work)

======================================
All messages should be posted in plain text.  
HTML will be converted to attachments.    

The meditech-l web site is MTUsers.com
______________________________________
meditech-l mailing list
meditech-l@MTUsers.com
http://mtusers.com/mailman/listinfo/meditech-l