Question

Select all files where Field A = Field B from another file

Search and Retrieval Laserfiche

Updated May 9, 2018

asked on May 7, 2018

Hi all,

In Laserfiche, under the folder "Files", I have a lot files with "Field A"

Examples

FileA => Field A = 1

FileB => Field A = 2

FileC => Field A = 3

FileD => Field A = 4

Then I have another file under the folder "Recap" (called "recap.pdf") with a multi-value "Field B"

Example

Recap.pdf => Field B = 1;4

In my search bar, how can I find all files where "Field A" is in the "Recap.pdf's Field B List"

Example :

FileA => OK

FileB => NOK

FileC => NOK

FileD => OK

Thanks in advance.

Regards

0 0

Answer

SELECTED ANSWER

replied on May 9, 2018

Brian,

I took the problem upside down ; I found how to do!

1. Recup all values in the field B,

2. Make a loop for each value,

3. Search file with the actually loop's value.

then do what I want.

2 0

Replies

replied on May 7, 2018

I tried this but unsuccess

{[metadata1]:[Field A]=[RECAP]:[Field B]}

0 0

replied on May 8, 2018

The fields in a search query can't refer to different documents. A search query is a set of criteria that are evaluated against each entry, and if they evaluate to true, that entry is included in the search results. You need to replace the reference to the second document with the values of its field.

0 0

replied on May 9, 2018

Hi Brian, this is the difficulty! The value is variable.

In my example, the B's values is 1;4.

Tomorrow it can be 1;2 or 1;3 or 1;4 or 1;2;3....

0 0

SELECTED ANSWER

replied on May 9, 2018

Brian,

I took the problem upside down ; I found how to do!

1. Recup all values in the field B,

2. Make a loop for each value,

3. Search file with the actually loop's value.

then do what I want.

2 0

You are not allowed to follow up in this post.

Question

Question

Select all files where Field A = Field B from another file

Answer

Replies

Sign in to reply to this post.