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 Sort() Function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

70 Views

RSS

Sevin

(@sevin)

Posts: 13

Eminent Member

Topic starter

How does the Sort() function work in VFE? I can not find any documentation for most of the commands in VFE, so I am trying to learn how they work. Thanks!

Posted : June 20, 2016 6:10 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Sort and many of the other functions I think you are looking for are not VFE specific, but rather Centricity specific. You'll want to search for them in the Centricity Help Text, not the VFE Help Text. Please see the attached screenshot for the Sort function to see what I mean.

Posted : June 20, 2016 6:41 am

Sevin

(@sevin)

Posts: 13

Eminent Member

Topic starter

Thank you so much!

Posted : June 20, 2016 10:25 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Two things to remember when using sort:

1) While the sort is alphanumeric, it does a poor job with case. All upper case items will appear in the list first followed by lower case items.

Example:

List to sort:

Apple, banana, Orange, pear

Result:

Apple, Orange, banana, pear

If you are dealing with mixed case items, it can be a bit of a nuggle to contend with.

2) Proper dates are not sorted correctly. To sort dates, you must convert them to YYYYMMDD format, sort, then return them to MM/DD/YYYY (if needed).

Hope this helps!

Posted : June 20, 2016 11:46 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Centricity MEL SORT fn and what it does:

For a reference, I used this ASCII Table: http://web.cs.mun.ca/~michael/c/ascii-table.html

MEL SORT fn does an ASCII sort. Look at an ASCII Table which lists characters in ascending order (ASC) by their numeric value.
this is the order for an ASC sort:
space,!,",#,$,%,&,',(,),*,+,comma,-,.,/
0 through 9
:,;,,?,@
A through Z
[,\,],^,_,`
a through z
{,|,},~

Example 1: ("Ba,BZ") will sort as:
BZ
Ba

Lists that contain ", " as well as "," for separators will sort weird (as spaces have higher sort order than alpha chars)
Example 2: ", Yitem,Aitem, Zitem" will sort as:
Yitem
Zitem
Aitem
- Beverly

Posted : June 21, 2016 1:32 pm

dnlustig

(@dnlustig)

Posts: 56

Trusted Member

The biggest issue I found with the sort is that it only sorts one item. For example, date. If you want to sort, say, immunizations by vaccine and date - can't do that out of the box. It's kind of like the capitalization and date issue Lee brings up.

Here's an answer:

Build yourself an array with a your own index of sort items as the first column. The index might be left(lower(vaccine_name) + " ", 16) + YYYYMMDD

Then you just use your data from column 2 on after your sort...

Sneaky, but effective!

Posted : June 27, 2016 11:49 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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