Query to Filter Data

[Todd_Rogers]

I'm trying to query multiple items based off of a column of data in the data table. The column is called DISP_NUM. Under this column there are numbers associated with pipelines. I have tried numerous different expressions. The one that validates,

DISP_NUM = 'PLA131091' AND DISP_NUM = 'PLA071625' AND DISP_NUM = 'PLA050618'

does not show any results in the drawing area.  What am I doing wrong? I have also tried to concatenate, but it returns the expression is invalid.

[Anonymous · Accepted solution]

Hi,

shouldn't it be OR and not AND?

DISP_NUM = 'PLA131091' OR DISP_NUM = 'PLA071625' OR DISP_NUM = 'PLA050618'

Rob

[kajar · Accepted solution]

You must use OR instead AND or use DISP_NUM in( 'PLA131091', 'PLA071625','PLA050618').

You created multiple condition query and there is now such kind of object which having multiple DISP_NUM values: 'PLA131091', 'PLA071625', 'PLA050618'.

Kajar