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

Question

Question

No Value Field Searching?

asked on April 14, 2016

Using LF 10, I would like to perform a field search using a wilcard (*) on every field:

ADDRESS: *

BLOCK: *

LOT: *

QUALIFIER: *

I can't use a template search because I have different templates on documents which contain most of the same fields.

Issue is, not all of the fields are populated with values, so when performing a search like:

ADDRESS: 123 MAIN ST

BLOCK: *

LOT: * 

QUALIFIER: *

I receive no results if the actual template field data looks like this (with QUALIFIER having no value in the field): 

 ADDRESS: 123 MAIN ST

BLOCK: 20

LOT: 3

QUALIFIER: 

 

I would like "*" to find fields which contain no values... is this possible? Is there another search I could use to workaround this? 

 

Thanks.

Replies

replied on April 14, 2016 Show version history

You would have to do an OR search in the advanced search syntax:

So for Address it would be {[]:[Address]="*"} | {[]:[Address]=""}

This is searching the Address field for a * OR nothing

If you just want to find empty values you can put a space character in the field instead of a *.

replied on April 14, 2016

Is there anyway to search "*" or "no value" in a field search using the regular search and not advanced? This is for production users.

replied on April 14, 2016

Hi Ali, 

No there isn't, although you could create a custom quick search or saved search to make it simpler. 

Can you provide some information on what the scenario is where the users need to regularly make this search? It sounds like their just looking for all documents that have a specific field assigned to it in the first place - what's the business case for this? 

replied on April 14, 2016

Hey Justin,

 

Basically, the users want to have (4) fields to search from -- ADDRESS, BLOCK, LOT and QUALIFIER. The ADDRESS field is always filled out (don't ask me why they don't just search on ADDRESS explicitly). So, if they search on "184 CUTTER AVE", they want all results shown even if some of the fields are empty -- which is the issue, because some are actually empty. See screenshot. 

wb11a.png
wb11a.png (42.83 KB)
replied on April 14, 2016

Hrm, is the main goal specifically to have the other columns show up in the search results? The upcoming Web Access 10.1 allows users to specific a column profile as part of their search, as well as assigning one to a shared search. So you could have a column profile that includes all of these fields and then they always show, even if the user doesn't include them in the search. 

If the main goal is simply to be able to provide all 4 fields to the user, you could do that by displaying all 4 as a field search in the UI as a saved search - if the user doesn't care about a particular one, they can close it and then reload the saved search each time. 

replied on April 15, 2016

Justin,

Bottom line is, they want the individual Field(s) search to produce the same results a Template search would. In their mind, its the same exact search, but produces two totally different results...   

wb11b.png
wb11c.png
wb11b.png (28.31 KB)
wb11c.png (34.72 KB)
replied on April 18, 2016

Justin,

Are we correct in the way these searches function?

Also, were the multiple Field search restrictions the same in Laserfiche 9 (as our customer is using Laserfiche 10)? 

Please let me know ASAP.

Thanks,

Ali

replied on April 18, 2016 Show version history

This is unchanged between Laserfiche 9 and 10. I believe this has been the behavior of the field specific search since it was introduced in version 8. 

replied on April 18, 2016

Thanks Justin... any chance this gets changed in future versions? 

replied on April 19, 2016

Hi Ali,

We're always looking to be responsive to customer requests. That said, it'd help if we had more specifics as to why it has to be changed in this manner beyond 'the customer insists on doing that' especially when - as you noted - it doesn't seem like they necessarily have to. That's not intended to be sarcastic, we just need to always judge the possibility of changes to existing functionality adversly impacting other customers who are already relying on the current functoinality (that's certainly happened in the past) so I want to ensure such changes are neccessary. 

replied on April 27, 2016

Justin,

I have confirmed that the FIELD search functions differently in WebAccess v9 than v10.  So it now seems that we have lost individual FIELD search functionality after upgrading our customer from WebAccess v9 to v10. Retaining this FIELD search functionally is imperative to all of our NJ municipality customers as they rely heavily on block/lot searches regardless if certain fields are left blank. Here are screenshots of an individual FIELD search in both WebAcess v9.2.1.673 and v10.0.0.994 with different results:

 

6 documents in the v10 repository with the following field info...

 

 

Searching for block "7" in a FIELD(s) search produces NO RESULTS...

 

 

Same 6 documents in a v9 repository with the same field info... 

 

Searching for block "7" in a FIELD(s) search produces 5 documents (as it should)...

 

 

Please let me know how we can resolve this issue ASAP.

Thanks,

Ali

You are not allowed to follow up in this post.