Filter across two fields

shahidt

Hi - Is it possible to filter a Table across two Fields in C/AL? How?

I would like to do something like:

Table.SETFILTER(Where Field001 = X OR Where Field002 = X)

mohana_cse06

Give more details of your requirement.

Belias

shahidt wrote:

Hi - Is it possible to filter a Table across two Fields in C/AL? How?

I would like to do something like:

Table.SETFILTER(Where Field001 = X OR Where Field002 = X)

Not out of the box, you need some workaround with temptables, marked only or additional fields, depending on your business requirement. search the forum for "filter two fields" or similar...it has been already been asked (and answered) a lot of times
btw: althought it is an option, i wouldn't go for MARKEDONLY solution, it can cause performance problems.

shahidt

Thanks for the search term. Guess I need to refine my searching skills further. Found the solution.