HI everyone,

I want to filter the PC No, below is my data

I have add a SPCNO as a local variable, but when i set the filter SPCNo=NullIdentifier()..

No  data are showing, isn't it suppose to show the data as above?

Thank you!


Hi Eva,

You're trying to filter a text field so your variable should be of the type Text the filter should be SPCNo = "" or SPCNO = PCNo.

In this way, no filter will be applied if your variable is empty, and if it is it will filter on the PCNo column.