AnsweredAssumed Answered

Selecting records that contain a particular piece of text

Question asked by skbarksy on Feb 8, 2018
Latest reply on Feb 14, 2018 by skbarksy

Hi there -

 

I'm trying to create a script such that if certain text is in field 1, a particular text will be inserted into field 2. To select the text in field 1, I've come up with the below; although, the line just generates an error message - "the specified table cannot be found." I selected the table from the list, and I cant find anything wrong with that table (misspelling not withstanding.) I can't figure out for the life of me why I'm getting the error.

 

If [ Not is Empty ( Filtervalues ( Identification::Diangostic Entity; "thyroid" ) ) ]

 

So my questions would be: will this function retrieve records containing the word "thyroid" from the field specified, and do I have the command written correctly?

 

Many thanks in advance for any insight. My knowledge of coding is very low, so very basic answers will be much appreciated.

 

Cheers - Sarah

Outcomes