Question

Using Laserfiche Web Access Search to search multi values using one field

Web Client Laserfiche Search and Retrieval

Updated March 26, 2014

asked on March 26, 2014

I'm trying to pull up multiple document numbers for my template using 1 field? is that possible.

Template name is Resolutions and Ordiances

I'm trying to use the "Document #" filed to retrieve to record at the same time

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #]="92-35, 92-36 = No records return

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #]="92-35"} 1 Record return.

Is it possible to do both records at the same time.

laserfiche.png (15.37 KB)

| Download

0 0

Answer

APPROVED ANSWER

replied on March 26, 2014 • Show version history

You can do OR logic with

{[Resolutions and Ordinances]:[Document #] in ("92-35", "92-36")}

This lets you provide a list of possible values for a field. It does also work with the multiple-field syntax:

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #] in ("92-35", "92-36")}

1 0

Replies

replied on March 26, 2014

Now I'm able to get more creative for the user to get range of documents using wildcard also.

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #] in ("92-3[1-4]", "92-3*", "92-[1-5]8", "2014-1*")}

I like Laserfiche more everyday.

1 0

replied on March 26, 2014

Hello Ivan,

One way that you can retrieve multiple documents is by modifying the search with "*" sign at the end. That will basically give you all the resolutions starting 92-30 - 92-39. I will also look into putting in an OR condition to see if that works.

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #]="92-3*"}

0 0

replied on March 26, 2014

Thanks Jain,

The problem with that idea is that not all records fall in the 92-3* document id some will be in 94-3*. Trying to figure out a syntax where I can pull up both records in the same search windows so then I can export the information to CSV file with all the metadata for a user.

0 0

replied on March 26, 2014

Here is the Syntax for multiple exact resolution number custom search:

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #]="92-35"} | {[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #]="92-36"}

0 0

replied on March 26, 2014

Thanks Andrew!

It worked it's exactly what I need to give our user to create his report..

0 0

replied on March 26, 2014

Now I can get creative with my search query.

{[Resolutions and Ordinances]:[Document Type]="Council Resolutions", [Document #] in ("92-3[1-4]", "92-3*", "92-[1-5]8", "2014-1*")}

0 0

You are not allowed to follow up in this post.

Question

Question

Using Laserfiche Web Access Search to search multi values using one field

Answer

Replies

Sign in to reply to this post.