(SETFILTER) OR (SETILTER) possible ?

KAD

I would like to combine record level Filter by OR Statements, so i can get all Records that satisfy any of the following statements

SETFILTER(No.,myDocno)
OR SETFILTER(Customer Quote No.,myQuoteNo)
OR SETFILTER("Customer Order No.",myOrderNo)

if written in SQL it would look something like this:

Select From ...WHERE ("No."=?) OR ("Customer Quote No."=?") OR "Customer Order No."=?);

Is it possible without temporary tables or SQL-Views/Stored procedures ? ](*,)

garak

Yes it is possible.

Table.SETFILTER("No.",myDocno);
if Table.findset (Table.find('-')) then begin
  repeat
    Table.mark(true);
  until Table.next = 0;
end;

Table.setrange("No.");
Table.SETFILTER("Customer Quote No.",myQuoteNo);
if Table.findset (Table.find('-')) then begin
  repeat
    Table.mark(true);
  until Table.next = 0;
end;

Table.SETRange("Customer Quote No.");
Table.SETFILTER("Customer Order No.",myOrderNo);
if Table.findset (Table.find('-')) then begin
  repeat
    Table.mark(true);
  until Table.next = 0;
end;
Table.SETRange("Customer Order No.");
Table.markedonly(true);
form.runmodal(Form::XYZ,Table);

@ALL
I've got the feeling, that the SQL not like mark. (Performance)

Regards
Garak

kine

Search the forum, many posts about OR between fields filters... :-)