using Rec.Setview and Rec.SetRange

(0) Share

Report

Posted on by benovic

350

I am trying to find the right order here. I am using Rec.Setrange to exclude Blocked items, and also want to use item.setview to allow the user to use aditional filters.

it seems to me that setview is reversing prior setrange calls?

what is the right order here?

Items.SetView(MyConfigTable.ItemView); // Set filter from Text input

Items.SetRange(Blocked, false); // always exclude blocked items

Items.SetRange("Purchasing Blocked", false); // always exclude blocked items

Items.SetRange(Blocked, false); // always exclude blocked items

Items.SetRange("Purchasing Blocked", false); // always exclude blocked items

Items.SetView(MyConfigTable.ItemView); // Set filter from Text input

Bonus:

how, and should
Items.SetFilter(Blocked, '%1', false);
be used here?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 81,256 Super User 2025 Season 1 on at

Like (1)

Report

RE: using Rec.Setview and Rec.SetRange

Hi, the following are two usage examples that hopefully give you some hints.

https://yzhums.com/21004/

https://yzhums.com/21007/

Thanks.

ZHU
benovic 350 on at

Like (1)

Report

RE: using Rec.Setview and Rec.SetRange

Thank you Inge!

Also note to readers, check that you have "SetTableView()" AFTER Setrange and Setview, otherwise nothing works ;)
Suggested answer

Inge M. Bruvik 1,011 Moderator on at

Like (1)

Report

RE: using Rec.Setview and Rec.SetRange

You can not use Setview if you want to retain the filters you have set before you use setview.

Setview will replace any prior filters you have set.

So the correct order will be A.