db.search & wildcard character & lotusscript

Question

I am doing db.search and I would like search in such a way that any status ( field here ) would come into the result, so I want to use Wildcard "*", can anyone please help me here

below should work ?

@contains(Status;"*") 

Thanks

Answer 1

If you want to find any non-empty status, you don't need any wildcarding. Just use this:

Status <> ""

If all you care about is existence of the Status field, whether it's filled in or empty, you can use

@IsAvailable(Status)