Filter Field1 OR Field2

Joeri Member Posts: 75

2006-12-22 edited 2007-01-02 in NAV/Navision Classic Client

Hi,

Is it possible to make a filter that does:
Filter((Field1 = 'value') OR (Field2 = 'value'))

Like a WHERE clause in SQL
( select * from tabel where col1 = value or col2 = value )

0

Comments

• 

  Rko Member Posts: 24

  2006-12-22

  Hi,
  According my knowledge of navision is not possible to do that simple way, you have to use repeat function and check entries if they match with your filters.
  
  Rko

  Navision Developer and Consultant

  0
• 

  kine Member Posts: 12,562

  2007-01-02

  Search the forum, there are big thread sbout that...
  
  for example: http://www.mibuso.com/forum/viewtopic.php?t=13671

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  0