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.