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.

[tysonwenger]

I also made a list in a gauge and can't get it to group by the task type.   There is a group field, but when I select this the list does not group by the field I select.

[yetesh_ch]

Hi Tyson,

I tried this and this should work.

1. Select Link Type as 'URL(from Arguments:)'

2. In Arguments field, write this:

task_list.do?sysparm_query=GROUPBYsys_class_name

Hope it helps!

[tysonwenger]

I was trying to do it using the list type, not the url type.   That way I can put filter options in the form.

[yetesh_ch]

Hi Tyson,

You can add your filter options in sysparm_query parameter of URL. For example, if you want all the 'active' Tasks grouped by Task Type, then you can do like:

task_list.do?sysparm_query=active%3Dtrue^GROUPBYsys_class_name

Hope its clear!