How to get the database query result

OL Connect Professional
1

Hi all,

I have a process like below:-
image

  1. capture the file name from a folder
  2. do a dynamic database query “Select count(*) from a TABLE where field = ‘O%’”
  3. if (2) >0 then do move the excel file to somewhere
    i don’t know how to gather the reult of (2) and put it into the process.

thanks is advance.

Best regards,
Joey Tsui

2

Hi @joeytsui,

The result of the database query is output in the selected data format in the Output file emulation box of the Database Query Workflow plugin, which you can access by right clicking on the Database Query Workflow plugin, selecting the option “Properties…” and by going to: Properties (window) > Database Connection (tab) > Emulation (section) > Output file emulation.