You are viewing limited content. For full access, please sign in.

Question

Question

"does not equal" within query

Version 10 Workflow
Updated April 10, 2018
asked on April 10, 2018

How do I query rows that do not equal a retrieved value? 

I essentially want records where CustomList3 = a "house" token and Clientid DOES NOT EQUAL Retrieved value "Client ID)

 

Thanks!

0 0

Answer

SELECTED ANSWER
replied on April 10, 2018

Hi Amanda,

I agree with Andrew. Here is a screenshot of what this should look like.

 

 

0 0

Replies

replied on April 10, 2018

Hi Amanda,

I believe you will have to write and use a custom query to accomplish this.
(select * from your table where CustomList3 = @house and ClientID != @clientID)

You will need to format the parameters names depending on how your database is connected.
More details can be found here under the Custom Query drop down section.

~ Andrew

1 0
replied on April 10, 2018

Yes!  Thank you both, it works.  I am not good with custom queries. smiley

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...