Filter Expression Property on Form FormStringControl

(1) Share

Report

Posted on by Manish1607

Can someone shade light on how exactly we can use "Filter Expression" property on FormStringControl ? As per property description on bottom of screenshot, it seems property allows complex filter expressions.

I tried few different combinations for example

"FIN*" -- To show only Itemgroups starting with FIN
(ItemGroupId like "FIN*")
= Fin*

None of above seem to be working. I know I could write few lines of code to add Range on column value and achieve the filtration but if possible i would like to configure values here instead of creating another EventHandler for trivial task like this.

0777.Untitled.jpg

All responses (1)

Answers (1)

Verified answer

huijij 19,811 on at

Like (0)

Report

RE: Filter Expression Property on Form FormStringControl

Hi Manish1607,

For common string field filtering, you should provide the data source to be filtered in "FilterDatasource", "FilterField" is the data source field to be filtered and "FilterExpression" is what we enter in the filter box and you can not fill in complex filter expressions in the field.