Question

Workflow Search Syntax

Workflow

Updated December 19, 2017

asked on December 19, 2017

I am utilizing workflow to migrate entries to new volumes and I am running into an issue. When I perform my normal search it will find all documents and folder but when I add the syntax to look for any that are not in a specific volume then it only yields results of folders. Which is an issue because when it starts migrating it does all the folders and documents which is a large amount. I want to limit my number of items to migrate at one time.

My current syntax is - ({LF:VolId<>"149"}) & {LF:LOOKIN="folder path"}

I have tried to edit this to say look in subfolders and also look for folders and documents but still the same result of only the main folders in this path when I incorporate the volume. Will the search syntax of volume ID only work on folders?

Suggestions?

0 0

Answer

SELECTED ANSWER

replied on December 19, 2017

Try turning it around.

{LF:LOOKIN="folder path"}-{LF:VolId="149"}

This search has me puzzled because it returns shortcuts on volume 149. I added a little more kung fu to exclude shortcuts.

{LF:Name="*", Type="DF"}&
{LF:LOOKIN="path"}
-{LF:VolId="149"}

0 0

replied on December 19, 2017

So this is what I have now and it is now finding all items in that folder path but not excluding the volume 149

{LF:LOOKIN="folder path"} - {LF:VolId<>"149"}

which the - and the <> must be a double negative because I yielded about 500,000 in items which I know is not correct. So then I tried

{LF:Name="*", Type="DF"}&
{LF:LOOKIN="folder path"}
-{LF:VolId="149"}

and that did work yielding my correct number of entries. Thanks for the help!!

1 0

Replies

replied on December 19, 2017

I think you have your order wrong. Entries in a given folder path and not in a volume would be: {LF:LOOKIN="folder path"} - {LF:VolId<>"149"}

0 0

replied on December 19, 2017

So this is what I have now and it is now finding all items in that folder path but not excluding the volume 149

{LF:LOOKIN="folder path"} - {LF:VolId<>"149"}

which the - and the <> must be a double negative because I yielded about 500,000 in items which I know is not correct. So then I tried

{LF:Name="*", Type="DF"}&
{LF:LOOKIN="folder path"}
-{LF:VolId="149"}

and that did work yielding my correct number of entries. Thanks for the help!!

0 0

replied on December 19, 2017

Oops, sorry, I missed that. Yeah, it's supposed to be {LF:VolId="149"} because that's what we want excluded.

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow Search Syntax

Answer

Replies

Sign in to reply to this post.