How to add a column in Group By field of reporting?

rezacol · ‎06-27-2014

Hi Guys,

I have a query on how to add some column which are not present in the Group By field on the reporting form for that particular table.

Quick help will be much appreciated.

Thanks,

Reza

Mike Moody · ‎04-17-2015

Hi Reza,

I was able to solve this problem by using the following procedure.

Open the report via the Edit link in the left-nav, export the report to XML.
Edit the <filter> tag in the XML to have the GROUPBY statement target the field name you want.
Save and Import the modified XML file back into the system.

Just keep in mind that if you change this report in the future you will have to repeat this process because the Group By field will be overwritten with the value none.

Example: (I targeted the url field here, which is a field that isn't available to Group By on the syslog_transaction table)

<filter table="syslog_transaction">sys_created_onONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)^sql_count>0^sys_created_by!=guest^urlSTARTSWITH/u_analytics.do^EQ^GROUPBYurl

Regards,

Michael Moody

Software Engineer

Milestone Technologies, Inc.

View solution in original post

inderpal · ‎06-25-2015

Michael, I have tried your option. I am making a List type of report. But i am not getting any filter tag in my XML.
Thanks

Mike Moody · ‎06-25-2015

Hi Inderpal,

That's odd. Do you have a <sys_report action="INSERT_OR_UPDATE"> tag in your xml? It should be the 3rd tag down from the top of the xml file.

inderpal · ‎06-25-2015

Yes, I have that tags in my XML.
Here sharing few of starting lines of my XML.

<?xml version="1.0" encoding="UTF-8"?>

<sc_item_option_mtom action="INSERT_OR_UPDATE">

<request_item display_value="RITM0010055">23eadbea4f3c020026f18c318110c7f2</request_item>

<sc_item_option display_value="afeadbea4f3c020026f18c318110c7f1">afeadbea4f3c020026f18c318110c7f1</sc_item_option>

<sys_created_by>admin</sys_created_by>

Mike Moody · ‎06-26-2015

Hi Inderpal,

That XML doesn't look like an exported report. That looks like an exported record from the Variable Ownership table: /sc_item_option_mtom_list.do. The solution I provided is specific only to exported report records, or any other record types which would implement a condition builder type field.

inderpal · ‎06-27-2015

Hi Moody

I am not getting the way how you want me to export my report in XML format. I am just running my report and after that right clicking on records and then exporting those to XML format. I am not getting any other way of exporting reports in XML format.
Please help more.
Thanks