AnsweredAssumed Answered

Perform Find Script

Question asked by Annette on Oct 23, 2012
Latest reply on Oct 23, 2012 by Sorbsbuster

Title

Perform Find Script

Post

      Hey all,

     I'm trying to create a script to run in a report but unsure how to add one particular step.  Basically I have the following fields I am working with: 

         
  •           Accepted Date:
  •      
  •           Pending Date:
  •      
  •           Ineligible Date:
  •      
  •           Discharge Date:
  •      
  •           Referral Type:
  •      
  •           MDT Date:

     Originally I didn't have the pending field so my script was very simple (to me) .  What I was trying to do was find EIT referrals that were accepted but have not been discharged or found ineligible yet and hadn't had an MDT Date yet.  So my find looked like this:

         
  •           ReferralType = "EIT"
  •      
  •           AND Ineligible Date =
  •      
  •           AND Discharge Date =
  •      
  •           AND Accepted Date = *
  •      
  •           AND MDT Date =

     That worked fine.  BUT, now I have to take another option into consideration.  I have to add where there is an Accepted Date OR a Pending Date....then all the other options I had.  I'm just not sure how to add that OR piece in the Perform find / Script area.  Is this something simple that I'm missing and overthinking? 

      

      

Outcomes