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

I have the same question (0)

All responses (2)

Answers (0)

Gerardo Rentería Ga... 25,388 Most Valuable Professional on at

Like (1)

Report
Hi

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

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

BR

GR

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report

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

Was this reply helpful? Yes No