Skip to main content
Kofax

Configuring distribution of reports to multiple recipients

Article # 3036320 - Page views: 15

Issue

How to configure Advanced reports to support multiple values with separator?

 

Solution

Advanced report does not support multiple values with separator.

If required multiple values then each value should be in separate row.

All non-empty values from one column are combined and used as filter with OR.

Different columns are user in filter with AND.

1. if a user wants to send report to multiple users, then each e-mail should be in separate row:

1, user1@domain.com

1, user2@domain.com

2, user3@domain.com

2. If multiple values for multiple filters should be applied then each value should be in separate row (but values from different columns can be mixed).

Here are some samples:

A)

ProductID, Country

10, USA

11, UK

B)

ProductID, Country

10, UK

11, USA

C)

ProductID, Country

10, ''

11, ''

'', UK

'', USA

In all these samples the result will be the same:

fitler for productID will be union, empty or NULL values ignored: (10 Or 11), for Country too: (UK OR USA) and two columns will be combined with AND. So the result will be:

(ProductID = 10 OR ProductID = 11) and (Country = USA or Country = UK)

About combine different conditions by rows like “ProductID = 10 AND Country = USA” OR “ProductID = 11 AND Country = UK” - this is not possible.

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
Insight All N/A N/A N/A

 

References

Add any references to other internal or external articles

 

 

Article # 3036320
  • Was this article helpful?