You are viewing limited content. For full access, please sign in.

Question

Question

Advanced search for empty date field

Workflow Laserfiche Version 9 Search and Retrieval
Updated July 22, 2020
asked on July 9, 2015

hi would to find out how one could put together an Advanced search that will find entries with a "Date" field that has not yet been set?

I want to put a process together that will search for Entries in the system based on specific criteria, one of the criteria is the entry's specified Date field has not been captured yet, ie still blank/empty.

I have tried

{[Template Name]:[Field Name] = ""}

But this does not return any of the results I know exist. 

 

0 0

Replies

replied on July 10, 2015

Hi Derek,

thank you for the reply. Leaving the Template off would not have worked in our case as simalar fields are on other templates but I wish to exclude them. I figured out my problem though. my original search works. 

the issue is that the defined date field, is a new field on the template. The field property had not applied itself to all the entries on that template in the DB, so the results was false. now that it is properly update, the search works just fine.

1 0
replied on July 22, 2020

How did you update the property of the date field? Did you just wait for SQL to update itself?

0 0
replied on July 9, 2015

I would go across the fields and eliminate the template search. {[]:[Field Name]=""} this returned all my entries that did not have anything in that field.

0 0
replied on July 10, 2015

Great, good to know

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...