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

[rezacol]

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

[solutioningnow]

Hi Reza,

Group by option is not available for all the types of fields. It does not support few types.

Please mark answer as correct/helpful, if it was really helpful 🙂

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/

[rezacol]

Hi solutioner now

Isn't there a way to make Group by action enable for that field type? Or can you provide me the list of field types which doesn't support group by option.

Thanks,

Reza

[solutioningnow]

He Reza,

To give you an example, below type of fields doesn't support group by,

List, multiselect like watchlist

Date Fields

Duration fields

etc.

Please mark answer as correct/helpful, if it was really helpful 🙂

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/

[rezacol]

Thanks solutioner now

[Mike Moody · Accepted solution]

Hi Reza,

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

1. Open the report via the Edit link in the left-nav, export the report to XML.
2. Edit the <filter> tag in the XML to have the GROUPBY statement target the field name you want.
3. 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&gt;0^sys_created_by!=guest^urlSTARTSWITH/u_analytics.do^EQ^GROUPBYurl  

Regards,

Michael Moody

Software Engineer

Milestone Technologies, Inc.