Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Mel help for actionable letter

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

79 Views

RSS

heggea

(@heggea)

Posts: 52

Trusted Member

Topic starter

I am trying to write a letter for missed labs. I want to be able to print it from reports but want it to mark if fasting is required based on the orders. Is this possible?

I was able to list the labs needed in the letter using this : {if ORDERS_AFTER("List","T") <> "" then ORDERS_AFTER('list','T') else "None" endif}. But I cannot get it to mark if it is fasting or not. Using the mel code below it just marks it as nonfasting no matter what labs are ordered.

{if ORDERS_AFTER("List","T")=="lipids"or"BMP"or"CMP"or"fasting glucose" then " Fasting required__X____ Nonfasting required_____" else " Fasting required______ Nonfasting required__X___ " endif}

Thank you.

Posted : June 16, 2015 12:43 pm

cecild

(@cecild)

Posts: 314

Reputable Member

I believe you will have to use an array for this and match to the first field. Otherwise I don't believe it breaks down the list by fields in order to match to order name.

Posted : June 17, 2015 3:10 am

cecild

(@cecild)

Posts: 314

Reputable Member

The below code should work. Place the last line "{fnGetarray2()}" where you want the text to appear.

{!fn fnGetarray2() { local sList = "" local sAry ="" local aRow local i local imax local Text = "" local OrdValue = "False"


	sList = ORDERS_AFTER('DELIMITED','T')

	sAry = getfield(sList,"|","")

	imax = size(sAry)
	for i=1, i<=imax, i=i+1 do

		aRow = getfield(sAry[i],"^","")

		if (str(aRow[1])= ”lipids”or”BMP”or”CMP”or”fasting glucose”) then OrdValue = "True"
		else ""
		endif
	endfor
	if (OrdValue = "True") then

	Text = "Fasting required__X____    Nonfasting required_____"
	else 
	Text = ”Fasting required______    Nonfasting required__X___” 
	endif
Return Text
}

}
{fnGetarray2()}


                    
                    	
                            Posted : June 17, 2015 5:11 am



        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 Jim Poulos
                        (@jpoulos)
                        
                                                    
                        
                            Posts: 118                        
                        
                            Estimable Member                        
                            
		                
	                    
                    
                

                
                	
                                                 
                    	
							                        
                                            
                    
                        You might also want to review and change your comparison.   You need to compare your OBS term to each potential value.      Because ORDERS_AFTER can contain many items, you need to match your value to the list.   The " > 0" is comparing it zero and not an O (oh).
 
{if match(ORDERS_AFTER(“List”,”T”), 1, ”lipids”) > 0  or
match(ORDERS_AFTER(“List”,”T”),1, ”BMP”) > 0 or
match(ORDERS_AFTER(“List”,”T”), 1, ”CMP”) > 0 or
match(ORDERS_AFTER(“List”,”T”), 1, ”fasting glucose”) > 0 then
” Fasting required__X____    Nonfasting required_____” else ” Fasting required______    Nonfasting required__X___ ” endif}
 
 
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : June 18, 2015 6:10 am


        
            
				            
				                    
                         Forum Jump:
                        
                        
                    
								
														                        
                              Previous Topic
                            Next Topic


		
		





    
         Share:
        
        
						            
				                    
                        
                    
				            
			            
				                    
                        
                    
				            
						        
        
    
	

			        
            
                
                Forum Information
            
            
                
				                    
                        Recent Posts
				                    
                        Unread Posts
				                     Tags
            
        
        
			
			                
                    
                        
                            
                            24
                            Forums
                        
                        
                            
                            9,940
                            Topics
                        
                        
                            
                            39.9 K
                            Posts
                        
                        
                            
                            1
                            Online
                        
                        
                            
                            6,470
                            Members
                        
                    
                
			
            
                
                    
					Our newest member: Erin Kistner                
				                    
                        
						Latest Post: Register for Thrive, Austin: October 28-30, 2024 --ONE WEEK LEFT !
                    
				            

            
                
                    Forum Icons:
                     Forum contains no unread posts
                     Forum contains unread posts
                
                
                    Topic Icons:
                     Not Replied
                     Replied
                     Active
                     Hot
                     Sticky
                     Unapproved
                     Solved
                     Private
                     Closed
                
            

        
		            
                
                       Powered by wpForo version 2.4.0



	
				
                    

                        © Community Healthcare Users Group  2024  |  Contact Us

                        Twitter
Facebook
Instagram
Youtube
LinkedIn



Scroll to top