I would like to create a workflow to implement the following process:
Trigger a workflow to start daily at 8am and query a table in a SQL Server database (I've already created the service instance and smart object).
If the table contains records where the "Serial Number" field = Null OR the "Price" field = Null, I would like to send an email to notify a coworker about the incomplete records.
Is this possible in K2 workflow, and how may I achieve this? Will I need to create a stored procedure in the sql database to return the incomplete records or is it possible to do this from the workflow?
Any help or advice is very much appreciated!!!