Skip to main content

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

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