You are viewing limited content. For full access, please sign in.

Question

Question

Search Repository using date token is not working

asked on March 8, 2017 Show version history

Why is this Search Query not working?  

  • In the LF Client, the Search Syntax that I want is this:  {LF:Name="20*", Type="D"} & {LF:Created="2017-03-08"}
  • In the WF, I know I need to replace today's date with the date token: {LF:Name="20*", Type="D"} & {LF:Created>"%(Date)"} 

 

The WF is set to run each day, pull up "today's" newly created documents, and then for each one found, do a task for me.  But the Search Repository activity is not finding any documents.  When I try the "Test Search Query" it shows that the date token is coming up blank (takes me to this little window - see below) and then gives me this error message: "The search parameter is invalid. [9245]".  I have tried it without the quotes around the date token, as well; resulting in the same thing, just a different search error number.

Can anyone see what is wrong in the Search Query?

0 0

Answer

SELECTED ANSWER
replied on March 9, 2017

When you're testing the activity, it will run the search against whatever date you specify.

When the workflow runs normally in production, it will use the whatever the current date is.

1 0

Replies

replied on March 8, 2017

Hi Connie,

In your second search syntax, you're using the greater sign (>) instead of equal (=) when comparing it with the %(Date) token value. That might be the issue why actually running the workflow isn't returning any results. Change it to an equal sign and see if that corrects the matter.

As for testing the "search repository" activity, you need to actually specify a date value to use for that token like below:

2 0
replied on March 9, 2017 Show version history

Thanks, Alexander!  I've corrected the > vs =.  

If I enter today's date in that Value spot, will the activity know to change it the next time it's run?  Or will it look for March 8th every day that it is run?  

Note:  The Help button on that window takes me to a page that says, "...can't find the page you're looking for..."

0 0
SELECTED ANSWER
replied on March 9, 2017

When you're testing the activity, it will run the search against whatever date you specify.

When the workflow runs normally in production, it will use the whatever the current date is.

1 0
replied on March 9, 2017

Awesome!  Thanks!

0 0
replied on March 9, 2017

That worked!!!  Thanks so much for the help!

0 0
replied on March 9, 2017

Thanks for reporting the broken Help button. We'll fix it.

0 0
replied on April 9, 2020

Just what I was looking for - I needed to check to see if a shortcut had already been created today and this did the trick, thanks!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.