SMATDB Searching for Null Values

[Greg Tataryn]

I have only recently started using 6.1.1 with the SMATDB option and am trying to see when searching if there is a way to search for a field being blank/null/empty? I’d like to be able to do a search along the lines of MSH.9=A08 and PV1.45=null

I have tried using ” or “” or {} and even null and just leaving it blank with no luck.

Topic

[John Mercogliano]

Greg, I have found that [^$] has given me good results when looking for an empty field.

This should give you what you need.

Code:

PV1.45=[^$] and MSH.9.2=A08

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Greg Tataryn]

Spoke with some Infor resources today that happened to be on site and it sounds like without using the breakdown to regular expressions there is no real way to search for null values currently but it sounds like it has been requested and may well be coming in future releases/patches.

[vdurst]

In case anyone is interested, here is what works for us:

Say you wanted to find where PID.7 is null –don’t let the numbering in code below fool you 😉

(r)?+pid(|[^|]*){6}||

[Author]

Replies