15
Views
1
Comments
Solved
question of filter
Question

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!

2018-10-29 08-31-03
João Marques
 
MVP
Solution

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.


Cheers,

João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.