【Query Builder：Expression】Try using IsYes statement

This time, I will use the IsYes statement from among the many sharperlight expressions.
Launch the Query Builder from the Sharperlight application menu.
Set the filter settings as shown below and prepare a custom dataset.

A preview returns a dataset like this.

Now let's write the IsYes statement.
Right-click in the output area and select Add Expression.
When the Output Options dialog opens, select Functions -> Data Types -> IsYes from the Functions list.
You can transfer its template to the editor area by double-clicking it.

You can also search the statement in the list by typing a keyword in the Find box.

Let's validate the value of the Status field.

Change the Description of the added Expression like this.

Preview now! !
If the value of the Status field is Y, return True, otherwise return False.

I hope this will help your work.