A “No Data Exists” action case means that there are no rows or columns of data in the view results for a selected recipient of the action. When there are no rows or columns, then no file share can be generated for File Share actions and no view included as text or attached as an Excel file can be created for Email actions. A filter on the view or the role of a user for whom the action was processed can cause a “No Data Exists” case to occur.
For example, there are no rows and columns returned for a view that tracks excessive returns because no rows satisfy filter criteria of YTD Return Amount greater than $40,000.
Or, a user’s role does not permit them to see any data for any of the levels in the view.
In the following example, the action that created the Weekly Sales Update emails is associated with a view that has filter criteria such that on the first Monday there was data that matched the criteria and on the following Monday there was no data that matched the criteria. An email with view results included in the email was generated the first week (the earlier email). A “No Data Exists” email was generated by the action the second week (the first, most current email below).
Here is the email from the week when no data existed in view results.
Here is the email from the week when data existed.
Results that contain all blank rows and columns will not be considered a “No Data Exists” case. For, example, the following results do not have any rows or columns except for a blank All Others rows. This occurred because the user’s role filtered out all Product Brand rows. The view has at least one row due to the All Other rows; therefore, action results were generated for the user.
