rec.setfilter not working corect

(1) Share

Report

Posted on by ŁM-04070848-0

when I want to set up a filter in the setfilter and then find all the calls after the filter, I find nothing

CustomerRec.Reset();
if ("Phone No 1" <> '') and ("Phone No 2" <> '') then begin
CustomerRec.SetFilter("Phone No.",'*%1*|*%2*', "Phone No 1", "Phone No 2");
if CustomerRec.FindSet() then

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Netjacker2097 273 on at

Like (0)

Report

rec.setfilter not working corect

Hi,

I think this should work.

CustomerRec.Reset();
if ("Phone No 1" <> '') and ("Phone No 2" <> '') then begin
CustomerRec.SetFilter("Phone No.", '*%1*|*%2*', "Phone No 1", "Phone No 2");
if CustomerRec.FindSet() then begin
repeat
until CustomerRec.Next() = 0;
end;
end;

Thanks,

M
gdrenteria 17,518 Most Valuable Professional on at

Like (1)

Report
rec.setfilter not working corect

Hi

Please try moving the wildcard to the side of the field.

SETFILTER(name,'%1',OtherFieldValue + '*');

BR

GR