skip record at export

gmorken

Hello,
I want to export No. , Description, Inventory from Item-table.
But I want to skip the record if Inventory-field = 0;
I have coded this:

OnBeforeExportRecord()
MESSAGE(FORMAT(Item.Inventory));
Item.CALCFIELDS(Inventory);
IF (Item.Inventory <= 0) THEN
CurrDataport.SKIP;

This doesnt work! What is the problem. The flowfield?

Regards
Tomas

ara3n

Onpredataitem add the following code

Item - OnPreDataItem()
Item.SETFILTER(Inventory,'>0');

teckpoh

you can code in onAfterGetRecord trigger as below:

if item.inventory > 0 then
currDataport.skip

BUT what ara3n suggest is better coz it's save the system load time.

gmorken

ok thanks.
But I must include CALCFIELDS because of the flowfield right?

JoeK

gmorken wrote:

ok thanks.
But I must include CALCFIELDS because of the flowfield right?

Yes that´s right...

Alex_Chow

teckpoh wrote:

you can code in onAfterGetRecord trigger as below:

if item.inventory > 0 then
currDataport.skip

BUT what ara3n suggest is better coz it's save the system load time.

There's no OnAfterGetRecord trigger on dataports.

Alex_Chow

gmorken wrote:

Hello,
I want to export No. , Description, Inventory from Item-table.
But I want to skip the record if Inventory-field = 0;
I have coded this:

OnBeforeExportRecord()
MESSAGE(FORMAT(Item.Inventory));
Item.CALCFIELDS(Inventory);
IF (Item.Inventory <= 0) THEN
CurrDataport.SKIP;

This doesnt work! What is the problem. The flowfield?

Regards
Tomas

Your code seems fine. One thing is that is your dataitem called "Item"? Are you calling the Item variable from antoerh dataitem? If so, did you GET the Item?

nasheer

If your main DataItem is 'Item' in the Dataport designer,
you can add the Table filter in the 'DataItemTableView' property of the
DataItem.

Ex. 'DataItemTableView' = WHERE(Inventory=FILTER(<>0)).

The Dataport skips the records if Inventory field equal to 0.