# Report column having no value **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** rules, reports, reporting, apis, identityiq\ **Created:** [April 9, 2025, 2:08pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542 "2025-04-09T14:08:38Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\ **Post date:** [April 9, 2025, 2:08pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/1 "2025-04-09T14:08:38Z")
Hi all, I am trying to generate a report which would give an attribute “backupowner” of roles/bundles. I am trying the below code for getting the attribute but the column does not have any value when the report is run. Am I missing something? ```auto import sailpoint.tools.Util; String roleName = (String) renderCache.get(value); if (roleName != null) { Identity pickedRole = context.getObject(Bundle.class, roleName); if (pickedRole != null) { return pickedRole.getAttribute("backupOwner"); } return ""; ``` ---
**Author:** ![Arun-Kumar](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arun-kumar/32/15128_2.png) [@Arun-Kumar](https://developer.sailpoint.com/discuss/u/Arun-Kumar)\ **Post date:** [April 9, 2025, 2:50pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/2 "2025-04-09T14:50:19Z")
Hi @rishavghoshacc , Try with below code. ```auto import sailpoint.tools.Util; String roleName = value; if (roleName != null) { Bundle pickedRole = context.getObject(Bundle.class, roleName); if (pickedRole != null) { return pickedRole.getAttribute("backupOwner"); } return ""; ``` ---
**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\ **Post date:** [April 9, 2025, 3:11pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/3 "2025-04-09T15:11:36Z")
@Arun-Kumar it still comes out as empty ---
**Author:** ![Arun-Kumar](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arun-kumar/32/15128_2.png) [@Arun-Kumar](https://developer.sailpoint.com/discuss/u/Arun-Kumar)\ **Post date:** [April 9, 2025, 3:22pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/4 "2025-04-09T15:22:49Z")
Hi @rishavghoshacc , Print the value and check whether you get the value or not. What is the objectType of the report? Is it Bundle? Could you please share the report xml? Bundle having beackupOwner attribute? ---
**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\ **Post date:** [April 9, 2025, 3:37pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/5 "2025-04-09T15:37:20Z")
@Arun-Kumar Backupowner is just an attribute that is added to the bundles. It is working when I try to get through a rule. Logs does not having anything PFA xml [Role Backup Owners Report.xml](https://developer.sailpoint.com/discuss/uploads/short-url/2swW3YksaarCKc8dUXfe5fKKiGj.xml) (3.8 KB) ---
**Author:** ![Arun-Kumar](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arun-kumar/32/15128_2.png) [@Arun-Kumar](https://developer.sailpoint.com/discuss/u/Arun-Kumar)\ **Post date:** [April 9, 2025, 4:48pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/6 "2025-04-09T16:48:11Z")
Hi @rishavghoshacc , RenderScript will not work on Java datasource. You can create a new report with Filter datasource. ---
**Author:** ![kalyan\_dev32](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kalyan_dev32/32/21870_2.png) [@kalyan\_dev32](https://developer.sailpoint.com/discuss/u/kalyan_dev32)\ **Post date:** [April 9, 2025, 4:50pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/7 "2025-04-09T16:50:33Z")
It seems like you’re working with a Java-based report in SailPoint that was originally implemented for a different purpose. When you attempted to extend it by adding custom logic specifically for the` backupOwner` field that’s where the issue arises. The core problem is that the report’s Java class, likely `RoleDetailsDataSource`, doesn’t include logic to handle the `backupOwner` field. Even though you tried adding a `renderScript` to address this, it still fails. Why? Because the `ReportColumnConfig` field name you’re referencing isn’t defined in the Java class. As a result, the class doesn’t recognize it, and the value returned for that field will be null. To better understand what’s happening under the hood, I’d recommend using IntelliJ or a decompiler to inspect the implemented logic in the `RoleDetailsDataSource` class. This will give you a clearer picture of how the class processes data and why it’s not accommodating your custom field. That said, here are my suggestions: 1. If you want to develop a fully custom Java-based report: Check out this SailPoint Community blog post for a step-by-step guide on creating reports with a Java DataSource: [Reporting with a Java DataSource](https://community.sailpoint.com/t5/IdentityIQ-Wiki/Reporting-with-a-Java-DataSource/ta-p/159377). It’s a solid resource for building something tailored to your needs from scratch. 2. If you prefer using HQL or filter-based logic: Take a look at SailPoint’s OOTB reports. These often leverage HQL or filters and might offer a simpler way to achieve your goal without diving too deep into custom Java code. For more info, I’d also recommend reviewing SailPoint’s official reporting documentation. It’ll provide additional context on how reports are structured and what options are available to you. Let me know if you need help with specific steps! ---
**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\ **Post date:** [April 10, 2025, 8:25am UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/8 "2025-04-10T08:25:33Z")
@Arun-Kumar I got it to work. Thanks to you. Can you help me in skipping the roles that don’t have the attribute. At the moment I am getting all the roles even if the attribute is not there ---
**Author:** ![Arun-Kumar](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arun-kumar/32/15128_2.png) [@Arun-Kumar](https://developer.sailpoint.com/discuss/u/Arun-Kumar)\ **Post date:** [April 10, 2025, 4:55pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/9 "2025-04-10T16:55:15Z")
HI @rishavghoshacc , If you’re creating a report with a Filter datasource, include the `QueryScript` in the **QueryParameter** section. Also, ensure that the `backupOwner` attribute is marked as searchable. ```auto import sailpoint.object.QueryOptions; import sailpoint.object.Filter; queryOptions.addFilter(Filter.notnull("backupOwner")); return queryOptions; ``` ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [June 9, 2025, 4:55pm UTC](https://developer.sailpoint.com/discuss/t/report-column-having-no-value/109542/10 "2025-06-09T16:55:30Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.