query setfilter

cavalcanti_space

Hello folks,

I'am trying to create a query , but the filters dont work. I get an error ( the left side of the criteria cannot be empty.)

Does anyone know how I can have the same filters as my table filters just below?

Cheers,

Edson

CustSalesPriceQuery.SETFILTER(Starting_Date, '0D|..pSalesHeader."Order Date"');
CustSalesPriceQuery.SETFILTER(Ship_to_Code, '''|pSalesHeader."Ship-to Code"');

lrecSalesPrices.SETFILTER("Ship-to Code",'%1|%2','',pSalesHeader."Ship-to Code")
lrecSalesPrices.SETFILTER(lrecSalesPrices."Starting Date",'%1|..%2',0D,pSalesHeader."Order Date");

Big_D

Hi Edison

When you say query you mean a C/AL query or a RTC query?

If a C/AL Query

CustSalesPriceQuery.SETFILTER(Starting_Date, '%1|%2', , 0D, pSalesHeader."Order Date"');
CustSalesPriceQuery.SETFILTER(Ship_to_Code, '%1|%2', ''', pSalesHeader."Ship-to Code"');

Hope this helps