Using $EXTRACT function in routing rule

Primary tabs

Martin Browne 28 January 2020

Business Rules, ObjectScript, HealthShare

Hi,

I'm attempting to use the $EXTRACT function in my routing rule but I'm seeing 'Expression Parsing' error messages when trying to save the rule.

I want to check the last character of a post code by using the following code:

$EXTRACT(HL7.{PID:PatientAddress(1).ziporpostalcode},*)="Z"

Could anyone assist with this?

Thanks,

Martin

Replies

Reply by Enrico Parisi 28 January 2020

Hi Martin,

whenever you have a "special need" (not saying that $e() is special...but..) in rules or DTL, you can create a Custom Utility Function, see:

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?K...

Get back if any problem arise writing the function.

HTH

Enrico

0 0

Accepted Answer

Reply by Martin Browne 28 January 2020

Thanks Enrico,

I've written the custom function...

ClassMethod PostCodeLastCharacter(PID11 As %String)
{
Set ReturnValue = 0

if ($EXTRACT(PID11,*) = "Z")

{set ReturnValue = 1 }

Quit ReturnValue

}

I've added a trace to my rule which returns the relevant 1 or 0 (depending on the post code). However, my rule condition which references the function doesn't trigger an message...

PostCodeLastCharacter(HL7.{PID:11(1).5}=1)

Have I got the syntax correct?

0 0

Reply by Enrico Parisi 28 January 2020

I think you mistyped, the condition should be:

PostCodeLastCharacter(HL7.{PID:11(1).5})=1

Enrico

0 0

Reply by Martin Browne 29 January 2020

Thanks for the help Enrico. It's working perfectly now.

Martin

0 0