Question

Advanced search for date fields doesn't seem to work correctly

Laserfiche

Updated January 18, 2017

asked on January 18, 2017

Version 9.2

I'm using the following search syntax to look for entries that have a value in the "02. Date - Manager Approved" but don't have a value in "03. Date - Entered Order". Both of these are date fields.

I know for a fact that the repository contains such entries, but using the following advanced search syntax returns nothing:

{[]:[02. Date - Manager Approved]="*"}&{[]:[03. Date - Order Entered]=""}

If I remove the second field from the advanced search, and only search for the first field using the wildcard, it works fine. But it seems the system doesn't understand the "equals empty string" criteria for date fields.

I read the Advanced Search Syntax 8.3 white paper but couldn't find anything relevant.

0 0

Replies

replied on January 18, 2017

I think this is because said entries don't have the "03. Date - Order Entered" field.

Which begs the question: how do I search for entries that don't have a specific field assigned to them? These fields aren't a part of the template, and trying to assign the date field with a blank value doesn't stick.

0 0

replied on January 18, 2017

I make no claims as to efficiency, but you can try something like

{[]:[02. Date - Manager Approved]="*"} & ({LF:Name="*"} - {[]:[03. Date - Order Entered]="*"})

(i.e. "find all entries except those with a value in this field").

0 0

You are not allowed to follow up in this post.

Question

Question

Advanced search for date fields doesn't seem to work correctly

Replies

Sign in to reply to this post.