Question

Using LF Search to pull up multiple employee ID's all at once

Laserfiche Workflow Version 9

Updated January 18, 2017

asked on January 18, 2017

Hello,

I have a user who has an interesting question. They currently have an Excel spreadsheet that contains a list of Employee ID's. Right now their process is to go into LF Client and search for the employee ID's one by one.

What they would like to know if there is any way to use Advanced Search Syntax, or a combination of search parameters to look up all the employee ID's at once?

Thanks!

0 0

Answer

SELECTED ANSWER

replied on January 18, 2017

Miruna,

I don't think it's hundreds, and even if it was I think they could just split it up into smaller lists. This should do it! Thanks Miruna!

0 0

Replies

replied on January 18, 2017 • Show version history

Do they want to get all entries associated with all employees? or are they looking to get just the list of employee ids? You can get all entries with that field assigned by searching {[]:[Employee ID]="*"}.

0 0

replied on January 18, 2017

They are looking to get just the list of employee ID's as opposed to all entries that have the field employee ID.

Thanks!

0 0

replied on January 18, 2017

Or you could use a comma delimited list of values: {[]:[Employee ID] in ("123", "456")}

0 0

replied on January 18, 2017

Hi Miruna,

So essenitally they could do something like the following:

Employee ID List:

123

456

789

111

452

Then they could use search syntax in the following fashion if they want to search for multiple employee ID's:

{[]:[Employee ID] in ("123", "456", "789","111", "452")}

0 0

replied on January 18, 2017

Yeah. There is a limit on how long the list can be (I think), so if we're talking about hundreds of them, that might need some rework.

0 0

SELECTED ANSWER

replied on January 18, 2017

Miruna,

I don't think it's hundreds, and even if it was I think they could just split it up into smaller lists. This should do it! Thanks Miruna!

0 0

You are not allowed to follow up in this post.

Question

Question

Using LF Search to pull up multiple employee ID's all at once

Answer

Replies

Sign in to reply to this post.