Skip to main content
Solved

Can we Use Expression to filter the result

  • May 15, 2025
  • 1 reply
  • 18 views

Forum|alt.badge.img+1

Hallo,,

 

Can we easily applied / use Expression on the column table that will filter the result?

Example: 

      Status has Yes/No value, but you want to display only Yes

on status column table can we use expression calculated field  t1.status = Yes?

or create a virtual column to add expression?

 

The result will only display all status that has Yes value.

I'm using table not view table.

 

any other way to filter the result without using view table. 

 

Thank you in advance

Best answer by Renée Evertzen

Hello ​@Jheng ,

For this purpose you can use the prefilters. They can be found in the Software Factory through the menu group User Interface > Subjects > Data  > Prefilters.

This can be either a prefilter that uses the Table prefilter as the Prefilter type. In that case you can specify the column that contains the Yes/No value in the tab page Prefilter columns and specify the condition as Equal to: Yes. Or you can select the Prefilter type Query, and just write your conditions there.

Hope this helps 😊

Kind regards,

Renée

View original
Did this topic help you find an answer to your question?

1 reply

Renée Evertzen
Moderator
Forum|alt.badge.img+4

Hello ​@Jheng ,

For this purpose you can use the prefilters. They can be found in the Software Factory through the menu group User Interface > Subjects > Data  > Prefilters.

This can be either a prefilter that uses the Table prefilter as the Prefilter type. In that case you can specify the column that contains the Yes/No value in the tab page Prefilter columns and specify the condition as Equal to: Yes. Or you can select the Prefilter type Query, and just write your conditions there.

Hope this helps 😊

Kind regards,

Renée


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings