Skip to main content

ServiceNow group by disabled on new column in list view

ServiceNow group by disabled on new column in list view 


https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715905#:~:text=In%20a%20list%20view%20you,menu%20item%20is%20greyed%20out


In a list view you cannot use the "Group by" functionality on columns if the String type if their maximum lenght is greater that 255 characters. The "Group by" context menu item is greyed out.


workaround:

There is a workaround for this issue, which involves adding the can_group attribute to the affected column of the table.

  1. Navigate to System Definition > Dictionary and access the record name you wish to edit
  2. Open the record and click on Advanced View under Related Links.
  3. In the Attributes field, add 'can_group=true' as the value of the Attributes field (without quotes) and save.
Labels:

Comments

Post a Comment

Popular posts from this blog

ServiceNow check for null or nil or empty (or not)

Haven't tested these all recently within global/local scopes, so feel free to have a play! option 1 use an encoded query embedded in the GlideRecord , e.g.  var grProf = new GlideRecord ( 'x_cls_clear_skye_i_profile' ); grProf . addQuery ( 'status=1^ owner=NULL ' ); grProf . query (); even better use the glideRecord  addNotNullQuery or addNullQuery option 2 JSUtil.nil / notNil (this might be the most powerful. See this link ) example: if ( current . operation () == 'insert' && JSUtil . notNil ( current . parent ) && ! current . work_effort . nil ())  option 3 there might be times when you need to get inside the GlideRecord and perform the check there, for example if the code goes down 2 optional routes depending on null / not null can use gs.nil : var grAppr = new GlideRecord ( 'sysapproval_approver' ); var grUser = new GlideRecord ( 'sys_user' ); if ( grUser . get ( 'sys_id' , current . approver )){
Post a Comment
Read more

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }
20 comments
Read more