How to get the count of records in Group in XML Publisher Data Template

Hi Team,

Hi Team,

We are using R12.2.3

We have a requirement to fetch the Items from Inventory which are created in a period of time (We will pass creation date from and To as Concurrent Program parameters). And, if there are any records, then bursting program need to be called and then email that list(It is excel output). They need email only when there are any records fetched.

So, we created XML Data Template as below

1. <?xml version = '1.0' encoding = 'UTF-8'?> 
2. <dataTemplate name="XX_ITEMS" defaultPackage="XX_ITEMS_PKG" Version="1.0">  
3. <properties> 
4.       <property name="debug_mode" value="on"