0

Filter Conditions between 2 fields

Jet Reports Historic Posts

May 07, 2009 12:20

None

Follow

Hi there,
I understand that adding on filter conditions at the back of the NL funcion is actually using the "AND" condition.
SQL Example:
SELECT name, address FROM student WHERE contactNo="1234567" AND gender="Male";

How do i use the "OR" condition?
SQL Example:
SELECT name, address FROM student WHERE contactNo="1234567" OR gender="Male";

Thanks in advance.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 08, 2009 14:04

  Your understanding is correct.
  
  My understanding of a solution for your example is as follows (presuming 'Student' has a 'ID' field as a unique ID):
  
  D3 = nl("Filter","Student","ID","ContactNo",1234567")
  D4 = nl("Filter","Student","ID","Gender","Male")
  D5 = nl("Rows","Student",,"ID",np("Union",$D$3,$D$4))
  E5 = nf(D5,"Name")
  F5 = nf(D5,"Address")
  
  Give that a whirl.
  
  cheers, Mark