Some reports for DRA not displaying the correct number of rows with QueryLimit (NETIQKB71632)

  • 7771632
  • 22-Jul-2009
  • 21-Apr-2010

Environment

NetIQ Directory & Resource Administrator 8.5

Situation

Some reports for DRA not displaying the correct number of rows with QueryLimit
{QueryLimit} tag in NetIQ Reporting Center 1.1 for NetIQ Directory & Resource Administrator does not show the correct number of rows.

Resolution

A new tag - {QueryLimit} - can be added as a part of the queries used to create reports in NRC 1.1.

When a value is set for this property on any of the reports, it limits the amount of rows that the query retrieves to the QueryLimit value when the report is executed. The value for this tag can be set using the Property available in the Console. This property will be enabled only if the tag exists in the report.

This functionality can be used to view a sample of the data that the report generates. A sample that shows the usage of the QueryLimit tag when used against the Microsoft provided NorthWind database is shown below:


Report : Sales by Category

Without Query Limit

<QUERY TYPE="NetIQ.ACLib.ACSQLQUERY,NQACLib">
                <!-- The TEMPLATE Tag is the Query template used for the report -->
                <!-- This tag should always have a CDATA tag-->2:49 PM 2/20/2006
                <!-- Context Substitution are not case sensitive-->
                <!-- -->

                <Template> <![CDATA[

                SELECT [Category Name] = [CategoryName], [Total Sales] = Sum([ProductSales])
                FROM [Northwind].[dbo].[Sales by Category]
                WHERE [CategoryName] in ({UDContext[1].FLDRNAME})
 
                group by [CategoryName]
                                               
                ]]></Template>
        </QUERY>

With Query Limit

<QUERY TYPE="NetIQ.ACLib.ACSQLQUERY,NQACLib">
                <!-- The TEMPLATE Tag is the Query template used for the report -->
                <!-- This tag should always have a CDATA tag-->2:49 PM 2/20/2006
                <!-- Context Substitution are not case sensitive-->
                <!-- -->
 
                <Template> <![CDATA[
               
                SELECT {QueryLimit} [Category Name] = [CategoryName], [Total Sales] = Sum([ProductSales])
                FROM [Northwind].[dbo].[Sales by Category]
                WHERE [CategoryName] in ({UDContext[1].FLDRNAME})

                group by [CategoryName]

                ]]></Template>
        </QUERY>

Set Query Limit Default Value :

<STANDARD QueryLimit="N">

N = Numeric value

Additional Information

Formerly known as NETIQKB71632