Question

Expressions in Workflow Search Query

Search and Retrieval

Updated November 12, 2015

asked on November 12, 2015

I want to find all documents where the template last name is not blank and the document name is 6 digits. I tried using expressions as follows but get zero (0) results:

{[RCRMC]:[NAME_LAST]not=""} & {LF:Name="(\d\d\d\d\d\d)", Type="DB"} & {LF:LOOKIN="HRDev\BUILD DOCUMENTS\RCRMC"}

The following works, but takes a long time to run:

{[RCRMC]:[NAME_LAST]>" "} & {LF:Name >"111111", Type="DB"} & {LF:LOOKIN="HRDev\BUILD DOCUMENTS\RCRMC"}

Can you recommend a better syntax?

0 0

Replies

replied on November 12, 2015

Instead of "not=" try <>. so it would be {[RCRMC]:[NAME_LAST]<>""} & {LF:Name="(\d\d\d\d\d\d)", Type="DB"} & {LF:LOOKIN="HRDev\BUILD DOCUMENTS\RCRMC"}

1 0

replied on November 12, 2015

Of course! I drew a complete blank for the <>; thank you. However, the expressions (\d\d\d\d\d\d) and (\d{6}) do not appear to work.

0 0

replied on November 12, 2015

Correction; it works! I forgot to eliminate the space between "". Both digit expressions work.

Thanks!

0 0

You are not allowed to follow up in this post.

Question

Question

Expressions in Workflow Search Query

Replies

Sign in to reply to this post.