Service Portal "group by" functionality

[JusCuz]

Does anyone know how I can achieve group by functionality in the Service Portal?

I would like to display a list of incidents and group they by priority.....any ideas?

[oliverschmitt]

Hi Jason,

I guess that should still work: Navigating by URL - ServiceNow Wiki

Look at the 9th bullet point:

• sysparm_query=priority=2^active=true^EQ^GROUPBYcategory: groups query results (by category).

[JusCuz]

I've thought of that, but how would you get that to render in Service Portal, as a page within Service Portal rather than a separate independent page? There is the widget 'Data table from URL definition' but there is no documentation that I've found on how to actually use that widget, and it will not accept the syntax listed in your link above.

Using that widget, you get this message on your page: "Select table on field below or specify on URL ?id=list&table=table_name" I've tried ?id=incident_list&table=incident but that is not accepted.

[oliverschmitt]

Hi Jason,

I have to admit that I dont know the widget in detail but this at least works with the grouping: "https://INSTANCENAME.service-now.com/incident_list.do?sysparm_query=active%3Dtrue%5EEQ%5EGROUPBYprio..."

Hope that helps!

[JusCuz]

Oh absolutely, the problem is using a url like that will then take you out of service portal, any incident you click on will also remove you from service portal