Posted Sun, 08 Sep 2019 00:50:13 GMT by Doug Mackle
Question: I need to create a list  with Documents that only end in a specific value.

Business Problem: Client needs to sample every 20th Deal submitted to Docuware

Configuration: I have a workflow that is triggered when a new deal is submitted. I am using an Assign Data activity to store the value of an arithematic expression that divides the DocID by 20 and stores the value to a decimal field. Then I am copying that value to a text field. 

I am trying to use a list to return only the documents that end in .00 in the text field with the following where clause like '%'.00, but i am not getting any results.
Posted Mon, 09 Sep 2019 14:52:15 GMT by Tim Ohm
The "is (where)" in the 2nd column is actually your "like" qualifier.  So I think just include the value you want in the last column "*.00" should do it.  Not sure if you would need quotes around it - whatever you would use in a search dialog can go in the list definition.

You would only use "%" if using an actual SQL statement.

You must be signed in to post in this forum.