Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Rule to evaluate if a value exists in a table

Question
John Nurmi · Jan 5, 2021

Rule to evaluate if a value exists in a table

I have a operations that is writing 6 values to a table 

Class BHS.Custom.MosaiqCloudPatientsTable Extends (%Persistent, Ens.Request) [ Inheritance = right ]

 

I need to create a routing rule to evaluate a field in an hl7 ORU message ,  see if it exists in the account column of the table. If it does then allow the message to pass.

This table is not a lookup table. How can I get a function to evaluate a field to this  table?

#Business Rules #Ensemble
Product version: HealthShare 2017.2
$ZV: Cache for UNIX (IBM AIX for System Power System-64) 2017.2.2 (Build 867_4_20402U) Mon Oct 26 2020 20:07:06 EDT [HealthShare Modules:Core:15.032.9692 + Linkage Engine:15.032.9692]

Source URL:https://community.intersystems.com/post/rule-evaluate-if-value-exists-table