Question

Getting all values of multi-value fields for search results

Workflow

Updated June 28, 2017

asked on June 27, 2017 • Show version history

I am querying Laserfiche, obtaining results, and saving to a csv file. My issue is that my multi-value fields (highlighted in yellow) only return the first value. How do I get my searches to return all values for the multi-value fields so it can be used when I write the report (I know I can use Index but it's greyed out right now)?

Token Info:

Metadata info:

1 0

Answer

SELECTED ANSWER

replied on June 28, 2017

The entry listing returned by Search Repository/Find Entries/Find Entry does not support returning all values in a multi-value field. You need to run Retrieve Field Values in For Each Entry to get the individual document's fields.

2 0

replied on June 28, 2017

Thanks. Worked once I added the two items in yellow.

0 0

replied on June 28, 2017 • Show version history

Glad Miruna's solution worked for you!

I would still recommend moving away from using "Search Repository" unless it is absolutely necessary to narrow your search.

Find Entries is always the better choice if you're just targeting documents, folders, etc. in a specific folder without additional parameters.

1 0

Replies

replied on June 28, 2017 • Show version history

When configuring the fields you return in your search results, there should be a column next to the field type that determines which values are return for multi-value tokens.

Then, if you want to put all of the values into a single field of the spreadsheet/csv, you would use the token editor, check the "Apply Index" option, select "All values separated by" and choose your delimiter.

NOTE: You can type in any custom delimiter so you're not limited by the predefined options, but if you're using CSV you would probably need to avoid using a comma.

0 0

replied on June 28, 2017

Nope, this is my screen shot:

0 0

replied on June 28, 2017 • Show version history

You're right. It looks like that option is not available for fields when using the "Search Repository" activity. You would need to add another Retrieve Field Values activity to grab the multi-value field in the "For Each" loop.

On a side note, you really should be using Find Entries instead of "Search Repository" because your parameters don't have anything that's not supported by Find Entries; the searches always seem to run slower and cause poorer workflow performance.

1 0

replied on June 28, 2017

Miruna actually answered this one before I did. I still had some incorrect information in the original version of this post.

0 0

replied on June 28, 2017

Thanks ... trying Miruna's recommendation.

0 0

You are not allowed to follow up in this post.

Question

Question

Getting all values of multi-value fields for search results

Answer

Replies

Sign in to reply to this post.