Module for list of records and group by

[tysonwenger]

Hi,

I'm trying to create a list showing tasks opened by users.   I added a new module and selected Link Type as "List of Records".   This works fine, but now I want the list to automatically group by the task type when the user views it.   My problem is there is no arguments option when I pick that link type so I can't set "groupby" anywhere.     I would prefer not to manually type all my filter options out in a URL which seems to be the alternative for auto grouping of records.  

Is there another alternative that anyone knows about?  

Also, I want this same list that will be shown in the module to also appear in our ess homepage.   So I'd like to create the list once with the predefined filters, and then use it in a module and homepage.   Any help would be much appreciated.

Thanks.

[alan_lowrance]

Yetesh, the reason we want to use a "List" gauge instead of a URL is because we don't want the NEW and EDIT buttons and everything at the top.   We want it to just be a list gauge on a homepage.

[Mike Allen · Accepted solution]

Can you start it in Reports and Make a Gauge from that?

[Mike Allen]

You can also just have your module run the report you create.

[alan_lowrance]

Still didn't look right, but I decided to just not group the list.   Thanks

[tobrien]

Hi Mr. Tyson ...

I needed to this very operation. I saw this thread and started a deeper look-see and found you CAN do a "list" with a GROUP BY in a module definition.

Use the "URL (From Arguments)" and use something like: (note the "_list.do"

https://TheNameOfYourInstance.service-now.com/{tableName}_list.do?sysparm_query={someFieldName}={someValue}^EQ^GROUPBY{columnName}

Where

{tableName} => a table, like alm_asset

These next two are essentially the FILTER aspect.

{someFieldName} => a field in that table

{someValue} => a value that field could have

This last one is the GROUPing column name

{columnName}