When configuring the Custom Query activity in Workflow, does the option you choose for the 'Rows to Return' section alter the Select statement? For example, if my custom query is:
SELECT column1, column2, column3 FROM laserfiche WHERE column1 = '123'
If I select 'First row only', does it alter the query to:
SELECT TOP (1) column1, column2, column3 FROM laserfiche WHERE column1 = '123'
or is it returning all rows and then Workflow is filtering out the results?