Filter flowfield

zac

Hi folks,
when I would like to filter a flowfield, do I use SETFILTER or SETRANGE?
For example, I would like to get a value from the Field1 depending to the Filed2 which is the flowfiled.

i4tost

same as for any other field. Both are valid

jversusj

just be sure you do a CALCFIELD first or you won't have a value to filter!

zac

Tnx guys!

kriki

jversusj wrote:

just be sure you do a CALCFIELD first or you won't have a value to filter!

This is not correct. The CALCFIELDS serves to calculate the value of flowfields in the CURRENT record. It does not serve for filtering.
E.g. for filtering on flowfields: Select all items with an inventory

recItem.RESET;
recItem.SETCURRENTKEY("No.");
recItem.SETFILTER(Inventory,'>0'); // Inventory is a flowfield
IF recItem.FINDSET THEN
  REPEAT
    // Now you have a record with inventory > 0
    MESSAGE('Item "%1" has a positive inventory',recItem."No.");

    // if you want to know the value of recItem.inventory, you need to do a CALCFIELDS
    recItem.CALCFIELDS(Inventory);
    MESSAGE('Item "%1" has an inventory of %2 ',recItem."No.",recItem.Inventory);
  UNTIL recItem.NEXT = 0;

navuser1

hi Kriki,

Please help to solve the below line of filtration..

RecVar.SETFILTER("User ID",'%1','USERID'); //"User ID" is FlowField

zohaibu95@hotmail.com

Before using SETFILTER make sure to use CALCFIELDS("YOUR FLOW FIELD");
Other then that rest of the stuff will be same.

rehansatti

It is always a good habit to user CLEAR before applying any filter. You always knows what filter are applied.

Kishorm

zohaibu95 wrote: »

Before using SETFILTER make sure to use CALCFIELDS("YOUR FLOW FIELD");
Other then that rest of the stuff will be same.

As @kriki has already stated above - you do not need to do a CALCFIELDS prior to setting a filter on a Flow Field

zohaibu95@hotmail.com

Kishorm wrote: »

zohaibu95 wrote: »

Before using SETFILTER make sure to use CALCFIELDS("YOUR FLOW FIELD");
Other then that rest of the stuff will be same.

As @kriki has already stated above - you do not need to do a CALCFIELDS prior to setting a filter on a Flow Field

Oh okay thanks.