Multiple SETRANGE

jhanvincent14

hello good day. Can anyone tell how to setrange with same column with different values(3 values). I've tried this code

recBFOutputs.SETRANGE(recBFOutputs."Output Classification",recBFOutputs."Output Classification"::"Aquastar Local Orders",recBFOutputs."Output Classification"::"RK Activation",recBFOutputs."Output Classification"::"RK Feed Material");

but it gives me this error A maximum of 3 parameters must be used when calling the function

Thanks in advance

Kishorm

You need to use SETFILTER instead...

recBFOutputs.SETFILTER("Output Classification",'%1|%2|%3',
  recBFOutputs."Output Classification"::"Aquastar Local Orders",
  recBFOutputs."Output Classification"::"RK Activation",
  recBFOutputs."Output Classification"::"RK Feed Material");

Kishorm

You need to use SETFILTER instead...

recBFOutputs.SETFILTER("Output Classification",'%1|%2|%3',
  recBFOutputs."Output Classification"::"Aquastar Local Orders",
  recBFOutputs."Output Classification"::"RK Activation",
  recBFOutputs."Output Classification"::"RK Feed Material");

RockWithNAV

You need to use SETFILTER. Write the code as suggested by Kishoram and then let us know.

jhanvincent14

thanks a lot