Filter Condition

[#1]

Hi,

I need to handle the below filter condition so that data gets refreshed in a single click.

= '=TEST_CASE_STATUS=' & chr(39) & 'Testing Evidence' & chr(39) & 'AND TEST_EXPIRATION_DT1=' & TIMESTAMP(TODAY())

Right now, I have mentioned this in Button but as there is no data that matches this filter condition, nothing happens when the button is clicked and the whole data set appears; ideally no data should be listed as nothing fits in this filter condition.  Please let me know if there is any other way to specify this condition. (Please check the syntax too)

Thanks,

Sudha.

[robert_mika]

Could you share your app?

[#3]

Sorry, I can't find an option to attach here...

Here is the snapshot -

Here if I click on Test button, nothing should be displayed because my data does not have 'E'; instead, nothing happens when the button is clicked and all data still appears.  Hope this helps.

[MarcoWedel]

Hi,

one solution could be:

='=TEST_CASE_STATUS = ''Testing Evidence'' and TEST_EXPIRATION_DT1 = TODAY()'

hope this helps

regards

Marco