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

Is there a way to use the LOC symbols in a text component?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

4 Users

0 Reactions

73 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

When I initially set up a text component with:

{LOC.NAME}
{LOC.ADDRESS1} {LOC.ADDRESS2}
{LOC.CITY}, {LOC.STATE} {LOC.ZIP}
{LOC.PRIMPHONE} Fax: {LOC.FAXPHONE}

It seemed to be fine, but now I get the invalid row error pretty consistently but not all the time as sometimes it still works fine.

Anyway to make sure this works every time?

Thanks in advance.

Posted : July 25, 2017 3:28 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Why do you get an invalid row? Because not assigned to a location code?

Inside a letter I just included the following logic:

{if size(PATIENT.ADDRESS2)>0 then PATIENT.ADDRESS2 else PATIENT.CITY + ", " + PATIENT.STATE + " " + PATIENT.ZIP endif}
{if size(PATIENT.ADDRESS2)>0 then PATIENT.CITY + ", " + PATIENT.STATE + " " + PATIENT.ZIP else "" endif}

I probably could have combined all into one if statement. But, would the size function help you verify valid data prior to printing?

Posted : July 25, 2017 3:51 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

I can try that, but I'm in a text component pulling LOC symbols into the update. Letter gives me no trouble. I did run across this lovely statement in the help:

"This symbol is available only for printing; you cannot use it in other places in the application or Encounter Form Editor."

Posted : July 25, 2017 4:01 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

LOC will be very hit or miss in an update since it was never intended to be used there. For my forms that display as letters, I ended up just querying the data from the database through my C# program via RUNTEXTPROCESS().

Posted : July 25, 2017 5:13 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Try this:

{DOCUMENT.LOCOFCARENAME} {find("LookupLoc","Address1","Name",DOCUMENT.LOCOFCARENAME)} {find("LookupLoc","Address2","Name",DOCUMENT.LOCOFCARENAME)} {find("LookupLoc","City","Name",DOCUMENT.LOCOFCARENAME)}, {find("LookupLoc","State","Name",DOCUMENT.LOCOFCARENAME)} {find("LookupLoc","Zip","Name",DOCUMENT.LOCOFCARENAME)} {find("LookupLoc","primPhone","Name",DOCUMENT.LOCOFCARENAME)} Fax:{find("LookupLoc","faxPhone","Name",DOCUMENT.LOCOFCARENAME)}

Posted : July 25, 2017 6:13 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Interesting, I'm somewhat familiar with the language, but roughly how can it work with Centricity if you don't mind.

Posted : July 25, 2017 6:15 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Seems to work great. Thank you. I haven't used find yet so I will definitely keep it in mind for pulling things.

Posted : July 25, 2017 6:28 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I just recently learned how to use it myself. I am not sure if there is much documentation on the tables you can use but what I did to figure this one out for you is go to my centricity folder and highlight all mldefs*.txt files and open them in notepad++. (if you don't have notepad++ you should definitely download it)

I then did a search and told it to look in all open files for "Object: Loc". I tried "Object: _Loc" and "Object: Location" first before I finally found what I was looking for. It told me that there were a few matches in mldefs8.txt. I probably could have searched for "LOCREG" which is the name of the database table that locations are in as well since it was referenced in the file.

I am not sure if there is any specific documentation on the mldefs files but if anyone knows, please let me know.

Posted : July 25, 2017 6:40 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

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 Powered by wpForo version 2.4.0