Question

null values in query criteria

Workflow

Updated September 11, 2017

asked on September 11, 2017 • Show version history

I am trying to run a basic query, based off of retrieved values for first name, last name and middle initial. However, if the client does not have a middle initial (null) then I don't get any results from my query. Is there a way to have it return results regardless if the person has a middle initial or not?

2017-09-11_8-33-45.pdf (38.45 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on September 11, 2017

Hi Amanda,

Would a Conditional Decision activity work for you? In this case, you would have two branches whose conditions are:

1. No Middle Name: Field (Middle Initial) is empty

2. Middle Name: Field (Middle Initial) is not empty

On branch #1, you would run a Query Data activity that only use the First Name and Last Name fields; on branch #2, you would run a Query Data activity that uses First Name, Middle Initial, and Last Name.

0 0

Replies

replied on September 11, 2017

That worked, thanks for the idea!

0 0

You are not allowed to follow up in this post.

Question

Question

null values in query criteria

Answer

Replies

Sign in to reply to this post.