How to set filter on boolean record to both true and false?!

danielbouwmeester

I made a table in which I have a boolean field. Also, I made a form for this table on which I want to put three buttons. One to filter the records by the boolean variable field: value = TRUE, one to filter the records by the boolean variable field: value = FALSE. But also I want to put one button on the form to show all the records.
Therefore I created an Global Variable 'filterLabelCustSpecific' of the type 'Boolean'. And then I give the variable a value, based on the button which is pushed. But what value do I give the variable to show all the records, in other words: I want to show the records with value TRUE, but also value FALSE...
I don't know how to do this. Can someone help me out? Thanks in advance!

Albertvh

Create one variable as an Option and set the OptionString to False,True,All and then in the OnValidate check the value of the variable.

SETRANGE(Boolean Field); // This will clear the filter
IF Variable = Variable::False THEN
SETRANGE(Boolean Field,FALSE)
ELSE
IF Variable = Variable::True THEN
SETRANGE(Boolean Field,TRUE);


Hope this helps.

Albert

Albertvh

Create one variable as an Option and set the OptionString to False,True,All and then in the OnValidate check the value of the variable.

SETRANGE(Boolean Field); // This will clear the filter
IF Variable = Variable::False THEN
SETRANGE(Boolean Field,FALSE)
ELSE
IF Variable = Variable::True THEN
SETRANGE(Boolean Field,TRUE);


Hope this helps.

Albert

danielbouwmeester

Thank you very much Albert! It works perfectly!

RockWithNAV

@danielbouwmeester - Just thinking if it's Boolean and you want to give both TRUE and FALSE in filter then why to even entertain this in Filter??