Phased rollout This version of the software is currently available only to early adopter SaaS customers as the first step in our phased rollout. Click here to view an earlier version.

Troubleshooting issues related to calculated fields

This topic describes the issues related to calculated fields.

Issue symptom

Smart Reporting subqueries do not work.

Issue scope

You run a single SQL statement between two different data sources.

Resolution

Because the advanced subquery treats each subquery as an individual SQL query, for Smart Reporting to ensure that all possible matches are found for the join conditions, there cannot be any limit on the subquery dataset. To make subqueries work efficiently, do not apply row limit on the data source. Instead, apply row limit in the data source custom parameters. 

For more information, see the How to increase the row limit article on BMC Communities.

Suquery.png


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*